It appears that execution does stop if there is any output to the
browser. I usually do all of my "query work" before sending output to
the browser which would explain why I haven't seen it fail to complete.
I think this is what happens:
mysql_db_query(blaaa); <---- These three should happen regardless.
echo "blaaa"; <---------- This point could stop if
user has hit stop when it gets there.
Anyone know different? Anyway, ignore_user_abort(true); seems to do the
From: Alan Langford [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 3:48 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP Processing
Do a search for "user stop" in the PHP manual, there you will find
"connection handling" and the ignore_user_abort function.
At 2004/01/05 17:14, Peter Westergaard wrote:
>I'm sorry, I feel dense coming to the list for this, because I'm SURE
>I've read about this in the PHP or Mysql docs, but I can't seem to
>Let's say users submit a form which is processed by a PHP page which
>performs a number of MySQL INSERT, UPDATE, and/or DELETE commands.
>What happens if the user hits "Stop" or "Refresh" in their browser
>before the transaction is complete - is there a possibility that
>only some of the MySQL commands will complete? Not a problem if
>the services are all running well, but I'm thinking if things are
>getting thrashed on the server for whatever reason, it might take
>several seconds to complete the various SQL commands, also increasing
>the likelihood of the user getting bored enough to start playing "bull
>in a browser shop".
>And since MySQL has no rollback feature that I'm aware of, how would
>you best handle this dangerous potentiality? Suggestions? A humble
>request: Responses which begin with: "Don't use MySQL", please include
>a good affordable alternative?
>[EMAIL PROTECTED] ### ICQ#: 10294457
>http://www.westergaard.ca/ ### http://courtly.livejournal.com
>'Alright, you guys start coding. I'll go find out what the customer
>EASY and FREE access to your email anywhere: http://Mailreader.com/
>PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:
PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php