在codeigniter中注销时删除令牌

Question

I am assigning the user_id to my session as soon as the user logs in, and I am giving a token to the user when he logs in, and I am storing it in the database just to keep the record. Now, I want to delete that token when the user clicks logout and for that,

view

<a href=" <?php base_url('user/logout') ?> ">logout</a>

controller

public function logout(){

$uid = $this->session->userdata('user_id');
$this->load->model('loginmodel');
$lid = $this->loginmodel->deltoken($uid);

if($lid){

  $this->session->unset_userdata('user_id');

  return redirect(user);

}else {
  echo "fail";
}
}

model

public function deltoken($uid)
{
    $query = $this->db->query("DELETE FROM user_auth WHERE id = '$uid'");
    return TRUE;
}

but in the database record belonging to that particular id is not getting deleted. what am i doing wrong here? Thank you for your suggestions

Answer 1

Hope this will help you :

You are missing echo in your link, should be like this :

<a href=" <?php echo site_url('user/logout') ?> ">logout</a>

Your model deltoken method should be like this :

public function deltoken($uid)
{
    $uid  = ! empty($uid) ? $uid : $this->session->user_data('user_id');
    $this->db->where('id' ,$uid);
    $this->db->delete('user_auth');
    if ( $this->db->affected_rows() )
    {
      return TRUE;
    }
    else
    {
      return FALSE;
    } 
}