About Lesson
A delete() method is used to delete data from the database.
Syntax:
$this->db->table('table_name')->where('condition')->delete();
1. Copy and Paste the following lines in app/Config/Routes.php
$routes->add('user/list', 'User::list'); $routes->get('user/delete/(:num)', 'User::delete/$1');
2. Create a list.php file in the app/Views/ directory
<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> </tr> <?php $i=1; foreach($result 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="<?php echo base_url('user/delete'.$row->id) ?>">Delete</a></td>"; echo "</tr>"; $i++; } ?> </table>
3. Create a model file UserModel.php in the app/Models/ directory.
<?php namespace AppModels; use CodeIgniterModel; use CodeIgniterDatabaseConnectionInterface; class UserModel extends Model { protected $db; public function __construct(ConnectionInterface &$db) { $this->db =& $db; } public function list() { return $this->db ->table('user_info') ->get() ->getResult(); } public function delete($id) { return $this->db ->table('user_info') ->where(["id" => $id]) ->delete(); } }
4. Create a controller file User.php in the app/Controllers/ directory.
<?php namespace AppControllers; use AppModelsUserModel; class User extends BaseController { public function __construct() { $db = db_connect(); $this->userModel = new UserModel($db); } public function add() { $this->load->view('add'); } public function list() { $data['result'] = $this->userModel->list(); echo view('list', $data); } public function delete($id) { $result = $this->userModel->delete($id); if($result) { echo "User record is deleted successfully."; } else { echo "Something went wrong"; } } }