Small Shopping Cart Website with Admin rights using PHP and MySQL -- 2

Create a shopping cart site with admin rights to maintain categories and products. First, In PHP MyAdmin create a database called "PHPFall2017" with a username of "PHPFall2017" and a password of "se266". Under the PHPClassFall017 database click on the SQL tab. There will be a text area where you can copy and paste the SQL below. Paste this in and click GO to use these tables: -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, `email` VARCHAR(150) NOT NULL UNIQUE KEY, `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -- Table structure for table `categories` -- CREATE TABLE IF NOT EXISTS `categories` ( `category_id` INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, `category` VARCHAR(150) NOT NULL UNIQUE KEY ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -- Table structure for table `products` -- CREATE TABLE IF NOT EXISTS `products` ( `product_id` INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, category_id INT UNSIGNED NOT NULL, FOREIGN KEY (category_id) REFERENCES categories(category_id), product VARCHAR(150) NOT NULL, price FLOAT(10,2) NOT NULL, image VARCHAR(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -- END -- WEBSITE: Signup/Login - Create a signup page that will allow users to enter an email and password. The email must be unique. If it is taken display a message letting the user know. If the email and password is valid(no empty passwords) make sure to hash the password when saving it into the database. The login page should allow you to enter the site and start a session for that user. The session should store the user_id. Once logged in it should also direct you to the admin page. Admin site - Create a section that will allow you to manage the categories using CRUD (Create, Read, Update, Delete). Create another section that will allow you to manage products using CRUD. (Uploading Images will be included) When I update my product, it should not remove the old image if I do not select a new image. (Hint: you can have a hidden text with the old image name. If the uploaded image is empty, set the image to the old image name set in the hidden text field) Make sure to stop users who are not logged in from accessing the admin section of the site. Once the admin page is working, add three categories and 4 products for each category. Main site - Create a shopping cart site that will allow us to add products to our cart. I should be able to view the products on the page by category (Use a GET to know the category). When I checkout(create a checkout page) I should see a list of products and the total. I should also be allowed to clear my cart. Every page should include the links to the categories and how many items are in my cart. Use folders, includes and functions to organize your code. Make sure there is a header and links throughout the site. Also, add bootstrap and/or add CSS styles to your application. No JavaScript is needed (or wanted) so make sure to only have .css files. Overall website should be pretty basic. Nothing too fancy. Just straight forward PHP with some simple styling. What's most important is the website working as described. The sooner this can be completed the better. Thanks!