auto_increment method

[Anon]

I have made a form to add customers.
I have set up the id field to auto_increment.
Also, after the customer has filled up the form, another page is shown with a confirmation that is submitted and the customer data is added.
That's where is my difficulty:

What I need is fetch the customer id generated on the previous form after the confirmation and resubmit it again to another form. I see the only solution is to work with my own auto_increment method because as it is auto_increment, how am I going to know what id was determined to that customer if there is dozens of them filling forms on-line.

Thanks for any suggestion

[Anon]

Use the the function
mysql_insert_id();

This will return the last generated ID.

[Anon]

On your form processor, use the mysql_insert_id() function on your form processing page right after the INSERT statement to get the ID of the customer just added. You can then pass that to your confirmation page in the header directive:

header("Location: confirm.php?id=$newid");

[Anon]

But how can I avoid someone get the last inserted id from other customer that had just been added to the database?????
Is this process (INSERT then after get the id) secure enough?

thanks

[Anon]

Yes, it's secure because you also use the link_id that the script got when it made the connection to the database. each script running will get it's own link_id.

$number = mysql_insert_id($link_id);

This will insure that you only get the id associated with the last insert for your connection only...

---John Holmes...

[Anon]

Hi, what is this link id? How to pass it? Php or mysql knows it? Show me an example?

Thanks

[Anon]

$link_id = mysql_connect("host","user","pass");

The link id is what returned when you connect to mysql. You are connecting, right???

$result = mysql_query("INSERT INTO your_table (text) VALUES ('My Text')");

$last_id_number = mysql_insert_id($link_id);

oh yeah...read the manual!

---John Holmes...

[Anon]

thanks for the precious information.

Rod

[Anon]

No problem...I was serious about that read the manual comment, though...

www.php.net/manual/
www.mysql.com/documentation/mysql/bychapter/

---JH