mysql – FahmidasClassroom

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(); […]

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‘. […]

Basic E-commerce site development part-2

The registration and login processes of the user have shown in this tutorial. Do the following steps to complete the tutorial. Steps: Modify the index.php file inside the html folder to omit the default session information. So, commented the following lines. /* $_SESSION[‘user_id’] = 1; $_SESSION[‘user_admin’] = true; $_SESSION[‘user_not_expired’] = true; */ 2. Add the […]

Basic E-commerce site development part-1

In this tutorial, we will learn the way to design the basic database of a simple e-commerce site and create the structure of the file to connect with the database and design the basic front page. Steps: 1. Create a database named ecommerce and run the following SQL statements to create the required tables. CREATE […]

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. […]

Angular CRUD using PHP and MySQL

This tutorial will help you to learn angular CRUD operation using PHP and MySQL. This tutorial is divided into two parts. One for PHP & MySQL code and another for angular code. PHP and MYSQL Part: Steps: 1. Create a database named angdb. 2. Create a table named ‘products‘ with the following fields. CREATE TABLE […]

Session Handling Tutorial using PHP, MySQL and JQuery

Session handling is a basic requirement for any type PHP based web project. If the project requires user registration and login options, then it is necessary to implement session handling feature for the project. How to create session and handle session for a particular user by using PHP and MySQL are shown in this tutorial […]

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 […]