Insert multiple information to every field in the database

Asked By littlemonica 0 points N/A Posted on - 01/25/2013

Hi. I am an IT student and as part of the requirements, I have chosen a Seat Reservation system. In my seat reservation, I have shown a UI of the arrangement of the seats and when the user clicks one seat, a jQuery pops up asking for information on who reserved the seat. After submitting the information, it should refresh the page and the UI will now show the seat is taken and I can reserve another seat for my friend and it should do the same thing. I want every information entered be inserted in the database. I have tried a different thing before which includes the pop up but it doesn't insert all the information. I need your guide to help me out with my project. Thank you!

• Status: Open
• Question Views: 587
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Opland Pamela 0 points N/A #169994

Insert multiple information to every field in the database

Hello Littlemonica,

 

I would suggest making a separate table for that. Make a temporary table which will include all the information needed then try to append all the information you want in the tables you want them to, including the table where the temporary table is based on. Then when refreshing the page, refresh the database first before refreshing the page. The information should show up.

 

Hope this helps.

About Opland Pamela

Questions
5

Answers
100

Best Answers
49

• Vote Up 0 Vote Down

• Posted on - 01/30/2013
• Question Category: MySQL Server