Codeigniter delete row from db

Question

Just want to delete row from db table by passing id. Please help me to pass id from the view correctly. Any help will be highly appreciated. Please let me know if any detailed information is needed so that I can provide it.

Here is my Model:

public function did_delete_row($user_id){ 

$query = $this->db->get_where('users',array('user_id' => $user_id));

    if ($query->num_rows() == 1) {

    if ($this->db->delete('users',array('user_id','email','name','city'))) 

        {return true;}

        else

        {return false;}
    } else {return false;}

                }

Here is My view:

<a href="<?php echo site_url('admin/delete_row/'.$user_id);?">Delete</a>

Here is My controller:

  public function delete_row($user_id) {

        $this->load->model("model_admin");
        $this->model_admin->did_delete_row($user_id);

        }

You can append the query string to your URL. Like: /delete_row?id=1. Then you can retrieve the id using $this->input->get('id'); — Rahil Wazir
– Rahil Wazir, Commented Apr 15, 2014 at 18:08
The delete accepts second parameter as associative array (WHERE clause). You need $this->db->delete('users',array('user_id' => $this->input->get('user_id'))). Also you have semi colon ; in your get_where clause — Rahil Wazir
– Rahil Wazir, Commented Apr 15, 2014 at 18:22

Teocci · Accepted Answer · 2019-05-24 12:51:55Z

28

In Your HTML.... you should pass the user_id_to_delete like this:

<a href="<?php echo site_url('admin/delete_row/'.$user_id_to_delete);?>">Delete</a>

Now, in the Controller you should receive the user_id_to_delete variable into the user_id when it gets to the delete_row() method. Now, you can send it as a HTTP post transaction.

public function delete_row($user_id) {   
    $this->load->model("model_admin");
    $this->model_admin->did_delete_row($user_id);
}

For the model you will get the user_id to delete. Here is the function for your admin model

public function did_delete_row($id){
    $this -> db -> where('user_id', $id);
    $this -> db -> delete('users');
}

Finally, update the delete URL line as follows:

<td><a href="<?php echo site_url('admin/delete_row/'.$user['user_id']);?">Delete</a></td>

That Should work for you

edited May 24, 2019 at 12:51

Teocci

9,3751 gold badge71 silver badges56 bronze badges

answered Apr 15, 2014 at 18:20

Fisherman

6,1311 gold badge33 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

NiceTry Over a year ago

I changed my code as per your advice but it generates errors for controller code. I guess something is wrong with my view. I don't know if I pass id correctly.

Fisherman Over a year ago

give your view and controller code for generating the view

NiceTry Over a year ago

I have just edited my question and added view and controller code for generating the view. Please have a look at it.

score 2 · Accepted Answer · 2020-07-07 22:56:06Z

2

Codeigniter 3:

Use - $this->db->delete()

$this->db->delete('mytable', array('id' => $id));  // Produces: DELETE FROM mytable WHERE id = $id

OR - Delete from multiple tables:

$tables = array('table1', 'table2', 'table3');
$this->db->where('id', '5');
$this->db->delete($tables);

https://www.codeigniter.com/userguide3/database/query_builder.html

edited Jul 7, 2020 at 22:56

answered Apr 3, 2018 at 21:55

user8588978

Collectives™ on Stack Overflow

Codeigniter delete row from db

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related