Thread: Help importing CSV file into MySql

That error indicates that the number of columns you are inserting into does not match the number of values you are inserting. You should use mysql_real_escape_string to handle the quotes for each value, or an adapter that has prepared statements, such as PDO. You should also look into MySQL's LOAD DATA ... http://dev.mysql.com/doc/refman/5.1/en/load-data.html

I am trying to import a csv file, comma delimited, into MySql database. This is my script: $fcontents = file ('./importfile.csv'); for($i=0; $i<sizeof($fcontents); $i++) { $line = trim($fcontents[$i]); $arr = explode(",", $line); $sql = "insert into books values ('". implode("','", $arr) ."')"; mysql_query($sql); echo $sql...