Question: Design an admin portal for an e - Commerce website. Choose a specific product you would like to sell. Eg . Computers, Beds, Shoes. On

Design an admin portal for an e-Commerce website. Choose a specific product you would like to sell. Eg. Computers, Beds, Shoes.
On this website, the user can post, update, retrieve and delete the products. All the products and their details should be stored in a MySQL database. Do not create a table with a generic name like "products". The table should be named according to what you are selling. If you are selling beds, then the table should be called "bed" or "beds".
There should be at least the following fields plus 1 additional field of your choosing on which CRUD operation should be performed (Note: replace with the type of products you are selling Eg. "BedID"):
ID
Name
Description
Quantity Available
Price
Product added by
Create a suitable database as per the chosen product for the website. Include a file called dbinit.php that will connect to the database and create the needed database and table. The table should contain a column named ProductAddedBy. The value of ProductAddedBy should not be customizable, it should be hardcoded with your name. All user input should be validated using PHP. Prepared statements must be used when user input is included in SQL statements. The user should be able to navigate between pages freely. The website should look appealing. Do not submit any files from class, the course shell, or the textbook as part of your assignment. Start from scratch. Bootstrap may be used but is not required. Use self-processing pages instead of navigating to a different page to do the processing. For example, in the class files, there is a file called insert.php which displays the insert user form. When we press the Insert button, the page redirects to register.php to insert the data into the database. Instead of doing this, we would delete the register.php file, and move all the code to the insert.php file. Then, when we click Insert, the page will POST to itself to insert the data into the database. If self-processing pages are not used, the assignment will be graded as 0.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!