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. mysql_db_query(blaaa); mysql_db_query(blaaa); echo "blaaa"; <---------- This point could stop if user has hit stop when it gets there. mysql_db)query(blaaa); Anyone know different? Anyway, ignore_user_abort(true); seems to do the trick. <>< Ryan -----Original Message----- From: Alan Langford [mailto:jal@xxxxxxxxxxxxxxx] Sent: Monday, January 05, 2004 3:48 PM To: peter@xxxxxxxxxxxx; php-db@xxxxxxxxxxxxx Subject: Re: 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 >locate where. > >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? > >-P > >Peter Westergaard >peter@xxxxxxxxxxxxxx ### ICQ#: 10294457 >http://www.westergaard.ca/ ### http://courtly.livejournal.com >---------- >'Alright, you guys start coding. I'll go find out what the customer >wants.' > > > > >=================================================================== >EASY and FREE access to your email anywhere: http://Mailreader.com/ >=================================================================== > >-- >PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: >http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
