Re: PHP Processing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux