MySQL

Admin panel for an e-commerce site-Part3

The part1 and part2 of the admin panel have been shown in the previous tutorials. The ways of editing product, category, subcategory, and checking orders have been shown in this tutorial. Steps: 01. Create edit-category.php file inside the admin folder and add the following content. <?php session_start(); include(‘../includes/config.php’); if(strlen($_SESSION[‘alogin’])==0){ header(‘location:index.php’); } else{ date_default_timezone_set(‘Asia/Dhaka’); $currentTime = […]

Read More

Admin panel for an e-commerce site-Part2

The part1 of the admin panel has been shown in the previous tutorial. The ways of inserting new product, category and subcategory have been shown in this tutorial. Steps: 01. Create insert-product.php file inside the admin folder and add the following content. <?php session_start(); include(‘../includes/config.php’); if(strlen($_SESSION[‘alogin’])==0) { header(‘location:index.php’); } else{ if(isset($_POST[‘submit’])) { $category=$_POST[‘category’]; $subcat=$_POST[‘subcategory’]; $productname=$_POST[‘productName’]; […]

Read More

Admin Panel for an e-commerce site-Part1

Admin panel is the most important part of any website to manage all data of the site from one location. The first part of implementing admin panel for the e-commerce site that was shown in the previous five tutorials has been described in this tutorial step by step. Steps: 01.Download the following zip file for […]

Read More

E-commerce Site From the Scratch-Part5

The way to implementing checkout options of the e-commerce site have been shown in this tutorial. You have to complete the part1, part2, part3 and part4 of this project before starting this tutorial. Step-1: Create addresses.php file inside the project folder and add the following content. Check that addresses.php file is set in location of […]

Read More

E-commerce site from the scratch-part4

The way to display the products based on the product category, display the product of the wish list and transfer the product from the wish list to cart have been shown in this tutorial. You have to complete the part1, part2 and part3 of this project before starting this tutorial. Step-1: Create category.php inside the […]

Read More

E-commerce site from the scratch-part3

How to create new user account, login to the account and modify the information of the user have been shown in this tutorial. You have to complete the part1 and part2 of this project before starting this tutorial. Step-1: Open the project folder and create the file login.php and add the following content. <?php session_start(); […]

Read More

E-commerce site from the scratch-part2

You have to complete the part-1 of e-commerce tutorial from the scratch before starting this tutorial. In this tutorial, we will learn the way of adding product related data and displaying the data with the image. Step-1: Insert some categories in the category table. Run the following Insert queries to add three categories values. INSERT […]

Read More

E-commerce Site from the Scratch- Part1

This the first tutorial for creating a simple e-commerce site with all basic features from the scratch. In this tutorial, we will learn how to design the database, the structure of the files and folder, and the designing index page of a ecommerce site that will sell furniture online. Step1: Create a database named ‘ecommerce‘. […]

Read More

How to make HTML template dynamic using Reactjs, PHP and MySQL

Steps:1. Before starting this tutorial, you have to complete the previous tutorial that converts any HTML template into reactJS project. How you can make a particular portion of the reactJS project dynamic using reactJS, PHP and MySQL is shown in this tutorial. You have to install xampp server for starting the steps of this tutorial. […]

Read More

CRUD Operation using PHP, MySQL and Bootstrap

Steps: 1. Create a table named `employee_basics` by running following SQL, CREATE TABLE `employee_basics` (`id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `gender` varchar(6) NOT NULL, `address` varchar(255) NOT NULL, `phone` varchar(50) NOT NULL, `post` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`)); 2. Create a folder named phpCRUD in htdocs folder. 3. Download the following files […]

Read More