Build E-commerce website with PHP, MySQL, jQuery and PayPal

In this video we define the new class, which will handle all our database interactions

In this video we will create a new method, which will establish the connection to the mysql database.

Create the method to sanitise the data passed onto the sql query

Create MySQL Query method

Method to allow us fetch records from the database

Find out what's the difference betwen Static and Non-static

In this video we will modify some class properties

In this video we will create a new Business class

In this video we will learn how to populate business details

Dislay list of categories

Create active link

In this video we will create the catalogue page

Learn how to create the category pages

In this video we will take care of the product image

Continue from the previous video about product image

Product details page

A method to shorten the long description

Image unavailable placeholder

Create active button

New pagination class definition

Identifying the current page

Calculating total number of pages

In this video we will get the right records for the specific page

In this video we will start creating the paging links

Continuing from the previous video by creating list of links / buttons

Get the pagination element with get paging method

In this video we will start creating a small basket plugin file

In this video we will use jquery to add functionality to our small basket

In this video we will look at the 'Add to basket' button

In this video we will learn how to perform an Ajax call using jQuery in order to add new item to the basket without reloading the page

In this video we will populate the relevant record from within the file called by the ajax call

In this video we will create a new class called Session, which will allow us to deal with Session Variables

We are now going to have a look at the way of updating the small basket content

In this video we will learn how to refresh the content of the small basket using ajax

We continue from the previous video

In this video we will be expanding the Basket class

In this video we will have a look at the tax rate / vat, number of items and sub-total of the small basket

In this video we will display the values associated with tax / vat and total in the small basket

We are now going to have a look at the way we can format the number

In this video we will start applying changes to the product page

This video is the continuation of the previous one

In this video we will have a first look at the main basket page

In this video we will create a basket layout

We are now going to populate the content of the basket

In this video we will have a look at how we can display content of the basket on our main basket page

In this video we will create the item total and remove item methods for our main basket

Displaying sub-total and tax/vat amounts in the main basket

Update quantity of the basket items

In this video we will learn how to refresh the main basket once the quantities have been amended

Continuing from the previous video

In this video we will learn how to generate the new content for the basket

In this video we will continue with the removal of the individual item from the basket

In this video we will create the client form to capture their full address and other, necessary details for the order

In this video we will create the new Country class, which will allow us to populate the list of countries and display them as a dropdown menu of our client form

We are now going to process the form input

In this video we will learn how to create the sticky form fields

We are now going to create a new class called Validation

The new method of the Validation class called process()

The check() method of the Validation class

The check special form element method of the Validation class

The isValid method will validate all submitted values by filtering each by its type

In this video we will create two new methods of the Validation class called format() and validate().

In this video we will create the function to hash the input

Apply form validation