Import data from CSV
Select all
<?php // connect to your database $handle = fopen("data_file.csv", "r"); $data = fgetcsv($handle, 1000, ","); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { // collect all data in tha line by 0,1,2 etc $field_name=addslashes($data[0]); // form insert query to insert into mysql mysql_query($query); } fclose($handle); ?>