We have an online bookstore. We are interested in having a shopping cart, where customer can select items and then pay for the total.
My question is about variable and tables definition.
These are the tables we have so far:
Products: books details
Customers: customers information
Cart: books selected by the customers
Orders: to consolidate orders
The idea of the website is as any other:
When a customer enters and selects a book, information is stored in a Cart table in MySQL, creating one new line in the table per each new book selected.
After selections are ready, customer makes checkout process and enter personal information.
My question is how can I store books selected from each customer if I do not have her/his personal information yet?
I mean, only when the customer makes checkout process I am able to get personal information, store in DB and get a CustomerID to identify him/her.
thanks a lot!!!