PHP simple shopping basket
Hi i am making a website in dreamweaver using php connected to database tables in a phpmyadmin server.
I need to create a simple shopping basket where the user selects an item from one page using a link that saves the products id of the selected product and then the website will go to a blank insert page that will add the item to the shopping basket database table and when it has done that it will go back to the original page.
I have 3 database tables members, Products and shopping basket the details that will need to be sent to the shopping basket table are product Id, Product name and price which are all found in the products table and it will also need to send the username of the user from the members table to the shopping basket table aswell.
Could anybody help me with the code to insert data from one table to another using a primary key product ID?