Tamamlanmış

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!

Beceriler: CSS, HTML, MySQL, PHP

Daha fazlasını gör: php shopping cart tutorial step by step, simple ecommerce shopping cart php mysql, shopping cart using php and mysql, simple shopping cart in php source code, php shopping cart tutorial using sessions, add to cart in php demo, add to cart in php code with ajax, simple shopping cart php code, connect paypal shopping cart website php, integrate php shopping cart website idevdirect, php sql shopping cart website, create website admin users using php, small shopping cart php, security php asp net shopping cart website, calculate total amount shopping cart using php mysql, php shopping cart website admin panel free, shopping cart website using vbnet, integrate shopping cart website php, shopping cart website using mootools, small shopping cart image website

İşveren Hakkında:
( 3 değerlendirme ) WARWICK, United States

Proje NO: #15825553

Seçilen:

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(47 Değerlendirme)
4.3

Bu iş için 14 freelancer ortalamada $113 teklif veriyor

in %bids___i_period_sub_35% gün içinde601%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(754 Değerlendirme)
9.8
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(313 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(162 Değerlendirme)
7.0
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
5.2
stefanache

Hello, Relevant Skills and Experience The web-development will be based on -PhP,MySQL+ -HTM5,JS/Jquery+CSS/BootstrapJS Proposed Milestones $111 USD - m1 Thanks

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(32 Değerlendirme)
5.6
mayankinnovative

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(26 Değerlendirme)
2.7
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
1.7
najarine

Hello Sir, I am an experienced and well rated web developer from fiverr, but starting new here on freelancer.com, but I can develop web project from scratch: HTML, CSS, JS, PHP, MYSQL, WORDPRESS, UX, DB modeling and c Daha Fazla

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.4
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
sbcs2

I've good knowledge in these skills.I'm READY to do your [login to view URL] me your full project scope. Relevant Skills and Experience I'm a experienced in these fields for 10 [login to view URL] new in [login to view URL] give me a chanc Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
0.0
dungdung21

Hi, I am an excellent php developer and i have rich experience with ecommerce/shopping cart field. [login to view URL] I can start work right now. Sincerely Relevant Skills and Experience CSS, HTML, MySQL, PHP Prop Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
sayootech

Hi , I am swati I have gone through your requirements (Small Shopping Cart Website with Admin rights using PHP and MySQL -- 2). I have 6+ year experience in: * Mobile App design * Game development * Website De Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
devitrana84

Having good experience and knowledge in developing shopping cart based websites or e-commerce based [login to view URL] capable handle and build application using php, mysql, sql server, etc.

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0