PHP Basics

PHP MySQLi Delete Record

So far, I have discussed about connection establishment, create table, insert record, read records (select statement), update record. In this article we are going to learn about delete a record.

Following is the table which I am going to delete a record. This table name is emp_info

emp_id emp_name emp_age
1 Raj 22
2 Rahul 24
3 Vivek 26
4 Ajay 28
5 Suraj 29

In the above table, I want to delete the record whose id is 4

Assuming, you have followed previous tutorials, I am focusing straight to the code.

Delete Record

$conn=mysqli_connect(“localhost”,”root”,””,”emp_db”);

$sql=”delete from emp_info where id=4″;

if(mysqli_query($conn,$sql)){

echo “record deleted successfully”;

}else{

echo “Unable delete record”:

}

Output: Record deleted

So after deleting the record, the table is like below.

emp_id emp_name emp_age
1 Raj 22
2 Rahul 24
3 Vivek 26
5 Suraj 29