On 09-May-01 [EMAIL PROTECTED] wrote:
> Does anyone know how mysql behaves when a client CGI script quits? Does
> the SQL query march on through? I wondering if anyone knows of ways to
> protect against browser reloads and other forms of similar
> abuse....especially if the the sql query is expensive?
>
Under PHP, if the query is still building the temp table, the server continues
the process. When the results are returned is when the connection (or lack of)
is detected. My observation, Monty & friends should have the final word.
> BTW, I'm not allowed to use cookies to keep track of a users session.
a spinlock ?
# mkdir /tmp/nobody
# chown nobody /tmp/nobody
your.cgi :
$lockname="/tmp/nobody/$ENV{'REMOTE_ADDR'}";
mkdir($lockname,0777) || die ('already in');
do_query("blah");
rmdir($lockname);
Regards
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
