How to import excel csv-file into your mysql db using php?

[keith23]

Hi all .i got a excel .csv file and i want to import it to mysql database but i do not know how to write a php script that does the job for me. I be happy if an expert show me how.Thanks

 

[sleipnir214]

You may not need a PHP script to do this at all. If you can get the file to a place where MySQL can see it on a filesystem, then you can use a LOAD DATA INFILE query to dump the data in in one go. See

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Want the best answers? Ask the best questions! TANSTAAFL!