Question
Help with Passing Variables to Relational Web Pages
I am trying to create several webpages that require ID's from
the previous page to populate the database tables attached to them.
Please help. What I am trying to do:
Page 1: Student Information (Create a New Record)
After creating new record, have server post the unique record ID (StudentID-Primary Key, auto-generated) that was created with the new record and pass it to the next page
Page 2: Family Information (Create New Record) Pages (Connected to page 1 via studentID.)
Have web page get the unique StudentID record created on page 1 and use this to fill in the form on this page. So basically connect the family info back to the student info.
The relationships are set up in MYSQL, but how can you pass variables so it can populate the tables properly? Detailed information would be great as I am a beginner and have read every book, but still can't find a good answer. Please help.
Thanks.
Testing Website found at http://www.mesa.pdx.edu/conference/registration/test1.php
http://www.mesa.pdx.edu/conference/registration/test2.php
Attached is code for page one.
Page 1: Student Information (Create a New Record)
After creating new record, have server post the unique record ID (StudentID-Primary Key, auto-generated) that was created with the new record and pass it to the next page
Page 2: Family Information (Create New Record) Pages (Connected to page 1 via studentID.)
Have web page get the unique StudentID record created on page 1 and use this to fill in the form on this page. So basically connect the family info back to the student info.
The relationships are set up in MYSQL, but how can you pass variables so it can populate the tables properly? Detailed information would be great as I am a beginner and have read every book, but still can't find a good answer. Please help.
Thanks.
Testing Website found at http://www.mesa.pdx.edu/conference/registration/test1.php
http://www.mesa.pdx.edu/conference/registration/test2.php
Attached is code for page one.
