PHP MySQL查询在1273459循环后停止

Question

I am using the script:

$file=fopen('part1.csv', 'r');

mysql_connect('localhost', '~~~', '~~~') or die(mysql_error());
mysql_select_db('Stubby') or die(mysql_error());

while (($buffer = fgets($file, 4096)) !== false) {
    //echo $buffer;
    $q = mysql_query('INSERT INTO allCombos (combo) VALUES (\'' . $buffer . '\')') or die(mysql_error());
}

fclose($file);

To load the very long contents of a CSV into a database. The CSV has around 3.5M lines. The querys stop at 1273459 lines. Why?

Answer 1

PHP generally sets its default script load timelimit to 30 seconds; you're probably hitting that limit. You can manually override it.

set_time_limit(0); //sets the time limit to infinity
set_time_limit(600); //sets the time limit to 10 minutes

Another possibility is that your script has run out of memory. You can raise it by doing something like:

ini_set('memory_limit', '32M'); //raises limit to 32 megabytes