How to delete data from database using CodeIgniter framework

In this example we will discuss about how to delete a record or data from MySQL database using CodeIgniter framework PHP.

The DELETE statement is used to delete records from a table:

DELETE FROM table_name
WHERE some_column = some_value

Notice : The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!

The students table look like this:

id	first name	last name	Email Id	Action
1	Divyasundar	Sahu	divyasundar@gmail.com	Delete
2	Hritika	Sahu	hritika@gmail.com	Delete
3	Milan	Jena	milanjena@gmail.com	Delete

Now i am going to delete the id=3 record.

For delete record we use 3 file here

1. Crud.php Path: codeIgniter\application\controllers\Crud.php
2. Crud_model.php Path: codeIgniter\application\models\Crud_model.php
3. display_records.php Path: codeIgniter\application\view\display_records.php

Crud Sql Table

CREATE TABLE crud (
`id` int(11) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
PRIMARY KEY (id)
);

Crud.php

<?php 
class Crud extends CI_Controller 
{
public function __construct()
{
//call CodeIgniter's default Constructorparent::__construct();
//load database libray manually$this->load->database();
//load Model$this->load->model('Crud_model');
}
public function displaydata()
{
$result['data']=$this->Crud_model->display_records();
$this->load->view('display_records',$result);
} //Delete Recordpublic function deletedata()
{
$id=$this->input->get('id');
$this->Crud_model->deleterecords($id);
echo "Date deleted successfully !";
}
}
?>

Crud_model.php

<?php
class Crud_model extends CI_Model 
{
//Display function display_records(){ $query=$this->db->query("select * from crud");
return $query->result();
}
//Deletefunction deleterecords($id)
{
$this->db->query("delete from crud where id='".$id."'");
}
}

display_records.php

<!DOCTYPE html>
<html>
<head>
<title>Delete records</title>
</head>
<body>
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr style="background:#CCC">
<th>Sr No</th>
<th>First_name</th>
<th>Last_name</th>
<th>Email Id</th>
<th>Delete</th>
<th>Update</th>
</tr>
<?php
$i=1;
foreach($data as $row)
{
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td>".$row->first_name."</td>";
echo "<td>".$row->last_name."</td>";
echo "<td>".$row->email."</td>";
echo "<td><a href='deletedata?id=".$row->id."'>Delete</a></td>";
echo "</tr>";
$i++;
}
?>
</table>
</body>
</html>

Now run the program on your browser with the below URL:

http://localhost/CodeIgniter/index.php/Crud/displaydata

After delete the record the table look like this.

id	first name	last name	Email Id	Action
1	Divyasundar	Sahu	divyasundar@gmail.com	Delete
2	Hritika	Sahu	hritika@gmail.com	Delete

---

Next ❯