Insert Update Delete In PHP

Hi guys, we are going to take a look on how to insert, update & delete in PHP with Mysql database.
Whatever application or technology it may be inserting, updating and deleting operations are a key.
Let’s jump into the coding part.

insert-update-delete-in-php

Demo Video:

 

1. Configuration file to connect to database.

config.php

<?php
$connection = mysql_connect('localhost', 'root', '');
if (!$connection){
die("Database Connection Failed" . mysql_error());
}
$select_db = mysql_select_db('samplephp');
if (!$select_db){
die("No database selected" . mysql_error());
}
?>

 

2. View all recorded data from the database.

index.php

<?php 
require('config.php');
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>View Data</title>
<link rel="stylesheet" href="css/style.css" />
</head>
<body>
<div class="form">
<center><p><a href="insert.php">Insert New Data</a></p>
<h2>View Data</h2></center>
<table width="100%" border="1" style="border-collapse:collapse;">
<thead>
<tr><th><strong>No</strong></th><th><strong>Name</strong></th><th><strong>City</strong></th><th><strong>Phone</strong></th><th><strong>Update</strong></th><th><strong>Delete</strong></th></tr>
</thead>
<tbody>
<?php
$count=1;
$sel_query="Select * from sample ORDER BY id asc;";
$result = mysql_query($sel_query);
while($row = mysql_fetch_assoc($result)) { ?>
<tr><td align="center"><?php echo $count; ?></td><td align="center"><?php echo $row["name"]; ?></td><td align="center"><?php echo $row["city"]; ?></td><td align="center"><?php echo $row["phone"]; ?></td><td align="center"><a href="edit.php?id=<?php echo $row["id"]; ?>">Update</a></td><td align="center"><a href="delete.php?id=<?php echo $row["id"]; ?>">Delete</a></td></tr>
<?php $count++; } ?>
</tbody>
</table>
</div>
</body>
</html>

 

3. Insert record into the database.

insert.php

<?php
require('config.php');
$status = "";
if(isset($_POST['new']) && $_POST['new']==1)
{
$name =$_REQUEST['name'];
$city =$_REQUEST['city'];
$phone = $_REQUEST['phone'];
$ins_query="insert into sample(`name`,`city`,`phone`)values('$name','$city','$phone')";
mysql_query($ins_query) or die(mysql_error());
$status = "New Record Inserted Successfully.</br></br><a href='index.php'>View Inserted Record</a>";
header("Location: index.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert New Data</title>
<link rel="stylesheet" href="css/style.css" />
</head>
<body>
<div class="form">
<center><p><a href="index.php">View Data</a></p></center>
<div>
<h2>Insert New Data</h2></center>
<form name="form" method="post" action=""> 
<input type="hidden" name="new" value="1" />
<p><input type="text" name="name" placeholder="Enter Name" required /></p>
<p><input type="text" name="city" placeholder="Enter City" required /></p>
<p><input type="text" name="phone" placeholder="Enter Phone" required /></p>
<p><input name="submit" type="submit" value="Submit" /></p>
</form>
<p style="color:#FF0000;"><?php echo $status; ?></p>
</div>
</div>
</body>
</html>

 

4. Update record in the database.

edit.php


<?php 
require('config.php');
$id=$_REQUEST['id'];
$query = "SELECT * from sample where id='".$id."'"; 
$result = mysql_query($query) or die ( mysql_error());
$row = mysql_fetch_assoc($result);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Update Data</title>
<link rel="stylesheet" href="css/style.css" />
</head>
<body>
<div class="form">
<p><a href="insert.php">Insert New Data</a></p>
<h1>Update Data</h1>
<?php
$status = "";
if(isset($_POST['new']) && $_POST['new']==1)
{
$id=$_REQUEST['id'];
$name =$_REQUEST['name'];
$city =$_REQUEST['city'];
$phone =$_REQUEST['phone'];
$update="update sample set name='".$name."',city='".$city."', phone='".$phone."' where id='".$id."'";
mysql_query($update) or die(mysql_error());
$status = "Data Updated. </br></br><a href='index.php'>View Data</a>";
echo '<p style="color:#FF0000;">'.$status.'</p>';
header("Location: index.php");
}else {
?>
<div>
<form name="form" method="post" action=""> 
<input type="hidden" name="new" value="1" />
<input name="id" type="hidden" value="<?php echo $row['id'];?>" />
<p><input type="text" name="name" placeholder="Enter Name" required value="<?php echo $row['name'];?>" /></p>
<p><input type="text" name="city" placeholder="Enter City" required value="<?php echo $row['city'];?>" /></p>
<p><input type="text" name="phone" placeholder="Enter Phone" required value="<?php echo $row['phone'];?>" /></p>
<p><input name="submit" type="submit" value="Update" /></p>
</form>
<?php } ?>
</div>
</div>
</body>
</html>

 

5. Delete record from the database.

delete.php

<?php 
require('config.php');
$id=$_REQUEST['id'];
$query = "DELETE FROM sample WHERE id=$id"; 
$result = mysql_query($query) or die ( mysql_error());
header("Location: index.php"); 
 ?>

 

6. Sql database file.

samplephp.sql


CREATE TABLE IF NOT EXISTS `sample` (
`id` int(50) NOT NULL,
 `name` varchar(100) NOT NULL,
 `city` varchar(100) NOT NULL,
 `phone` varchar(100) NOT NULL
)

INSERT INTO `sample` (`id`, `name`, `city`, `phone`) VALUES
(15, 'John Doe', 'New York City', '6544375554'),
(16, 'Alex Texas', 'California', '6456778888'),
(17, 'Leo Moosa', 'London', '123456789'),
(18, 'Pedro Santos', 'Madrid', '2345087665');

 

3 comments

Leave a Reply

Your email address will not be published. Required fields are marked *