Preparing SQL insert statements from CSV files
| From: | T K | Date: | Fri, 05 Oct 2007 02:01:29 +0000 |
| Subject: | Preparing SQL insert statements from CSV files | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44156@lists.php.net to get a copy of this message | ||
Hi,
I have to parse csv files and put them into database. I was able to
parse the files by fgetcsv() and made an HTML table. But, when it
comes to parse more closely and make "INSERT INTO" statement, then I'm
having problems with, probably "for-loop".
For example, how do you do this task with the simple csv file shown at
https://admin.easymail.rmplc.co.uk/admin_help/csv.htm
.
T