Re: Parsing CSV files into a MySQL Table
| From: | Matt M. | Date: | Tue, 02 Nov 2004 14:00:13 +0000 |
| Subject: | Re: Parsing CSV files into a MySQL Table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37140@lists.php.net to get a copy of this message | ||
> //<?php
>
> mysql_connect (localhost, foouser, foologin);
>
> mysql_select_db (footest1);
>
> $csvfile = file("http://foo.com/foolist.csv");
>
> foreach($csvfile as $line_no => $datastring) {
> $data = explode (",", $datastring);
> $foo1 = $data[0];
> $foo2 = $data[1];
> $foo3 = $data[2];
> $foo4 = $data[3];
> $foo5 = $data[4];
> $foo6 = $data[5];
> $foo7 = $data[6];
>
> mysql_query ("INSERT INTO 'footable' (foo1, foo2, foo3, foo4, foo5,
> foo6, foo7)
> VALUES '$foo1', '$foo2', '$foo3',
> '$foo4', '$foo5', '$foo6', '$foo7')");
> }
>
> //?>
try this
mysql_connect (localhost, foouser, foologin);
mysql_select_db (footest1);
$csvfile = file("http://foo.com/foolist.csv");
while (($data = fgetcsv($csvfile, 1000, ",")) !== FALSE) {
$foo1 = $data[0];
$foo2 = $data[1];
$foo3 = $data[2];
$foo4 = $data[3];
$foo5 = $data[4];
$foo6 = $data[5];
$foo7 = $data[6];
mysql_query ("INSERT INTO 'footable' (foo1, foo2, foo3, foo4,
foo5, foo6, foo7)
VALUES '$foo1', '$foo2', '$foo3', '$foo4',
'$foo5',
'$foo6', '$foo7')");
}