Question: What is the code? Use only html, php, and Javacript, to work with the mysql database. You do not need to create the sql database,
What is the code? Use only html, php, and Javacript, to work with the mysql database. You do not need to create the sql database, just make the code work with the sql database explained below.
E-Commerce Site
This site will contain three parts
Part 1
The site will utilize a login, this can be from your previous assignments or you can create a new table for holding usernames and passwords. There will need to be a database storage for the user information. The password should use the hash() function to hash the password. It should direct the user to a page to make a new account on the login page and should not allow for login in the password or username is not correct.
Part 2
There will be a page for looking at the catalogue of items. A new table will be made of all the items to be sold.
Step 1
Enter the MYSQL admin and create a table called products
The table will have
ProductID
Name
Description
Price
Step 2
After you have created the table you will insert these items
| Anvil |
| Axle Grease |
| Atom Re-Arranger |
| Bed Springs |
| Bird Seed |
| Blasting Powder |
| Cork |
| Dsintigration Pistol |
| Earthquake Pills |
| Female Roadrunner costume |
| Giant Rubber Band |
| Instant Girl |
| Iron Carrot |
| Jet Propelled Unicycle |
| Out-Board Motor |
| Railroad Track |
| Rocket Sled |
| Super Outfit |
| Time Space Gun |
| X-Ray |
Step 3
Create a catalogue page called catalogue.php and then add the text
Please select one of our items: then an options/drop down box
The PHP will call the database and then populate the box with each of the items.
Part 3
Making the shopping cart.
Things the page will need to do-
You will need to use the Session to track the cart products and quantity
You will need to add products to the cart and remove them from the cart
You will need to empty the cart.
You will need to show information in individual products
You will need to display an image of the product when selecting to show info(There are 20, They are JPG files, they are called 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) example: 1.jpg
You will need to show a total cost of all the products in the cart
This page can be the same page as catalogue.php.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
