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

Suoritettu Julkaistu 6 vuotta sitten Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

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!

CSS HTML MySQL PHP

Projektin tunnus: #15825553

Tietoa projektista

11 ehdotusta Etäprojekti Aktiivinen 6 vuotta sitten

Myönnetty käyttäjälle:

satyajeetkeshari

I am expert in web development using PHP and WordPress . I can create shopping cart web site, with Admin access of product and its attributes. Relevant Skills and Experience PHP/Mysql CSS Javascript/Jquery Proposed M Lisää

$30 USD 1 päivässä
(81 Arvostelua)
5.1

11 freelanceria on tarjonnut keskimäärin $131 tähän työhön

shihan033010

Hi I have read your project requirements. I am expert in web application development using php and mysql using the bootstrap framework. I can ensure you to compete the functionality that you need. Please accept the bid Lisää

$100 USD 3 päivässä
(321 arvostelua)
6.8
techwelfare

Hi Please let us know your details requirements so we could analyze it and start working. we have few questions to clarify before we start, could you kindly reply so we could ask our questions? Relevant Skills and Exp Lisää

$30 USD 1 päivässä
(190 arvostelua)
7.2
wpmonsters

Hello, Let me introduce WordPress Monsters, the team which aims at building the best WP products and often succeeds in doing that. We use WP to build all kinds of web applications: blogs, eCommerce and even custom solu Lisää

$350 USD 3 päivässä
(22 arvostelua)
5.4
mayankinnovative

A proposal has not yet been provided

$30 USD 1 päivässä
(77 arvostelua)
4.5
stackboy

hey buddy whats up i can do this for you just give me a message we will discuss about it and finalize the deal Relevant Skills and Experience php mysql cakephp laravel codeignitor Proposed Milestones $25 USD - on c Lisää

$25 USD 1 päivässä
(6 arvostelua)
1.9