echo mysql_insert_id and use this as a value

marlon4417

I have a form that writes to MYSQL db via PHP scripting. My question: when the submit button is hit, I'd like to write data to MYSQL first, and have the autoincrement ID returned via mysql_insert_id(). Then, how do I use the ID obtained as a value to one of the hidden field form inputs, which post to another page.

Am I violating something here if I am asking it to write to the db first, then echo the ID and from the same page post to another page? I'd really appreciate your help...I am a novice and this has been bothering me for a couple days. This is my first post on this site!!

Thanks.

bastien

Welcome.

That is exactly the process since mysql_insert_id can't find a value until the insert is complete. It might be easier if you place the id in a session object to move it around, or you could place your next page in a function and pass the value to the function

marlon4417

Bastien,

Being a novice, I am unfamiliar with both session object and passing the value to a function. Can you elaborate so I can look into this further on this site?

Originally posted by bastien
Welcome.

That is exactly the process since mysql_insert_id can't find a value until the insert is complete. It might be easier if you place the id in a session object to move it around, or you could place your next page in a function and pass the value to the function

Drakla

Hi.

Could you elaborate on what your code will do - as there's the danger that you insert an entry, then if the user doesn't go through with the next page you'll end up with a database full of 'Orphans' as I call them. You can then check for them and delete them later, but if your problem is do-able in one script then that would be great.

Lemonboi

I'm pretty new at all this as well, but what I've been able to do is create a definition after the insert query that does the mysql_insert_id and carry this forward to insert into another table.

$result = mysql_query($yourquery) or die();
$insert1id = mysql_insert_id();

I can then use $insert1id at anytime further in the script or pass it onto another script through the $_GET['insert1id']; or by putting it into a session.

If you don't know what a session is, best go do a tutorial, Zend have a great tutorial on sessions and cookies

marlon4417

Thanks everyone for the posts, this is getting clearer.

I've read the Zend article on sessions-i have some basic understanding but still not sure how to implement this. Here's what I am trying to do (hopefully, it's clear!!):

Person comes to my page, executes a form which writes to MYSQL db via PHP. I need to echo the mysql_insert_id -in other words, after the record is created, I need to grab the auto-increment ID and use this in a subsequent page as a value that is going to be part of a hidden field. Specifically, the subsequent page that the person is directed to has another form which directs them to paypal, and in this form that goes to paypal, there are input hidden fields. In one of the input fields, I'd like to have the ID generated from mysql_insert_ID entered. Maybe this is an html or Java job? For some reason, I think the session route in overkill?

Thanks

marlon4417

Ahh...persistence pays....

Figured it out:

On first page,

session_start();
......further on after inserts

$id= mysql_insert_id();
$_SESSION['dog'] = $id;

<?php
session_start();
$saved =$_SESSION['dog']

...further on at the form:
<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="bn" value="webassist.dreamweaver.4_0_1">
<input type="hidden" name="business" value="xxxx@comcast.net">
<input type="hidden" name="item_name" value="<?=$saved?>">

Thank you all for my first post which was successfully resolved. Happy happy...