As a side-note: letting a random user (such as your website visitor) wait for a couple of seconds is usually not good practice, unless you have a very good incentive for them to do so.
2010/4/16 Jørn Dahl-Stamnes <sq...@dahl-stamnes.net> > On Friday 16 April 2010 11:39, Antonio PHP 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). > > The server does not know if the browser is closed or not (or if the network > connection is losted). It will continue to execute the code until > finnished. > > -- > Jørn Dahl-Stamnes > homepage: http://www.dahl-stamnes.net/dahls/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=gbr...@gmail.com > >