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";
}
}
?>
csv data into mysql db
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: csv data into mysql db
You might want to look into the LOAD DATA INFILE statement. It is faster too.
(#10850)
-
prashantAG
- Forum Newbie
- Posts: 7
- Joined: Wed Apr 30, 2008 1:31 am
Re: csv data into mysql db
thank u
arborint
arborint