sessions

slimjim

I have this form, where after a person submits the form it directs them to a page. Well on that page i somehow need to have the id follow them so that the mysql data according to the id goes with them. Well not sure if i am saying this right.
Below is the form. Somehow i need it so that the header location gets the id at end of it, so that the when they get transferred to the next page, it shows the correct information.

<?
require "commonletter.php";
dbconnect();


if($submit == "Add"){


	$query="insert into letter (id, fname, lname, address, town, nick, age, status) values ('$id', '$fname', '$lname', '$address', '$town','$nick','$age','2')";

mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");		




          header("Location: finishedletter.php");}

?>

<html>
<head>
<title>Submit letter</title>
</head>
<P></P>
<form action="addletter.php" method=post>
<table>
<tr><td>Childs First Name <input type="text" name="fname" size="20" value=""></td></tr>
<tr><td>Childs Last Name <input type="text" name="lname" size="20" value=""></td></tr>
<tr><td>Childs Street Address <input type="text" name="address" size="20" value=""></td></tr>
<tr><td>Childs Town <input type="text" name="town" size="20" value=""></td></tr>
<tr><td>Childs Nick Name <input type="text" name="nick" size="20" value=""></td></tr>
<tr><td>Childs Age <input type="text" name="age" size="2" value=""></td></tr>
<tr><td colspan=2><input type=submit name="submit" value="Add"></td></tr>
</table>
</form>

slimjim

Now not sure how to do this, but i think i have to get the variable id before i get transfered to next page so that it can be inserted into the header so it looks like this. Problem is i do not know how to do it. I read so much of the forum listings and not finding anything that helps me. ANy ideas or help please.

header("Location: finishedletter.php?id=$id");}

weevil

You can use the php function mysql_insert_id like this

 $id = mysql_insert_id();

This will give you the id from the previous insert

mysql_insert_id

slimjim

Now would that go into the page with form on it ?

weevil

It goes in between your insert and the redirect

$query="insert into letter (id, fname, lname, address, town, nick, age, status) values ('$id', '$fname', '$lname', '$address', '$town','$nick','$age','2')"; 

mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");         

$id = mysql_insert_id();

header("Location: finishedletter.phpid=$id");}

slimjim

Great that worked and i read up on that too and booked marked it. If you dont mind i am going to leave this open in case i have more questions.

slimjim

Ok i didn have another question. Having it use the last id submitted may not be good , because someone or many others may submit at same time. So now what can i do ?

weevil

Having it use the last id submitted may not be good , because someone or many others may submit at same time

It uses the id from the insert statement that ran a fraction of a second prior to it in your script so the chances of it getting the wrong id are pretty remote I think.