Welcome Guest, Not a member yet? Register   Sign In
Best method of submitting to multiple tables with one page and one button.
#1

[eluser]jim-_-[/eluser]
First off: Hi, I'm new to setting up CodeIgniter from scratch, sorry I R Noob.

What is the best or smartest or any way of submitting one page to multiple tables, ex. I want to store a person and their quote into two different tables called

PERSON, and QUOTE.

How can that be done better then my previous method of making one page and form for each table and forwarding the person from the logical first page in this case the PERSON form, to the QUOTE form?? The QUOTE table will need to store the PrimaryKey(ID field) from the insert into the PERSON table.

Another example would be making a User registration for and wanting to save the e-mail and PW in the LOGIN table while saving the name and personal info PROFILE table.


This has always stopped me from making good DB practice when creating a site from scratch, and searching for the answer just brings up how to insert multiple Arrays as the problems seem similar to google.

EDIT: Just want a general answer so I can construct from scratch.




Theme © iAndrew 2016 - Forum software by © MyBB