web design experts based in Birmingham, covering The Midlands & The UK

client area

Get updated enter your details to receive updates from us

Importing from CSV to MySQL in PHP

0

in: by: Jon Newman – 22/12/2011

At Globalgraphics we build a lot of e-commerce websites, these often have lots of products within them which a lot of the time we import from a CSV.Because all products needed to be inserted one-at-a-time into the database (because each record needed to have certain things calculated) we couldn’t do a simple mysql command “LOAD DATA LOCAL” as this simply dumps the contents into a table. The usual practise then…

Continue Reading » Importing from CSV to MySQL in PHP

latest comments