Page 1 of 1

csv data into mysql db

Posted: Mon May 05, 2008 2:21 am
by prashantAG
my code is below
Note: it shows error :Array ( [0] => ANAND,anand.pandey,anandiete@gmail.com ) Column count doesn't match value count at row 1
2.

<?php
$fcontents = file ('C:\Documents and Settings\winfo2\Desktop\user.csv');
# expects the csv file to be in the same dir as this script

for($i=1; $i<sizeof($fcontents); $i++) {
$line = trim($fcontents[$i]);

$arr = explode("\t", $line);
$newarr=implode(' ,' ,$arr);
// print_r($newarr);
//$sql="Insert into CSV(firstname,username,emaila) values('$newarr')";
$sql="Insert into CSV (firstname,username,emaila) values('mysql_real_escape_string($newarr)')";

//$sql = "insert into CSV values ('". implode("','", $arr) ."')";
mysql_query($sql);
//echo $sql ."<br>\n";
if(mysql_error()) {
echo mysql_error() ."<br>\n";
}
}
?>

Re: csv data into mysql db

Posted: Mon May 05, 2008 3:20 am
by Christopher
You might want to look into the LOAD DATA INFILE statement. It is faster too.

Re: csv data into mysql db

Posted: Mon May 05, 2008 6:48 am
by prashantAG
thank u
arborint