How to Create Login CRUD System using PHP MySQL

Login CRUD System using PHP MySQL Creating CRUD system is a very common task in web development CRUD stand For Create, Read, Update and Delete. if you are a senior web developer you must have created plenty of CRUD system already. They maybe exist in a content management system, and inventory management system OR accounting application. if you just started web development, you are certainly going to experience lots CRUD grid’s creation work in your later career. The main purpose of a CRUD system is that enables users create, read, update, and delete data. Normallay data stored in MySQL Database. PHP is the server side scripting language that manipulates MySQL Database tables to give Front end users power to perform CRUD action. in this post we are creating login system also.

CRUD Operations

C – Create OR Insert data to MySQL Database.

R – Read Database Records.

U – Update Selected MySQL Records

D – Delete Selected Record From MySQL Database.

Create Login CRUD System using PHP MySQL

1-Creating Database

Open Phpmyadmin in your Browser
Click on Database Tab Display on Top side
Give the Database name “quaktis”.
After Creating Database Open it.
Click on SQL Tab on Top area
Copy the Below Source Code and paste it.
Then Click on Go.

-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 11, 2016 at 01:01 PM
-- Server version: 5.6.20
-- PHP Version: 5.5.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `quaktis`
--

-- --------------------------------------------------------

--
-- Table structure for table `info_tbl`
--

CREATE TABLE IF NOT EXISTS `info_tbl` (
`infoID` int(100) NOT NULL,
  `firstName` varchar(199) DEFAULT NULL,
  `lastName` varchar(199) DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `info_tbl`
--

INSERT INTO `info_tbl` (`infoID`, `firstName`, `lastName`) VALUES
(11, 'kumar', 'Deepak');

-- --------------------------------------------------------

--
-- Table structure for table `user_tbl`
--

CREATE TABLE IF NOT EXISTS `user_tbl` (
`userID` int(5) unsigned NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `user_tbl`
--

INSERT INTO `user_tbl` (`userID`, `username`, `password`) VALUES
(3, 'admin', 'admin');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `info_tbl`
--
ALTER TABLE `info_tbl`
 ADD PRIMARY KEY (`infoID`);

--
-- Indexes for table `user_tbl`
--
ALTER TABLE `user_tbl`
 ADD PRIMARY KEY (`userID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `info_tbl`
--
ALTER TABLE `info_tbl`
MODIFY `infoID` int(100) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `user_tbl`
--
ALTER TABLE `user_tbl`
MODIFY `userID` int(5) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

OR Import DB File

After Downloading the source code extract it in your root folder.

Open Phpmyadmin in your Browser
Click on Database Tab Display on Top side
Give the Database name “quaktis”.
After Creating Database Open it.
Click on Import Tab on Top area
You can Find Db file in Downloaded source code Select it.
Then Click on Go.

2- Creating Database Connection

After import Database File then next step is creating database connection using php copy the below code and save it is as “conn.php”.

<?php
	$server = "localhost";
	$username = "root";
	$pass = "";
	$db = "quaktis";

	//create connection 

	$conn = mysqli_connect($server,$username,$pass,$db);

	//check conncetion

	if($conn->connect_error){

		die ("Connection Failed!". $conn->connect_error);
	}

?>

3 – Create Login Form Using HTML

in this step we are going to create a form where user’s can login easily by provide their name and password.

<form action="index.php" method="POST">
<html>
	<center><h3>Login Here :</h3></ceter>
	<table align="center" bgcolor="tan" width="200">
		<tr>
			<td>
				Username:
			</td>
			<td>
			<input type="text" name="username" required>
			</td>
		</tr>

		<tr>
			<td>
				Password:
			</td>
				<td>
				<input type="password" name="pass" required>
			</td>
		</tr>
		<tr>
			<td align="center" colspan="2" bgcolor="teal">
				<input type="submit" value="login" name="log">
			</td>
		</tr>
	</table>
</html>
</form>

4 – Check user’s Availability in Database using PHP

in this step we are going to create a script when user’s login thgis script check the MySQL database this user available or not.

<?php
	include 'conn.php';
	session_start();

	if(isset($_SESSION['userID'])){

		header('location:home.php');
	}

	if(isset($_POST['log'])){

		$user = $_POST['username'];
		$pass =  $_POST['pass'];

		$sql = "SELECT * FROM user_tbl where username = '$user' and password = '$pass'";
		$result = $conn->query($sql);

		if($result-> num_rows > 0){
			while($row= $result->fetch_assoc()){
				$_SESSION['userID'] = $row['userID'];
				$_SESSION['username'] = $row['username'];	

		
			}
			?>
			<script> alert('Welcome <?php echo $_SESSION['username']?>'); </script>
			<script>window.location='home.php';</script>
			<?php

		
			}else{
				echo "<center><p style=color:red;>Invalid username or password</p></center>";

		}
		$conn->close();
	}
?>

5 – Create Home Page After Login

in this step we are goint to create a page after login this page will display.

<?php
include 'session.php';
$username = $_SESSION['username'];
$userID = $_SESSION['userID'];
?>
<!DOCTYPE html>
<html>
	<head>
		<link rel="stylesheet" type="text/css" href="mycss.css">
		<title>
			This is Sample
		</title>
		</head>
	<body>
		<div id="body">
			<div id="menu">
			<ul>
				<li><a href="home.php">Home</a></li>
				<li><a href="maintenance.php">Maintenance</a></li>
				<li><a href="logout.php">Logout</a></li>
			</ul>
			</div>

			<div id="content">
			
			<h1>Welcome <?php echo $username;?></h1>
				<h3 style="color:blue;"><?php echo "Today is".  "  ". date("M/d/y") . " - " . date("l") . ""?>&nbsp; <?php echo "" . date("h:i:sa") . ""?></h3>
				
				<hr style="border:1px solid red;" >
				
				

			</div>

		
		</div>
		</body>

</html>

6 – Creating a Form and insert data into database using PHP

in this step we goint start CRUD system and first step of CRUD system is Creating or inserting data into databse.

<?php
include 'conn.php';
include 'session.php';

if(isset($_POST['add'])){

	$fname = $_POST['fname'];
	$lname = $_POST['lname'];

	$insert = "insert into info_tbl (firstName,lastName) values ('$fname','$lname')";
	
	if($conn->query($insert)== TRUE){

			echo "Sucessfully add data";
			header('location:maintenance.php');
	}else{

		echo "Ooppss cannot add data" . $conn->connect_error;
		header('location:maintenance.php');
	}
	$insert->close();
}
?>

<html>
	<head>
		<link rel="stylesheet" type="text/css" href="mycss.css">
		<title>
			This is Sample
		</title>
		</head>
	<body>
		<div id="body">
			<div id="menu">
			<ul>
				<li><a href="home.php">Home</a></li>
				<li><a href="maintenance.php">Maintenance</a></li>
				<li><a href="logout.php">Logout</a></li>
			</ul>
			</div>
			<div id="content">
				<form action="result.php" method="get" ecntype="multipart/data-form">
						<table align="center">
							<tr>
								<td>Search: <input type="text" name="query"><input type="submit" value="Search" name="search"></td>
							</tr>
						</table>
				</form>
				<form action="maintenance.php" method="POST">
				<table align="center">
					<tr>
						<td>Fisrt Name: <input type="text" name="fname" value="" placeholder="Type Firstname here" required></td>
						</tr>
						<tr>
							<td>Last Name: <input type="text" name="lname" placeholder="Type Last Name here.." required></td>
						</tr>
						<tr>
							<td><input type="submit" name="add" value="Add"></td>
						</tr>
				</table>
			</form>
				<br>
				<table align="center" border="1" cellspacing="0" width="500">
					<tr>
					<th>First Name</th>
					<th>Last Name</th>
					<th>Action</th>
					</tr>
					<?php
					$sql = "SELECT * FROM info_tbl";
					$result = $conn->query($sql);
					if($result->num_rows > 0){
					while($row = $result->fetch_array()){
						?>
						<tr>
							<td align="center"><?php echo $row['firstName'];?></td>
							<td align="center"><?php echo $row['lastName'];?></td>
							<td align="center"><a href="edit.php?infoID=<?php echo md5($row['infoID']);?>">Edit
							</a>/<a href="delete.php?infoID=<?php echo md5($row['infoID']);?>">Delete</a></td>
						</tr>
						<?php
							}	
						}else{
							echo "<center><p> No Records</p></center>";
						}
				
				$conn->close();
				?>
				</table>
			</div>
		</div>
		</body>

</html>

7 – Retrieve Inserted data on Page From Database

this is Second step of CRUD system means Read or Retrieve Mysql Database data .

<table align="center" border="1" cellspacing="0" width="500">
					<tr>
					<th>First Name</th>
					<th>Last Name</th>
					<th>Action</th>
					</tr>
					<?php
					$sql = "SELECT * FROM info_tbl";
					$result = $conn->query($sql);
					if($result->num_rows > 0){
					while($row = $result->fetch_array()){
						?>
						<tr>
							<td align="center"><?php echo $row['firstName'];?></td>
							<td align="center"><?php echo $row['lastName'];?></td>
							<td align="center"><a href="edit.php?infoID=<?php echo md5($row['infoID']);?>">Edit
							</a>/<a href="delete.php?infoID=<?php echo md5($row['infoID']);?>">Delete</a></td>
						</tr>
						<?php
							}	
						}else{
							echo "<center><p> No Records</p></center>";
						}
				
				$conn->close();
				?>
				</table>

8 – Update inserted Data using PHP

This is the Third step of CRUD system Update or Edit Data.

<?php
include 'conn.php';
include 'session.php';

$id = $_GET['infoID'];
$view = "SELECT * from info_tbl where md5(infoID) = '$id'";
$result = $conn->query($view);
$row = $result->fetch_assoc();

if(isset($_POST['update'])){

	$ID = $_GET['infoID'];

	$fn = $_POST['fname'];
	$ln = $_POST['lname'];

	$insert = "UPDATE info_tbl set firstName = '$fn', lastName = '$ln' where md5(infoID) = '$ID'";
	
	if($conn->query($insert)== TRUE){

			echo "Sucessfully update data";
			header('location:maintenance.php');			
	}else{

		echo "Ooppss cannot add data" . $conn->error;
		header('location:maintenance.php');
	}
	$conn->close();
}
?>

<html>
	<head>
		<link rel="stylesheet" type="text/css" href="mycss.css">
		<title>
			This is Sample
		</title>
		</head>
	<body bgcolor="green">
		<div id="body">
			<div id="menu">
			<ul>
				<li><a href="home.php">Home</a></li>
				<li><a href="maintenance.php">Maintenance</a></li>
				<li><a href="logout.php">Logout</a></li>
			</ul>
			</div>
			<div id="content">
				<form action="" method="POST">
				<table align="center">
					<tr>
						<td>Fisrt Name: <input type="text" name="fname" value="<?php echo $row['firstName'];?>" placeholder="Type Firstname here" required></td>
						</tr>
						<tr>
							<td>Last Name: <input type="text" name="lname"  value="<?php echo $row['lastName'];?>" placeholder="Type Last Name here.." required></td>
						</tr>
						<tr>
							<td><input type="submit" name="update" value="Update"></td>
						</tr>
				</table>
			</form>
				<br>
			
			</div>
		</div>
		</body>

</html>

9 – Delete Data using PHP

This is the final step of CRUD system means Delete or Remove Data using PHP.

<?php
	include 'conn.php';
	$id = $_GET['infoID'];
	$sql = "Delete from info_tbl where md5(infoID) = '$id'";
	if($conn->query($sql) === true){
		echo "Sucessfully deleted data";
		header('location:maintenance.php');
	}else{
		echo "Oppps something error ";
	}
	$conn->close();
?>

10 – Creating the Session using PHP

in this step we are going to create session of login.

<?php
session_start();

if(!isset($_SESSION['userID']) || (trim($_SESSION['userID']) == '')){
	header('location:index.php');
	exit();
}

$session_id = $_SESSION['userID']; 
$session_id = $_SESSION['username']; 

?>

11 – Creating Logout

in this step we are going to create Logout for login user’s.

<?php
session_start();
session_destroy();
unset($_SESSION['userID']);
header('location:/sample/index.php');
exit();
?>

If you facing any type of problem with this source code then you can Download the Complete source code in zip Formate by clicking the below button Download Now otherwise you can send Comment.

Download Source Code

Categorized in:

PHP,

Comments

nasibullo on February 20, 2022

I tried to copy the code from screen but didnt understand which code is for which file.
I tried to download source code but also not possible.
you made it difficult to understand

- Deepak Raj on August 11, 2022
  
  plz check
  
Aru on April 5, 2022

Great work, but I can not download the source code.

- Deepak Raj on August 11, 2022
  
  plz check
  
Anonymous on August 24, 2022

It should be fine if you use the download button and correctly import the DB. After that startup your XAMPP -> Apache and MySQL and it all should work fine.

Samuel on February 22, 2023

Hello Deepak Raj. This is a nice breakdown. Although for a newbie, I am unable to understand which file goes where and unfortunately, I am unable to download the sample zip file.

- Deepak Raj on March 6, 2023
  
  https://www.sourcecodessite.com/wp-content/uploads/2016/09/Sample.rar

Press ESC to close

CRUD Operations

Create Login CRUD System using PHP MySQL

1-Creating Database

OR Import DB File

2- Creating Database Connection

3 – Create Login Form Using HTML

4 – Check user’s Availability in Database using PHP

5 – Create Home Page After Login

6 – Creating a Form and insert data into database using PHP

7 – Retrieve Inserted data on Page From Database

8 – Update inserted Data using PHP

9 – Delete Data using PHP

10 – Creating the Session using PHP

11 – Creating Logout

How To Create Portfolio Online using Bootstrap

How to Create JQuery UI Tabs

More in this CategoryPHP

How to Create Multi Functional Image Gallery App in PHP MySQL

How To Upload Multiple Image with Lightbox in PHP

Manage Product with Excel Import and Export in PHP MySQL

How To Create Multi Role Login System in PHP MySQL

Comments

Leave a Reply Cancel reply

Join to our community 👋