note 66848 added to function.ibase-query
| From: | apolenary at mail dot ru | Date: | Wed, 31 May 2006 01:20:00 +0000 |
| Subject: | note 66848 added to function.ibase-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-112579@lists.php.net to get a copy of this message | ||
In woking time ibase_qury() and ibase_fetch_row() with many time call thei arise the ERROR ->
Fatal error: Maximum execution time of 30 seconds exceeded
ERROR arise in that script:
foreach ($vidtr_list as $vidtr)
{
foreach ($branches_train as $from)
{
foreach ($branches_train as $to)
{
if (isset($pricelst_train[$vidtr][$from][$to]['ID']))
{
for ($i = 1; $i < 7; $i++)
{
$id = $pricelst_train[$vidtr][$from][$to]['ID'];
$sql_v = "SELECT * FROM
P_GET_PRICE_C_VES('$id','$std_train1_ves[$i]')";
$query_rez = ibase_query($db,$sql_v) or die(ibase_errmsg());
$prc_v = ibase_fetch_row($query_rez);
$sql_o = "SELECT * FROM P_GET_PRICE_C_OBYOM('$id',
'$std_train1_obyom[$i]')";
$query_rez = ibase_query($db,$sql_o) or die(ibase_errmsg());
$prc_o = ibase_fetch_row($query_rez);
if (isset($prc_o[0]))
{
$c_obyom = $prc_o[0];
$c_ves = $prc_v[0];
$prices_train[$id][$i] = array( 'OBYOM' => $c_obyom,'VES' => $c_ves );
$mysql_jde_price[$cnt_price] = "INSERT INTO jde_price VALUES (default, '$id',
'$std_train1_ves[$i]', '$c_ves', '$std_train1_obyom[$i]',
'$c_obyom');";
$cnt_price++;
}
}
}
}
}
}
How I can decide that Error?
----
Server IP: 195.222.164.18
Probable Submitter: 82.162.157.20
----
X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER
autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/function.ibase-query.php
Edit -- http://master.php.net/note/edit/66848
Del: integrated -- http://master.php.net/note/delete/66848/integrated
Del: useless -- http://master.php.net/note/delete/66848/useless
Del: bad code -- http://master.php.net/note/delete/66848/bad+code
Del: spam -- http://master.php.net/note/delete/66848/spam
Del: non-english -- http://master.php.net/note/delete/66848/non-english
Del: in docs -- http://master.php.net/note/delete/66848/in+docs
Del: other reasons-- http://master.php.net/note/delete/66848
Reject -- http://master.php.net/note/reject/66848
Search -- http://master.php.net/manage/user-notes.php