OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

From: Carsten Pedersen (carstenbitbybit.dk)
Date: Fri Apr 16 2010 - 07:01:53 CDT


http://php.net/manual/en/function.ignore-user-abort.php

/ Carsten

On Fri, 16 Apr 2010 18:39:07 +0900, Antonio PHP <php.antoniogmail.com>
wrote:
> This maybe a newbie question.
>
> Consider the following concept,
>
> ~/index.php
>
> #1. Fetch data from an external webpage using PHP Curl;
> #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take
a
> few secs
> #3. While Loop { INSERT data (from #2) into local MySQL } - this may
take
> only mili secs.
>
> Suppose this code is run by a random user (say, my website visitor), and
> he/she closes the browser while the code was running. The real problem
is
> when the browser is closed while #3 is executing. Because only portion
of
> data is inserted, ~/index.php, and it doesn't know if it needs to visit
the
> site again (i.e. repeat from #1 -> over visiting the same webpage /
> possibility of inaccurate data in local MySQL).
>
> Has anyone come across with a similar problem? Do I need to use other
> programming languages like C to execute the code from #2 in order not
> to depend upon users' browser status?
>
> Another general question : Is there a way to make sure all the data is
> INSERTED in a while loop once it's triggered?
>
> many thanks in advance,
>
> - Anton
>
>
> !DSPAM:451,4bc835a5518712071889376!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql