Labels

php (35) javascript (31) phpjavascript (30) jquery (23) html (20) mysql (14) database (9) codeigniter (4) json (4) bar chart (2) calendar (2) column chart (2) framework (2) google maps (2) query (2) tables (2) url (2) dropdown (1)

Monday, February 5, 2018

How to delete data in a table using CodeIgniter?

This block of code of will explains about how to delete data from table using CodeIgniter.
Which involves mainly three steps.
  1. View
  2. Controller
  3. Model

View
demodata.php
<html>
<head>
    <style>
        .container {
width: 500px;
height: 100px;
padding: 200px;
        }
table, th, td {
border: 1px solid black;
width:500px;
        }
    </style>
</head>
<body class="container">
<table>
    <tr>
        <th>ID</th>
        <th>Name</th>
        <th>Number</th>
        <th>Update</th>
    </tr>

<?php
    foreach ($k->result() as $row) {
echo '<tr>';
echo '<td>' . $row->id . '</td>';
echo '<td>' . $row->name . '</td>';
echo '<td>' . $row->number . '</td>';
echo "<td><a href='updatedemodata?id=$row->id'>Update</a>
        <a href='deletedemodata?id=$row->id'> / Delete</a></td>";
    }
?>

</table>
</body>
</html>

Controller
Welcome.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Welcome extends CI_Controller {
public function deletedemodata(){
if(isset($_GET['id'])) {
if (($_GET['id'] !== '')) {
$id = $_GET['id'];
$this->levels->deletedemodata($id);
            } else {
echo 'error while deleting';
            }
        }
    }
}
?>

Model
level.php
<?php
class Levels extends CI_Model
{
public function deletedemodata($id)
    {
$this->load->database();
$this->db->where('id', $id);
$this->db->delete('demo');
echo 'Data Deleted successfully';
$this->load->helper('url');
        redirect('/welcome/demodata');
    }
}
?>



1 comment:

  1. Led High Bay Lights I actually take care of such information a lot. I'm interested in this specific info for just a while. Appreciate it and also all the best .

    ReplyDelete

More Posts

FOLLOW