php - mysqli - How to return false on 0 affected rows -


the deleteitem method returns true if item isn't deleted. how can $mysqli->affected_rows used in particular case check , return false if there no changes database?

public function deleteitem($item_id) {     $useritemids = array();      $useritemids = $this->helperclass->useritemids();      $q = $this->db->mysqli->prepare("delete i, s items     left join save_list s         on i.id = s.item_id         i.id = ? , s.item_id = ?     ,         not exists (select id pending_wins item_id = ?)     ,         not exists (select id bids item_id = ?)");      if( $q != false && in_array($item_id, $useritemids) )     {         $q->bind_param("iiii", $item_id, $item_id, $item_id, $item_id);         $q->execute();         $q->close();         return true;     }         return false; } 

as per comment request, pseudo-ish code:

if (ok run query) {    $q = "...build/prepare/bind query...";    if ($q->execute() === false) {        return false; // query failed    } else {        return $q->rowcount(); // return number of rows affected    } } 

Comments