In SQL, sometimes we need to delete unwanted records from the table.

PHP MySQL Delete:

     

In SQL, sometimes we need to delete unwanted records from the table. SQL provides delete statement for this purpose. delete command can be used for delete one or more than one record at a time.

General format of the delete command is given as below:

delete from <table name>

where <condition>

 

Example:

<?php

$db=mysql_connect("localhost","root","");

if(!$db)

{

die("Can not Connect".mysql_error());

}

mysql_select_db("roseindia",$db);

echo "<br/> Before deletion :<br/>";

$result=mysql_query("select * from student");

while($row=mysql_fetch_array($result))

{

echo $row['e_id']." ".$row['age']."<br/>";

}

mysql_query("delete from student where e_id='emp02'");

echo"<br/>After Deletion a record:<br/>";

$result=mysql_query("select * from student");

while($row=mysql_fetch_array($result))

{

echo $row['e_id']." ".$row['age']."<br/>";

}

?>

Output:

Before deletion :
emp01 26
emp02 27
emp05 26
emp_05 28
After Deletion a record:
emp01 26
emp05 26
emp_05 28

Related Tags for PHP MySQL Delete:

More Tutorials from this section

• PHP Tutorials from RoseIndia
• PHP Chat Systems A MySQL Driven Chat Script Tutorial
• PHP Chat Systems A MySQL Driven
• PHP Cookies
• Create your Email Server by PHP
• Dynamic Dropdown Menu
• echo- Not a function
• PHP File Manipulation Writing to a File Tutorial
• htmlentities
• PHP Tutorials from RoseIndia
• PHP Generate a pages loading time Tutorial
• PHP Ajax and Database
• PHP Ajax
• PHP Make a shoutbox without using MYSQL Tutorial
• PHP Displaying the date and time in your timezone Tutorial
• PHP Display date and time
• PHP Error handling
• PHP Filter
• PHP Cookies and Sessions Flood protection using cookies Tutorial
• PHP : Form to Email