inserting data into mysql

[anom]

I have a simple loop
include '../php_library/connect.php';
include '../php_library/opendb.php';

$conn=mysql_connect($host,$dbuser,$dbpass) or die ('Error');
mysql_select_db($dbname);
//Open the file
$fp = fopen($src,"r");
//for each line in the file
while ($row=fgetcsv($fp,10000,';')) { //Get line
$sql_insert="INSERT INTO ...";
if (!mysql_query($sql_insert,$conn)){
OutputError($sql_insert,$mysql_error());
$FailedCount++;
}
else {$InsertCount++;}
}
It works fine for the first couple of hundred or so rows but the stops -
no errors, it just stops mid-loop.

I'm guessing some sort of buffer problem (needs flushing?) but it is a
guess.

I'm running this all locally - XP, Apache2, PHP5, mySQL 4.1

Keith

[Tim Van Wassenhove]

On 2005-09-06, anom <an******@hotmail.co.uk> wrote:

I have a simple loop
include '../php_library/connect.php';
include '../php_library/opendb.php';

$conn=mysql_connect($host,$dbuser,$dbpass) or die ('Error');
mysql_select_db($dbname);
//Open the file
$fp = fopen($src,"r");
//for each line in the file
while ($row=fgetcsv($fp,10000,';')) { //Get line
$sql_insert="INSERT INTO ...";
if (!mysql_query($sql_insert,$conn)){
OutputError($sql_insert,$mysql_error());
$FailedCount++;
}
else {$InsertCount++;}
}
It works fine for the first couple of hundred or so rows but the stops -
no errors, it just stops mid-loop.

Prepend the following to your script:

ini_set('error_reporting', E_ALL);
ini_set('display_errors', TRUE);

I've got a feeling you will see a message like: max execution time has
been exceeded... http://www.php.net/set_time_limit
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>

[anom]

Tim Van Wassenhove wrote:

On 2005-09-06, anom <an******@hotmail.co.uk> wrote:

I have a simple loop
include '../php_library/connect.php';
include '../php_library/opendb.php';

$conn=mysql_connect($host,$dbuser,$dbpass) or die ('Error');
mysql_select_db($dbname);
//Open the file
$fp = fopen($src,"r");
//for each line in the file
while ($row=fgetcsv($fp,10000,';')) { //Get line
$sql_insert="INSERT INTO ...";
if (!mysql_query($sql_insert,$conn)){
OutputError($sql_insert,$mysql_error());
$FailedCount++;
}
else {$InsertCount++;}
}
It works fine for the first couple of hundred or so rows but the stops -
no errors, it just stops mid-loop.

Prepend the following to your script:

ini_set('error_reporting', E_ALL);
ini_set('display_errors', TRUE);

I've got a feeling you will see a message like: max execution time has
been exceeded... http://www.php.net/set_time_limit

Thank you - spot on