PHP CRUD Operation Using MySQLi (Source Code)

We develop a simple core PHP CRUD Operation Using MySQLi With example source code. Which you use to learn PHP basics very quick and easy way. Here I will show you Create, read, update and delete operation with image uploading.

Anyone want a complete file in ZIP Check comment below.

So from here, we have started the code by creating a PHP MySQLi connection file, see the below code and if have you any problem with these of any line you can ping me with the comment box.

To Create a complete PHP CRUD Operation we create those required files,

connect.php
registration.php
Login.php
home.php
view.php
edit.php
delete.php

And if you like it give me a word on comment how’s it.

Lets Start,

PHP CRUD Operation Using MySQLi With Source Code

Connect.php (DB Connection File)

This is the database connection file, that is included in all other files to maintain the DB connection globally.
On mysqli_connect function first parameter is HOSTNAME, second is Database User Name, third is for Password and the last parameter is for Database Name.

<?php
//Session is use for store value of variables and transfer it to one page to another
session_start();

$con= mysqli_connect("localhost","root","","test")
?>

<?php

//Session is use for store value of variables and transfer it to one page to another

session_start();

$con= mysqli_connect("localhost","root","","test")

Registration.php (PHP User register File)

This is the user registration page where we create a query for the insertion of user data into the database. Where we use MySQLi which is the newer or extended version of MySQL.

<?php
//This is connection file which we create on first and include using PHP include function.
include 'connect.php';

//we use isset function, where it take submit button name and check button is clicked or not, if not clicked than code is not running
if (isset($_POST['sub']))
{
    $t = $_POST['text'];
    $u = $_POST['user'];
    $p = $_POST['pass'];
    $c = $_POST['city'];
    $g = $_POST['gen'];
    if ($_FILES['f1']['name'])
    {

        //This function is used for uploading image on the directory which you create on project root directory
        move_uploaded_file($_FILES['f1']['tmp_name'], "image/" . $_FILES['f1']['name']);
        $img = "image/" . $_FILES['f1']['name'];
    }

    //This is insertion query of mysql
    $i = "insert into reg(name,username,password,city,image,gender)value('$t','$u','$p','$c','$img','$g')";

    //On extend version of mysql, mysqli takes two parameters where First is connection variable and second is query variable
    mysqli_query($con, $i);
}
?>
<html>

<head>
	<meta charset="UTF-8">
	<title></title>
</head>

<body>
	<!--on this enctype attribute is important for uploading files and also mandatory-->
	<form method="POST" enctype="multipart/form-data">
		<table>
			<tr>
				<td> Name
					<input type="text" name="text"> </td>
			</tr>
			<tr>
				<td> Username
					<input type="text" name="user"> </td>
			</tr>
			<tr>
				<td> password
					<input type="password" name="pass"> </td>
			</tr>
			<tr>
				<td> city
					<select name="city">
						<option value="">-select-</option>
						<option value="knp">kanpur</option>
						<option value="lko">lucknow</option>
				</td>
			</tr>
			<tr>
				<td> Gender
					<input type="radio" name="gen" id="gen" value="male">male
					<input type="radio" name="gen" id="gen" value="female">female </td>
			</tr>
			<tr>
				<td> Image
					<input type="file" name="f1"> </td>
			</tr>
			<tr>
				<td>
					<input type="submit" value="submit" name="sub"> </td>
			</tr>
		</table>
</body>

</html>

<?php

//This is connection file which we create on first and include using PHP include function.

include 'connect.php';

//we use isset function, where it take submit button name and check button is clicked or not, if not clicked than code is not running

if (isset($_POST['sub']))

{

$t = $_POST['text'];

$u = $_POST['user'];

$p = $_POST['pass'];

$c = $_POST['city'];

$g = $_POST['gen'];

if ($_FILES['f1']['name'])

{

//This function is used for uploading image on the directory which you create on project root directory

move_uploaded_file($_FILES['f1']['tmp_name'], "image/" . $_FILES['f1']['name']);

$img = "image/" . $_FILES['f1']['name'];

}

//This is insertion query of mysql

$i = "insert into reg(name,username,password,city,image,gender)value('$t','$u','$p','$c','$img','$g')";

//On extend version of mysql, mysqli takes two parameters where First is connection variable and second is query variable

mysqli_query($con, $i);

}

<html>

<head>

</head>

<body>

<table>

<tr>

<td> Name

</tr>

<tr>

<td> Username

</tr>

<tr>

<td> password

</tr>

<tr>

<td> city

<option value="">-select-</option>

<option value="knp">kanpur</option>

<option value="lko">lucknow</option>

</td>

</tr>

<tr>

<td> Gender

<input type="radio" name="gen" id="gen" value="male">male

<input type="radio" name="gen" id="gen" value="female">female </td>

</tr>

<tr>

<td> Image

</tr>

<tr>

<td>

</tr>

</table>

</body>

</html>

Login.php (PHP User Login File)

Next is the login operation with MySQLi SELECT query, If you want to know more about mysqli_num_rows which we use below you can click on the link.

<?php
include 'connect.php';
if (isset($_POST['sub']))
{
    $u = $_POST['user'];
    $p = $_POST['pass'];
    $s = "select * from reg where username='$u' and password= '$p'";
    $qu = mysqli_query($con, $s);

    //Here we check if our query is correct then databse have how many rows on o/p.
    if (mysqli_num_rows($qu) > 0)
    {
        $f = mysqli_fetch_assoc($qu);

        //Here we store the value ID on session for login and fetch data of same user who is logged in.
        $_SESSION['id'] = $f['id'];

        //if all conditions are correct then redirects to this page.
        header('location:home.php');
    }
    else
    {
        echo 'username or password does not exist';
    }

}
?>
<html>

<head>
	<meta charset="UTF-8">
	<title></title>
</head>

<body>
	<form method="POST" enctype="multipart/form-data">
		<table>
			<tr>
				<td> Username
					<input type="text" name="user"> </td>
			</tr>
			<tr>
				<td> password
					<input type="password" name="pass"> </td>
			</tr>
			<tr>
				<td>
					<input type="submit" name="sub" value="submit"> </td>
			</tr>
		</table>
</body>

</html>

<?php

include 'connect.php';

if (isset($_POST['sub']))

{

$u = $_POST['user'];

$p = $_POST['pass'];

$s = "select * from reg where username='$u' and password= '$p'";

$qu = mysqli_query($con, $s);

//Here we check if our query is correct then databse have how many rows on o/p.

if (mysqli_num_rows($qu) > 0)

{

$f = mysqli_fetch_assoc($qu);

//Here we store the value ID on session for login and fetch data of same user who is logged in.

$_SESSION['id'] = $f['id'];

//if all conditions are correct then redirects to this page.

header('location:home.php');

}

else

{

echo 'username or password does not exist';

}

<html>

<head>

</head>

<body>

<table>

<tr>

<td> Username

</tr>

<tr>

<td> password

</tr>

<tr>

<td>

</tr>

</table>

</body>

</html>

View user’s data

View.php

<?php
include 'connect.php';
?>
<table border='1'>
   <tr>
      <th> Name </th>
      <th> Username </th>
   </tr>

<?php
 $sq="select * from reg";
 $qu=mysqli_query($con,$sq);

//we use while loop for all data of the user and fetch_assoc function useful for getting data from database
 while($f= mysqli_fetch_assoc($qu)){
?>
<tr>
  <td><?php echo $f['name']?></td>
  <td><?php echo $f['username']?></td>
</tr>
<?php
}
?>

<?php

include 'connect.php';

<tr>

<th> Username </th>

</tr>

<?php

$sq="select * from reg";

$qu=mysqli_query($con,$sq);

//we use while loop for all data of the user and fetch_assoc function useful for getting data from database

while($f= mysqli_fetch_assoc($qu)){

<tr>

</tr>

<?php

}

Home.php

On this page you can see particular user data which we get by using PHP SESSION.

<?php
include'connect.php';
//here we check the id with session id which we get on the time of login
$s="select*from reg where id='$_SESSION[id]'";
$qu= mysqli_query($con, $s);
$f=mysqli_fetch_assoc($qu);
?>
<html>
  <head>
  </head>
  <body>
    <table>
      <tr>
        <td>
          Name
        </td>
        <td>
          <?php echo $f['name'];?>
        </td>
      </tr>
      <tr>
        <td> Username
        </td>
        <td>
          <?php
echo $f['username'];?>
        </td>
      </tr>
      <tr>
        <td> Password
        </td>
        <td>
          <?php
echo $f['password']."<br>";?>
        </td>
      </tr>
      <tr>
        <td> City 
        </td> 
        <td>
          <?php
echo $f['city']."<br>";?>
        </td>
      </tr>
      <tr>
        <td>Gender
        </td>
        <td>
          <?php
echo $f['gender']."<br>";?>
        </td>
      </tr>
      <tr>
        <td> Image
        </td>
        <td>
          <img src="<?php
                    echo $f['image'];?>" width="100px" height="100px">
        </td>
      </tr>
    </table>
    <a href="edit.php">Edit
    </a>
    <a href="delete.php">Delete
    </a>
  </body>
</html>

<?php

include'connect.php';

//here we check the id with session id which we get on the time of login

$s="select*from reg where id='$_SESSION[id]'";

$qu= mysqli_query($con, $s);

$f=mysqli_fetch_assoc($qu);

<html>

<head>

</head>

<body>

<table>

<tr>

<td>

Name

</td>

<td>

<?php echo $f['name'];?>

</td>

</tr>

<tr>

<td> Username

</td>

<td>

<?php

echo $f['username'];?>

</td>

</tr>

<tr>

<td> Password

</td>

<td>

<?php

echo $f['password']."<br>";?>

</td>

</tr>

<tr>

<td> City

</td>

<td>

<?php

echo $f['city']."<br>";?>

</td>

</tr>

<tr>

<td>Gender

</td>

<td>

<?php

echo $f['gender']."<br>";?>

</td>

</tr>

<tr>

<td> Image

</td>

<td>

<img src="<?php

echo $f['image'];?>" width="100px" height="100px">

</td>

</tr>

</table>

<a href="edit.php">Edit

</a>

<a href="delete.php">Delete

</a>

</body>

</html>

Edit.php

See how we edit the particular user data using UPDATE query and SESSION.

<?php
include'connect.php';
if(isset($_POST['sub'])){
  $t=$_POST['text'];
  $u=$_POST['user'];
  $p=$_POST['pass'];
  $c=$_POST['city'];
  $g=$_POST['gen'];
 if($_FILES['f1']['name']){
   move_uploaded_file($_FILES['f1']['tmp_name'], "image/".$_FILES['f1']['name']);
   $img="image/".$_FILES['f1']['name'];
 }
 else{
   $img=$_POST['img1'];
 }
 $i="update reg set name='$t',username='$u',password='$p',city='$c',gender='$g',image='$img' where   id='$_SESSION[id]'";
 mysqli_query($con, $i);
 header('location:home.php');
}
$s="select*from reg where id='$_SESSION[id]'";
$qu= mysqli_query($con, $s);
$f=mysqli_fetch_assoc($qu);
?>
<form method="POST" enctype="multipart/form-data">
  <table>
    <tr>
      <td>
        Name
        <input type="text" name="text" value="<?php echo $f['name']?>">
      </td>
    </tr>
    <tr>
      <td>
        Username
        <input type="text" name="user" value="<?php echo $f['username']?>">
      </td>
    </tr>
    <tr>
      <td>
        password
        <input type="password" name="pass" value="<?php echo $f['password']?>">
      </td>
    </tr>
    <tr>
      <td>
        city
        <select name="city">
          <option value="">-select-
          </option>
          <option value="knp"
<?php if($f['city']=='knp'){ echo "selected='selected'";}?>>kanpur</option>
        <option value="lko"<?php if($f['city']=='lko'){ echo "selected='selected'";}?>>lucknow</option>
    </td>
  </tr>
<tr>
  <td>
    Gender
    <?php if($f['gender']=='male'){
?>
    <input type="radio"name="gen" id="gen" value="male" checked>
    <?php
} else {
?>
    <input type="radio"name="gen" id="gen" value="male">
    <?php } ?>male
    <?php if($f['gender']=='female'){
?>
    <input type="radio"name="gen" id="gen" value="female" checked>
    <?php
} else {
?>
    <input type="radio"name="gen" id="gen" value="female">
    <?php } ?>female
  </td>
</tr>
<tr>
  <td>
    Image
    <img src="<?php echo $f['image']?>" width="100px" height="100px">
    <input type="file" name="f1">
    <input type="hidden" name="img1" value="<?php echo $f['image']?>">
  </td>
</tr>
<tr>
  <td>
    <input type="submit" value="submit" name="sub">
  </td>
</tr>
</table>
</form>

<?php

include'connect.php';

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

$t=$_POST['text'];

$u=$_POST['user'];

$p=$_POST['pass'];

$c=$_POST['city'];

$g=$_POST['gen'];

if($_FILES['f1']['name']){

move_uploaded_file($_FILES['f1']['tmp_name'], "image/".$_FILES['f1']['name']);

$img="image/".$_FILES['f1']['name'];

}

else{

$img=$_POST['img1'];

}

$i="update reg set name='$t',username='$u',password='$p',city='$c',gender='$g',image='$img' where id='$_SESSION[id]'";

mysqli_query($con, $i);

header('location:home.php');

}

$s="select*from reg where id='$_SESSION[id]'";

$qu= mysqli_query($con, $s);

$f=mysqli_fetch_assoc($qu);

<table>

<tr>

<td>

Name

</td>

</tr>

<tr>

<td>

Username

</td>

</tr>

<tr>

<td>

password

</td>

</tr>

<tr>

<td>

city

<option value="">-select-

</option>

<option value="knp"

<?php if($f['city']=='knp'){ echo "selected='selected'";}?>>kanpur</option>

<option value="lko"<?php if($f['city']=='lko'){ echo "selected='selected'";}?>>lucknow</option>

</td>

</tr>

<tr>

<td>

Gender

<?php if($f['gender']=='male'){

<?php

} else {

<?php } ?>male

<?php if($f['gender']=='female'){

<?php

} else {

<?php } ?>female

</td>

</tr>

<tr>

<td>

Image

<img src="<?php echo $f['image']?>" width="100px" height="100px">

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

Last is delete file. DELETE.php

<?php
include 'connect.php';
$sq="delete from reg where id='$_SESSION[id]'";
mysqli_query($con,$sq);
header('location:add_district.php');
?>

<?php

include 'connect.php';

$sq="delete from reg where id='$_SESSION[id]'";

mysqli_query($con,$sq);

header('location:add_district.php');

Above is complete CRUD operation with image uploading and Login Registration operation with some easy manner.
Any query, feel free to ping me on mail Contact us or on comment.

Also Read:

Happy Coding…!

Was this article helpful?

YesNo

19 thoughts on “PHP CRUD Operation Using MySQLi (Source Code)”

Atanda says:

February 11, 2019 at 8:35 pm

I want the complete file

1. B says:
  
  February 12, 2019 at 4:27 am
  
  Hello Coder,
  Check your mail..!
  
  1. Harshal Sanjay Mahajan says:
    
    September 13, 2021 at 3:03 pm
    
    I want completed file
    
    1. Bikash says:
      
      September 13, 2021 at 3:14 pm
      
      https://codingtasks.net/download/download-source-code-simple-php-mysql-crud-operation/
      
  2. Sahil patel says:
    
    March 23, 2022 at 2:04 pm
    
    Please sand complete project source code
    
oudom phat says:

August 5, 2019 at 4:25 pm

please send to me for complete code

1. Bikash says:
  
  August 5, 2019 at 4:47 pm
  
  Please check your email.
  
Deepak jerry says:

November 28, 2019 at 10:46 am

please send code o deepakmarudih786@gmail.com

1. Bikash says:
  
  December 19, 2019 at 3:30 pm
  
  Download from here: Click Here
  
Siva says:

December 19, 2019 at 10:02 am

Please share the code

1. Bikash says:
  
  December 19, 2019 at 3:29 pm
  
  Download from here: Click Here
  
2. Bikash says:
  
  January 30, 2020 at 3:30 pm
  
  Download from here: http://codingtasks.net/download/download-source-code-simple-php-mysql-crud-operation/
  
Complete Guide About PHP With MySQL Connection - PHPCODER.TECH says:

April 13, 2021 at 9:53 pm

[…] Simple PHP MySQL CRUD Operation […]

Alee says:

July 27, 2021 at 4:27 pm

send complete source file

1. Bikash says:
  
  July 27, 2021 at 10:21 pm
  
  Download from here: http://codingtasks.net/download/download-source-code-simple-php-mysql-crud-operation/
  
How to get data from the hidden fields in PHP? - PHPCODER.TECH says:

November 15, 2021 at 7:48 pm

[…] Also Read: PHP CRUD Operation Using MySQLi (Source Code) […]

freedom says:

January 14, 2022 at 4:15 pm

tancks

swasanthrika says:

February 7, 2022 at 1:04 pm

hi iwant curd operations complete code like edit update edit and delete code in php

How to get hidden input field values in PHP? - PHPCODER.TECH says:

November 17, 2022 at 11:30 pm

[…] Also Read: PHP CRUD Operation Using MySQLi (Source Code) […]

PHP CRUD Operation Using MySQLi (Source Code)

Also Read:

By Bikash

Related Post

19 thoughts on “PHP CRUD Operation Using MySQLi (Source Code)”

Leave a Reply Cancel reply

You Missed

5 Most Effective Ways To Optimize PHP Code

Debugging in PHP: A Comprehensive Guide with Examples

3 popular ways to make HTTP requests in JavaScript

PHP: Logout From All Devices on Password Change