Ask Question, Ask an Expert


Ask PHP Expert

Develop an e-commerce Web site in PHP and a MySQL database.

Use PDO to communicate with the DB and not standard MySQL queries. Use Object-Oriented Programming.

Create classes for products and clients.

Create a database and insert data for products and categories (via phpMyAdmin interface).

The page index.php should display the complete list of products  and a drop-down list to filter by category.

Every product has the following attributes:

  • Name
  • Description
  • Image
  • Price

One product can be associated with one or more categories.

The page client.php displays a simple form to log in as a client and has a possibility for a client to create an account.

The authentication form should validate if the user and password match.


Part 1: The system should be able to secure creating client accounts, integrate the notion of administrator and have a shopping cart. You should use PDO class for communications with the database.

For this phase, we'll have to have a class for:

  • Applications
  • Clients/administrators
  • Shopping cart

You will have to update your database to integrate administrators. Use the same table as for clients. You should find a solution to avoid mixing up clients and administrators.

The page index.php should have a new element, Add to cart button.

The button should allow an authenticated client to add an item to his cart. The items should be stocked in a session variable to allow for displaying all the items in the cart to the client.

So you should have a new page panier.php (French for "cart") that will display the list of products selected by the client. From this same page, the client should be able to modify the quantity that will be set to 1 by default. If the client modifies the quantity to 8, for ex, this quantity should be saved as well and displayed correctly when the page is refreshed.

The following message should be displayed in the upper part of the page: "Welcome First Name, Last Name".

As for administrator, we should once again use the client authentication form, but as long as administrators cannot create accounts for themselves, the accounts should be created in advance in the database.

To secure the password, it should be generated with the help of PHP "crypt" function including a unique salt for every user. This applies both to clients and administrators. For a client, it should be done automatically in the account registration form whereas for administrator it can be entered directly into the database. So we will have a new page admin.php.

Once authenticated, the administrator should be able to add, modify and delete a product.

Part 2: The Add to cart button should allow displaying a page dedicated to the selected product, produit.php.

You should use "regex" to reprepare the URTL dynamically for each of the products including new ones that could be created.

The name of the product should be included in the URL.

The Add to cart button should now add items in the session variable without refreshing the page (using AJAX). A message confirming that the item has been added to the cart should be displayed. AJAX should be used as well for creating client accounts.

When a client enters his e-mail, we should validate with AJAX if the e-mail is available and does not exist in the DB.

A message in green should appear to the right of the form if the e-mail is available and a message in red if not.

To secure the account, we should integrate a captcha.

PHP , Programming

  • Category:- PHP
  • Reference No.:- M9826

Have any Question? 

Related Questions in PHP

Lab -intro to phpbelow i basically copied and past pages 13

Lab -Intro to PHP Below I basically copied and past pages 13 - 15 in this lab but attached the lab as well. Am using a Virtual Machine (VM) on my Windows computer with the Linux operating system called Ubuntu. Lab submis ...

Create a website with your topic of choiceextend your

Create a website with your topic of choice Extend your current website creating the new pages Implement all the buttons ( FIND SAVE MODIFY DELETE CLEAR ) Attachment:-

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate