Today in this post, I'm going to develop a small web application that is Shopping Cart With Checkout System Using PHP, MySQLi & Ajax, In this application, I'll show you how to display all the products from the database on the home page and I'll show you how to add a product into the cart and then I'll also show you how to checkout with cart products.So, in this application, I'm using Bootstrap 4 for designing all the pages and I'm using PHP as a back-end language, I'm using MySQLi Prepared Statement for database operation like inserting, fetching, deleting items, I'm using jQuery - Ajax to send the HTTP request to the server and I'm also using Fontawesome library for icons.Before proceeding, let me tell you what I'm using as a local server, I'm using Xampp Server in which PHP Version > 7.0, So if you are using an older version of PHP then first update your PHP version then start this tutorial.Now, let's start this tutorial, here I'll post all the source codes of this application. So just follow all the steps carefully.If you want to watch videos tutorials of this project, then click .1. Creating Database & TableFirst of all, we'll create a Database and Tables for this project, so for this just open your phpmyadmin in the browser and create a new database with the name "cart_system". After creating the database We'll now create some tables into it, so don't worry I'm giving you the SQL file you just have to import this file into the created database. You can download the SQL file by clicking . Once you download the SQL file then just click on your database and then click on the Import tab and then click on Choose File and select the downloaded SQL file and finally click on go. After that, you will see three tables have created the cart, orders and product.2. Creating a Project DirectoryIn this step, we'll create our project directory inside the htdocs folder, for this just open the htdocs folder and create a new folder with the name "shopping-cart" or anything you want. Now open this folder inside your favourite code editor.3. Downloading Products ImagesWhen you created a database and table then you can see a product table was there and some records are present in the table, like the below image. You can see there is a column product_image in which I've written the path of product images. And I've kept the image folder inside my project root directory with all the images. So, you can download all the images from . Once you download this image.zip then extract this inside your project root directory. You can also add more product into the product table just enter all the details and also write the image path in the product_image column and keep the image in the image folder., As you can see, the 'cartID' contains items added to a cart by the 'memberID' of 1. However, it would be way better if the 'cartID' is like the 'orderID' I have on my 'transactions' table so that the order knows which cart it is looking at. Also, the 'shopID' is there to locate the item better (like sorting) so that I display all the 'shopID's , Google Dorks allow you to search for a wide variety of information on the internet and can be used to find information that you didn’t even know existed. In SQL Injection, attackers alter SQL queries and inject malicious code by exploiting application vulnerabilities, modifying database information, accessing sensitive data, can issue commands to the system..