Add Edit Update Delete Using Php and Mysql

Last Updated on May 25, 2020

Hi Guys, Every web programming language have database operations.

A very basic database operations are add,edit ,update and delete database records. In this tutorial I have to teach how to add ,edit,delete,update a record using php and mysql.

I have to add basic student details in database.I create and use four files to perform this basic database operations.

1. Config.php
2. Index.php
3. edit-studentdetail.php
4. Manage-students.php

Config.php

contains database connection Details.see the below code.

<?php
$con=mysql_connect('localhost','root',''); //Database Connections
$db=mysql_select_db('student',$con); // Database Name
?>

Index.php

index.php perform  add student details in database .below code explain this operations.

<?php
include('config.php'); // Database Config
/* Add Student Detail Php  */
if(isset($_POST['add'])) // Check form submit or not
{
$name=$_POST['name'];	

$gender=$_POST['gender'];

$department=$_POST['dept'];		

$terms=$_POST['terms'];

// Check all fields are empty or not if empty return error message
if($name=='' && $gender=='' && $department=='') 
{
// Assign Messge variable
$msg="All fields are mandatary.Please fill It";	 
}
else
{
$query="INSERT INTO `student_detail`(name,gender,department,terms)values('$name','$gender','$department','$terms')";	
$result=mysql_query($query);	
if($result)
{
$msg="Student Detail Successfully Added"; // Success Message
echo '<meta http-equiv="refresh" content="0;manage-studentdetail.php?msg='.$msg.'" />';
}
}
}
?>
<h2><?php echo $msg ?></h2> 

<table align="center" width="400px" cellpadding="5" cellspacing="5" bgcolor="#E6E6E6" border="1" rules="all">
<tr>
<td><a href="index.php">Add Student</a></td>
<td><a href="manage-studentdetail.php">Manage Student</a></td>
</tr>
</table>

<!-- Add Student Detail Form  -->
<h3 align="center">Add Student Detail</h3>
<form method="post" action="<?php $_SERVER['PHP_SELF']?>">
<table align="center" width="500px" cellpadding="5" cellspacing="5">
<tr>
<td>Name:</td>
<td><input type="text" name="name" /></td>
</tr>
<tr>
<td>Gender:</td>
<td>
<input type="radio" name="gender" value="Male" />Male &nbsp;
<input type="radio" name="gender" value="Female" />Female
</td>
</tr>
<tr>
<td>Department:</td>
<td>
<select name="dept">
<option value="" selected="selected">Select Department</option>
<option value="CSE">CSE</option>
<option value="EEE">EEE</option>
<option value="ECE">ECE</option>
<option value="MECH">MECH</option>
</select>
</td>
</tr>
<tr>
<td>Hobby:</td>
<td>
<input type="checkbox" name="terms"  value="Yes"/>
Accept Terms and conditions
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="add" value="Add student" /></td>
</table>
</form>

Edit-studentdetails.php 

In this file perform edit and delete student record .see the below code

<?php
include('config.php'); // Database Config

/* Update Student Detail Php  */

if(isset($_POST['uid'])) // Get id
{

$eid = $_POST['uid'];

$name=$_POST['name'];	

$gender=$_POST['gender'];

$department=$_POST['dept'];		

$terms=$_POST['terms'];


if($name=='' && $gender=='' && $department=='') // Check all fields are empty or not if empty return error message
{
$msg="All fields are mandatary.Please fill It";	// Assign Messge variable 
}
else
{
$query="UPdate `student_detail` SET name='$name',gender='$gender',department='$department',terms='$terms' WHERE id='$eid'";	
$result=mysql_query($query);	
if($result)
{
$msg="Student Detail Updated"; // Success Message
echo '<meta http-equiv="refresh" content="0;manage-studentdetail.php?msg='.$msg.'" />';
}
}
}
?>

<?php
$eid=$_GET['id'];
$getdata=mysql_query("SELECT * FROM `student_detail` WHERE id='$eid'");
$row=mysql_fetch_array($getdata);
?>

<h2><?php echo $msg ?></h2>
<!-- Edit Student Detail Form  -->

<form method="post" action="<?php $_SERVER['PHP_SELF']?>">
<table align="center" width="500px" cellpadding="5" cellspacing="5">
<tr>
<td>Name:</td>
<td><input type="text" name="name" value="<?php echo $row['name']?>" /</td>
</tr>
<tr>
<td>Gender:</td>
<td>
<input type="radio" name="gender" value="Male" <?php if($row['gender']=='Male') {?> checked="checked" <? } ?> />Male &nbsp;
<input type="radio" name="gender" value="Female" <?php echo $row['gender']?> 
<?php if($row['gender']=='Female') {?> checked="checked" <? } ?> />Female
</td>
</tr>
<tr>
<td>Department:</td>
<td>
<select name="dept">
<option value="CSE" <?php if($row['department']=='CSE') {?> selected="selected" <? } ?>>CSE</option>
<option value="EEE" <?php if($row['department']=='EEE') {?> selected="selected" <? } ?>>EEE</option>
<option value="ECE" <?php if($row['department']=='ECE') {?> selected="selected" <? } ?>>ECE</option>
<option value="MECH" <?php if($row['department']=='MECH') {?> selected="selected" <? } ?>>MECH</option>
</select>
</td>
</tr>
<tr>
<td>Terms:</td>
<td>
<input type="checkbox" name="terms"  value="Yes" <?php echo $row['terms']?><?php if($row['terms']=='Yes') {?> checked="checked" 
<? } ?>/>Accept Terms and conditions
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="hidden" name="uid" value="<?php echo $eid ?>" />
<input type="submit" name="update" value="Update" /></td>
</table>
</form>

Next Manage-students.php

Manage-students.php  perform  show all students details fetch from database with edit and delete link. Edit link perform edit student record and update record operations, delete link perform delete a particular record in  database.In the below code explain this operations

<?php
include('config.php'); // Database Config
/* Delete Student Detail Php  */
if(isset($_GET['did'])) // Get Id
{
$did=$_GET['did'];
$query="DELETE FROM `student_detail` WHERE id='$did'";	
$result=mysql_query($query);	
if($result)
{
$msg="Student Detail Deleted Successfully "; // Success Message
}
}
?>
<?php
if(isset($_GET['msg']))
{
?>
<h2 align="center"><?php echo $_GET['msg'] // Message From Edit Page?></h2> 
<?	
}
?>
<h2 align="center"><?php echo $msg ?></h2> 

<table align="center" width="400px" cellpadding="5" cellspacing="5" bgcolor="#E6E6E6" border="1" rules="all">
<tr>
<td><a href="index.php">Add Student</a></td>
<td><a href="manage-studentdetail.php">Manage Student</a></td>
</tr>
</table>

<!-- Manage Student Detail  -->
<table align="center" width="500px" cellpadding="5" cellspacing="5" border="1px" rules="all">
<tr>
<td>S.no</td>
<td>Name</td>
<td>Gender</td>
<td>Department</td>
<td>Terms</td>
<td>Edit</td>
<td>Delete</td>
</tr>
<?php
$i=1;
$getdata=mysql_query("SELECT * FROM `student_detail`");
while($row=mysql_fetch_array($getdata))
{
?>
<tr>
<td><?php echo $i ?></td>
<td><?php echo $row['name'];?></td>
<td>
<?php echo $row['gender'];?>
</td>
<td><?php echo $row['department'];?></td>
<td>
<?php echo $row['terms'];?>
</td>
<td><a href="edit-studentdetail.php?id=<?php echo $row['id']?>">Edit</a></td>
<td><a href="manage-studentdetail.php?did=<?php echo $row['id']?>">Delete</a></td>
</tr>
<?
$i++;
}
?>
</table>

I hope in this tutorial give a basic idea about database operations using php and mysql. If you any doubt please leave a comment.