Okay, sorry if it's a terribly easy/newb-ish task. But I really need this figured out, so I appreciate any help at all.
I have a simple online exam task with just a couple of pages, just started learning PHP.
The process is like this:
1.) a new user inputs his information on the first page, it is stored in the database 'dbuser'.
2.) he directed to another page confirming his entry
3.) he takes a simple exam with radio buttons and stuff
4.) after submitting, his score is stored in another database and shown in the next page.
My problem is, I wanted to get the primary key (auto-incremented) from the current user just right after he's submitted his information so that I can store it as foreign key in another database (where I would store his score).
A rather reckless solution to this was to cross reference his recent information with WHERE to get it, but I believe in the long run it would be a ridiculous thing to to have as it would cause redundancy and inconsistency, and thus not good practice.
Would anyone please help me, how do I get the primary key from the user who's just inputted his information in the database?
This is my simplified code scenario:
Info input page:
Information page <form method="post" action="is_db.php"> Name: <input type="text" size=7 name="frm_name"><br><br> Address: <input type="text" size=10 name="frm_address"><br><br> <input type="submit" value="Submit information"> </form>
Information input confirmation page:
<?php include("dbconnect.php"); // database connect to 'dbuser' ?> $name=$_POST["frm_name"]; $address=$_POST["frm_address"]; $query=" insert into user_info (name, address) values ('$name', '$address')"; mysql_query($query) or die(mysql_error()); User information added! <form method="link" action="questions.php"> <input type="submit" value="Proceed to questions"> </form>
<form method="post" action="questions_db.php"> 1. What is the meaning of ISP? <br> <input type=radio name='q1' value=0>asdf<br> <input type=radio name='q1' value=0>asdf<br> <input type=radio name='q1' value=0>asfd<br> <input type=radio name='q1' value=1>Internet Service Provider<br> <br> <input type="submit" value="Submit answers"> </form>
The next page should be where I should already have the primary key of the examtaker so I can store into to an 'admin' database where I will store his score in the 'scores' table. The next page also shows the score.
Thanks for considering and helping, guys!