Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
M

Mohammed Hudair

@Mohammed Hudair
About
Posts
1
Topics
1
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • How to import csv using php code
    M Mohammed Hudair

    I would to import csv products to mysql using below codes but i don't know what framework to use the data is large more than 100000 products

    prepare("SELECT COUNT(*) AS c from products WHERE id=?");
    $result = $query->execute([$fields[0]]);
    if($query->rowCount()) {
    $pdo->query('DELETE FROM products WHERE id = "' . $fields[0] . '"');
    print('Deleted existed product to be updated.');
    }

            $query = $pdo->prepare('INSERT INTO products (id, name, sku,status,variations, price, currency) VALUES (?, ?, ?, ? , ? , ?, ?)');
            $result = $query->execute(\[$fields\[0\], ($fields\[4\] ?? ''), ($fields\[5\] ?? ''), ($fields\[6\] ?? ''), ($fields\[9\] ?? ''), ($fields\[10\] ?? '') \]);
    
            // TODO: Soft delete no longer exist products from the database.
    
            $i++;
        }
    
        die('Updated ' . $i . ' products.');
    }
    

    }

    Linux, Apache, MySQL, PHP database php mysql tutorial question
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups