Subject | interrupted php script while accessing firebird... what happens? |
---|---|
Author | Xavier Solé |
Post date | 2003-03-19T16:11:38Z |
Hello,
I would like to know what happens when a user clicks on the "Stop" button of
a browser while a php script is returning the results of a Firebird query.
Imagine the script is in that moment accessing the results of a query with a
loop like this:
$dbh = ibase_connect(.....);
$stmt = "SELECT BLA, BLA...";
$sth=ibase_query($dbh,$stmt)
while ($row=ibase_fetch_object($sth)
{
... printing result in the client browser
}
If the result of the query is big enough, it may take some time to show all
the rows in the browser, and the user may get tired of waiting. If he stops
the script, does firebird continue processing the query until it finishes?
I hope my question is understood. I don't know if this has to do with the
webserver or with firebird, and would appreciate any commments on this.
Thanks,
Xavier.
-------------------------------------------------
Xavier Solé - x.sole@...
Cancer Epidemiology
Catalan Institute of Oncology
Av. Gran Via s/n, km. 2,7
08907 L'Hospitalet de Llobregat,
Barcelona, Catalonia.
Tel: +34 93 260 74 01
Fax:+34 93 260 77 87
I would like to know what happens when a user clicks on the "Stop" button of
a browser while a php script is returning the results of a Firebird query.
Imagine the script is in that moment accessing the results of a query with a
loop like this:
$dbh = ibase_connect(.....);
$stmt = "SELECT BLA, BLA...";
$sth=ibase_query($dbh,$stmt)
while ($row=ibase_fetch_object($sth)
{
... printing result in the client browser
}
If the result of the query is big enough, it may take some time to show all
the rows in the browser, and the user may get tired of waiting. If he stops
the script, does firebird continue processing the query until it finishes?
I hope my question is understood. I don't know if this has to do with the
webserver or with firebird, and would appreciate any commments on this.
Thanks,
Xavier.
-------------------------------------------------
Xavier Solé - x.sole@...
Cancer Epidemiology
Catalan Institute of Oncology
Av. Gran Via s/n, km. 2,7
08907 L'Hospitalet de Llobregat,
Barcelona, Catalonia.
Tel: +34 93 260 74 01
Fax:+34 93 260 77 87