[RESOLVED] Madness ensues

LiamBailey

I have recently got a siccessful php script to insert form data into a simple table, but I want to do something and I don't even know if it can be done let alone how to do it.

I want to have people pick a size on one form, that gets inserted into the DB and the auto increment id field issues an id, is there anyway I can find out what their id is on the page the form is processed on, which is another form, so it can be all one table:

The customer selects a size and is issued a customer id when that size is inputeed into the db, and on the next page, the second form, the information entered there goes into the next set of fields in the same table, into the same (id) record.

Can this be done, and where can I read up on how?

laserlight

I want to have people pick a size on one form, that gets inserted into the DB and the auto increment id field issues an id, is there anyway I can find out what their id is on the page the form is processed on, which is another form, so it can be all one table:

Probably. For example, if you are using the PDO extension, you would use the lastInsertId() member function of your PDO object. If you are using the MySQL extension, you would use [man]mysql_insert_id/man.

With multiple pages, you would call the appropriate function, then pass the id along with session data, or some other mechanism of your choice.

LiamBailey

On the action page of the first form I would do

include (myconnection1.inc);
$query = ("INSERT INTO" dunno_yet (id,size) VALUES ('NULL','$size')");
mysql_query($query) or die (mysql_error());

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

And then to input the entries on this form on the next action page i could do

$query = ("INSERT INTO dunno_yet (entry1,entry2,entry3) VALUES ('$value1','$value2','$value3') WHERE 'id' = $_SESSION['id'] LIMIT 1");
mysql_query($query) or die(mysql_error());

Is that anywhere near right?

laserlight

Is that anywhere near right?[/url]
Somewhat, but you would use UPDATE instead of INSERT for the next page.

LiamBailey

Thanks again laserlight, I'm not quite at that stage yet, but I am currently redoing my whole website, from the look to the core of its functionality, bit by bit, and one thing is affected by the way I decide to do the other, which is where this question came in, now I know how to do what I want to do I can design the pages around it.

Thanks -- I'll come back and let you know how I get on.