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
Post a Comment