ممكن تستخدم شيء مشابه:
كود PHP:
set_time_limit(5*60);
$file = 'test.csv';
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '123456';
$dbname = 'test';
$table = 'table';
$column = 'column';
$fp = fopen($file,'r');
$db = mysql_connect($dbhost,$dbuser,$dbpass) or die("Database error");
mysql_select_db($dbname, $db);
$count = 0;
while($line = fgetcsv($fp)){
$line = addslashes(implode('',$line));
mysql_query("INSERT INTO $table ($column) VALUES ('$line')");
++$count;
}
fclose($fp);
mysql_close($db);
echo $count .' entries inserted successfully.';