Delete statement in PHP

PHP Tutorials By Vineet Kumar Saini

Delete Statement in PHP

In this article I will explain how to delete data in the database through HTML table. In this
article you will see, data deleted from the front end i.e. HTML table.

Code

<?php
$con=mysql_connect ("localhost","root","");
mysql_select_db ("mcn",$con);
@$a=$_POST['txt1'];
@$b=$_POST['txt2'];
@$c=$_POST['txt3'];
@$d=$_POST['txt4'];
if(@$_POST ['del'])
{
$s="delete from employee where name='$a'";
echo "Your Data Deleted";
mysql_query ($s);
}
$con=mysql_connect ("localhost","root","");
mysql_select_db ("mcn",$con);
if(@$_POST ['sel'])
{
echo $ins=mysql_query ("select * from employee");
echo "<table bgcolor=skyblue border='2' align=center>
<tr>
<th colspan=4>Select Data From Employee Table</th></tr>
<tr>
<th>Nmae</th>
<th>Designation</th>
<th>Sal</th>
<th>Qualification</th>
</tr>";
while ($row=mysql_fetch_array($ins))
{
echo "<tr>";
echo "<th>".$row ['Name']."</th>";
echo "<th>". $row ['Designation']. "</th>";
echo "<th>". $row ['Sal']."</th>";
echo "<th>".$row ['Qualification']."</th>";
echo "</tr>";
}
}
echo "</table>"
?>
<html>
<head>
</head>
<body bgcolor="pink">
< center>


<table bgcolor="skyblue" border="2">
< form method="post">
< tr>
<td colspan=2 align="center">Employee Table</td>
</ tr>
<td>Name</td><td><input type="text" name="txt1"></td>
</ tr>
<tr>
<td>Designation</td><td><input type="text" name="txt2"></td>
</ tr>
<tr>
<td>Sal</td><td><input type="text" name="txt3"></td>
</ tr>
<tr>
<td>Qualification</td><td><input type="text" name="txt4"></td>
</ tr>
<tr>
<td><input type="submit" name="del" value="Delete"></td>
< td><input type="submit" name="sel" value="Select"></td>
</ tr>
</form>
</table>
</center>
</body>
</ html

Output

First of all you will select data from the database using the select button. When you will click
on the select button then you will see the data table displayed on your web page. Like as in
the following image.


Suppose you want to delete Brajesh Kumar from your database. For this purpose you will fill
in the name of the employee in the employee table, then click on the delete button. You can
see in the following image.

When you will click on the delete button then display a message on your webpage i.e. "Your
Data Deleted".

Now you will click on the select button for the selected data from the database. When you
click on the select button then display data table on your web page. In this table you will
see Brajesh kumar employee not exist. You can see in the following image.


Conclusion

So in this article you saw how to delete data from a database in a HTML table (front end).
Using this article one can easily understand how to delete data from a database.

Delete statement in PHP

More Related Content

What's hot

Similar to Delete statement in PHP

More from Vineet Kumar Saini

Recently uploaded

Delete statement in PHP