You can always test if your SQL statement successfully completed or not to
determine errors. Using:
$myresult =mysql_query($queryX,$myconn);
if (! $myresult) {
echo mysql_error($myresult) ;
}
else {
// nothing or
echo "Query successful";
}
================
"Ryan Jameson" <RJameson@xxxxxxxxxxx> wrote in message
news:CC8578B824E74940BA5126774F49628D01E799FC@xxxxxxxxxxxxxxxxx
I believe the PHP parser will completely process that page whether you
click stop or not. In my experience it's always been "all" or "nothing"
as long as you don't hit an error half way through which I'd imagine
could cause a problem.
<>< Ryan
-----Original Message-----
From: Peter Westergaard [mailto:peter@xxxxxxxxxxxx]
Sent: Monday, January 05, 2004 3:14 PM
To: php-db@xxxxxxxxxxxxx
Subject: PHP Processing
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
