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
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;
}
}