如何对0个受影响的行返回false - mysqli - How to return false on 0 affected rows

mysqli - How to return false on 0 affected rows

本文关键字：返回 false 影响 0个 | 更新日期: 2023-09-27

即使未删除项，deleteItem方法也返回true。在这种特殊情况下，如果数据库没有变化，如何使用$mysqli->affected_rows来检查并返回false ?

public function deleteItem($item_id)
{
    $userItemIDS = array();
    $userItemIDS = $this->helperClass->userItemIDS();
    $q = $this->db->mysqli->prepare("DELETE i, s FROM items i
    LEFT JOIN save_list s
        ON i.id = s.item_id
        WHERE i.id = ? AND s.item_id = ?
    AND
        NOT EXISTS (SELECT id FROM pending_wins WHERE item_id = ?)
    AND
        NOT EXISTS (SELECT id FROM bids WHERE 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;
}

必须如此

public function deleteItem($item_id)
{
    $userItemIDS = $this->helperClass->userItemIDS();
    if( !in_array($item_id, $userItemIDS) )
    {
        return FALSE;
    }
    $sql = "...";
    $q = $this->db->mysqli->prepare($sql);
    $q->bind_param("iiii", $item_id, $item_id, $item_id, $item_id);
    $q->execute();
    return (bool)$this->db->mysqli->affected_rows;
}

根据注释请求，伪代码:

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