mysql - creating atable per user in php? -


Actually I am all very new ... and for my work in a college, I have an online shopping website And I got stuck on the sign up part :( I want the user to take a separate table for themselves, which allows them to store the products added in their car so that they can add more products later. As i am in all your links I have read about the questions. Creating a table per user is a very bad idea, but otherwise how can I do this? Please help !!!!!

Explain me in detail.

I think you have already created a table for the user and the product. If not, then you have unique user_id and product_id Create tables for users and products, respectively, with value.

Now the following fields Create user_shopping cart table with

  • user_id
  • product_id
  • product_qty

    according to your requirement Can update user_shopping.

Comments