remyremy remyremy - 6 months ago 33
MySQL Question

num_rows on delete query codeigniter

I'm trying to find a way to validate that my Delete query was successful. How can I get num_rows or affected_rows from the following structure:

public function fire_db($currentUserID, $id_staff){
$this->db->where('id_player', $currentUserID);
$this->db->where('id_hired_staff', $id_staff);
$this->db->limit(1);
$this->db->delete('game_hired_staff');
if ($this->db->num_rows() == 1) {
return true;
}
else
return false;
}


Using codeigniter 3

Answer

to test result of delete query use

$this->db->affected_rows();
Comments