RE: [PHP] Uploaded CSV -> database
| From: | Jim Moseby | Date: | Mon, 17 Oct 2005 14:40:30 +0000 |
| Subject: | RE: [PHP] Uploaded CSV -> database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-224231@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Brian Dunning [mailto:brian@briandunning.com]
> Sent: Monday, October 17, 2005 10:37 AM
> To: php-general@lists.php.net
> Subject: [PHP] Uploaded CSV -> database
>
>
> Does anyone have an example of code to process a CSV file submitted
> via a file upload and parse it out in order to write its
> records to a
> db?
>
With MYSQL (assuming permissions and such are in order) You would simply:
$sql="load data local infile '/path/to/csv' into table tablename fields
terminated by ','";
JM