What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Antonio PHP
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

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Jørn Dahl-Stamnes
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

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Geert-Jan Brits
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

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Carsten Pedersen
http://php.net/manual/en/function.ignore-user-abort.php / Carsten On Fri, 16 Apr 2010 18:39:07 +0900, Antonio PHP php.anto...@gmail.com wrote: This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl;

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Carsten Pedersen
On Fri, 16 Apr 2010 11:44:42 +0200, Jørn Dahl-Stamnes sq...@dahl-stamnes.net wrote: 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. Not quite true. If it decides to flush its

Re: numeric types

2010-04-16 Thread Sebastien Moretti
Hi I have already tried DECIMAL type but I cannot get what I want. Maybe the simple way to get data out of MySQL and data inside MySQL the same, is to reproduce what MySQL does by default on my data out of MySQL. Check out the DECIMAL type. / Carsten Sebastien MORETTI skrev: Hello, I

Downloading MySQL

2010-04-16 Thread Rhino
What's the deal with downloads of MySQL? I've been away from MySQL for a few years and have not really been keeping close tabs on things, although I have kept my mysql mailing list subscription and am aware of a major player planning to purchase MySQL. Did that actually go ahead? The reason

Re: Downloading MySQL

2010-04-16 Thread Peter Brawley
It gives you a form to complete... You can choose to skip all that. PB - Rhino wrote: What's the deal with downloads of MySQL? I've been away from MySQL for a few years and have not really been keeping close tabs on things, although I have kept my mysql mailing list subscription and

Re: Downloading MySQL

2010-04-16 Thread Jigal van Hemert
Rhino wrote: I've been away from MySQL for a few years and have not really been keeping close tabs on things, although I have kept my mysql mailing list subscription and am aware of a major player planning to purchase MySQL. Did that actually go ahead? Well... first Sun bought MySQL AB and