Codeigniter Tutorials

Home » Codeigniter »

How to Delete data from DB using codeigniter?

VIEW FILE: delete_view.php

<!DOCTYPE html>
<html>
<head>
<title>Delete Data From Database Using CodeIgniter</title>

<link href='http://fonts.googleapis.com/css?family=Marcellus' rel='stylesheet' type='text/css'>
<link href="<?php echo base_url()?>./css/delete.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="container">
<div id="wrapper">
<h1>Delete Data From Database Using CodeIgniter</h1>
<div id="menu">
<p>Click On Menu</p>

<ol>
<?php foreach ($students as $student): ?>
<li><a href="<?php echo base_url() . "index.php/delete_ctrl/show_student_id/" . $student->student_id; ?>"><?php echo $student->student_name; ?></a>
</li><?php endforeach; ?>
</ol>
</div>
<div id="detail">

<?php foreach ($single_student as $student): ?>
<p>Student Detail</p>
<?php echo $student->student_name; ?>
<?php echo $student->student_email; ?>
<?php echo $student->student_mobile; ?>
<?php echo $student->student_address; ?>

<a href="<?php echo base_url() . "index.php/delete_ctrl/delete_student_id/" . $student->student_id; ?>">
<button>Delete</button></a>
<?php endforeach; ?>
</div>
</div>
</div>
</body>
</html>

CONTROLLER FILE: delete_ctrl.php

<?php
class delete_ctrl extends CI_Controller{
function __construct(){
parent::__construct();
$this->load->model('delete_model');
}
// Function to Fetch selected record from database.
function show_student_id() {
$id = $this->uri->segment(3);
$data['students'] = $this->delete_model->show_students();
$data['single_student'] = $this->delete_model->show_student_id($id);
$this->load->view('delete_view', $data);
}
// Function to Delete selected record from database.
function delete_student_id() {
$id = $this->uri->segment(3);
$this->delete_model->delete_student_id($id);
$this->show_student_id();
}
}
?>

MODEL FILE: delete_model.php

<?php
class delete_model extends CI_Model{
// Function to select all from table name students.
function show_students(){
$query = $this->db->get('students');
$query_result = $query->result();
return $query_result;
}
// Function to select particular record from table name students.
function show_student_id($data){
$this->db->select('*');
$this->db->from('students');
$this->db->where('student_id', $data);
$query = $this->db->get();
$result = $query->result();
return $result;
}
// Function to Delete selected record from table name students.
function delete_student_id($id){
$this->db->where('student_id', $id);
$this->db->delete('students');
}
}
?>

My SQL Code Segment:

To create database and table, execute following codes in your My SQL .

CREATE DATABASE company;
CREATE TABLE employee(
employee_id int(10) NOT NULL AUTO_INCREMENT,
employee_name varchar(255) NOT NULL,
employee_email varchar(255) NOT NULL,
employee_contact varchar(255) NOT NULL,
employee_address varchar(255) NOT NULL,
PRIMARY KEY (employee_id)
)

CSS FILE: delete.css

#container{
width:960px;
height:610px;
margin:50px auto
}
#wrapper{
width:460px;
padding:0 50px 20px;
background:linear-gradient(#fff,#ABDBFF);
border:1px solid #ccc;
box-shadow:0 0 5px;
font-family:'Marcellus',serif;
float:left;
margin-top:10px
}
#menu{
float:left;
width:200px;
margin-top:-30px
}
#detail{
float:left;
width:220px;
padding:10px;
margin-top:-40px
}
a{
text-decoration:none;
color:blue
}
a:hover{
color:red
}
h1{
text-align:center;
font-size:28px
}
hr{
border:0;
border-bottom:1.5px solid #ccc;
margin-top:-10px;
margin-bottom:30px
}
button{
padding:6px 30px;
margin-top:10px;
font-size:14px;
background:linear-gradient(#fff,#828FEC);
border:2px solid #828FEC;
font-weight:700;
color:#8b008b
}
button:hover{
background:linear-gradient(#828FEC,#fff)
}
p{
font-size:18px;
font-weight:700;
color:#18af0b
}

Example :-

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 Constructor
parent::__construct();
//load database libray manually
$this->load->database();
//load Model
$this->load->model('Auth_model');
}
public function displaydata()
{
$result['data']=$this->Auth_model->display_records();
$this->load->view('display_records',$result);
} //Delete Record
public function deletedata()
{
$id=$this->input->get('id');
$this->Auth_model->deleterecords($id);
echo "Date deleted successfully !";
}
}
?>

Auth_model :-

<?php
class Auth_model extends CI_Model
{
//Display function display_records()
{ $query=$this->db->query("select * from crud");
return $query->result();
}
//Delete
function 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>

delete database record

File name : Controller.php

public function deletedata()
{
$id=$this->input->get('id');
$this->Auth_Model->deleterecords($id);
redirect("Controller/dispdata");
}

public function dispdata()
{
$result['data']=$this->Auth_Model->displayrecords();
$this->load->view('display_records',$result);
}

Model

File name : Auth_model.php

function deleterecords($id)
{
$this->db->query("delete from users where user_id='".$id."'");
}

function displayrecords()
{
$query=$this->db->query("select * from users");
return $query->result();
}

View

File name : view.php

<!DOCTYPE html>
<html>
<head>
<title>Display Records</title>
</head>

<body>
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr style="background:#CCC">
<th>Sr No</th>
<th>Name</th>
<th>Email</th>
<th>Mobile</th>
<th>Delete</th>
</tr>
<?php
$i=1;
foreach($data as $row)
{
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td>".$row->name."</td>";
echo "<td>".$row->email."</td>";
echo "<td>".$row->mobile."</td>";
echo "<td><a href='deletedata?id=".$row->user_id."'>Delete</a></td>";
echo "</tr>";
$i++;
}
?>
</table>
</body>
</html>

How to delete particular record from database.

File name : Controller.php

public function delteuser()
{
$id = $this->input->post('id');
$this->db->where('uid', $id);
$this->db->delete('user_info');
return;

}

OR

public function delteuser($id)
{

$this->db->where('uid', $id);
$this->db->delete('user_info');
return;

}

Itechtuto

Codeigniter Tutorials

How to Delete data from DB using codeigniter?

VIEW FILE: delete_view.php

CONTROLLER FILE: delete_ctrl.php

MODEL FILE: delete_model.php

CSS FILE: delete.css

Example :-

Crud.php :-

Auth_model :-

display_records.php :-

delete database record

File name : Controller.php

Model

File name : Auth_model.php

View

File name : view.php

How to delete particular record from database.

File name : Controller.php

Connect Us Socially:

Quick Links