Inserting data into related tables using PHP and MySQL

[jchapa]

Hello to all,
Well got a slight problem that I am trying to solve, however; I have not run across anything via Google to address my problem. I have an app that let's say consist of the following:

student table with two fields---userID, Username.
Primary Key, UniqueKey userID

Next table,

Class table with four fields classID,userID_FK,Desc,Instructor.

The problem I am having is how to insert data into both tables at the same time. I can create the form and do inserts,updates,deletes. However, the problem is how do I auto-populate the class table with the userid in the userID_FK using PHP.

Any help is appreciated.

[devinemke]

1. INSERT into the student table
2. use [man]mysql_insert_id[/man] to get the last userID
3. INSERT into the class table using the last userID as the userID_FK

[jchapa]

Originally posted by devinemke
1. INSERT into the student table
2. use [man]mysql_insert_id[/man] to get the last userID
3. INSERT into the class table using the last userID as the userID_FK

devinemke, thanks for that tidbit. Now saying I have displayed on my screen the top form being the student info and the bottom being the class info I would need two submit buttons? One for the student and one for the class list, correct

[devinemke]

no, you could code that with a single submit button. just have it be all one form. be sure to name your form fields carefully to know which form fields go to which db fields.

[jchapa]

Originally posted by devinemke
no, you could code that with a single submit button. just have it be all one form. be sure to name your form fields carefully to know which form fields go to which db fields.

devinemke thanks for sharing the knowledge it is appreciated. I got my database to log the time accordingly. I was also able to retrieve it from the log_file db I created using my logs.php file. However, I could not follow the examples for formatting the time on PHP side. I tried several variations on the items your provided date_format() and unixtimestamp but I was unable to format the time. Well thanks once again!/QUOTE]