php - 使用 id 数组更新和删除多行

Question

我不想检查用户团队发布的挑战是否在 1 天后没有被排除，然后自动退还用户团队的积分，然后删除所有挑战。到目前为止，这是我的代码。

//Delete all matches not accepted after 1 day
$arrayin = array();
$autorefund = mysql_query("SELECT * FROM `challenges` WHERE `a` = " . $team['id'] . " "
        . "AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < " . ((int) time()) . ")");
if (mysql_num_rows($autorefund) > 0) {
    while ($autorefund = mysql_fetch_assoc($autorefund)) {
        $arrayin[] = $autorefund['id'];
        mysql_query("UPDATE `teams` SET `balance` =  `balance` + " . $autorefund['credits'] . " "
                . "WHERE `id` IN (" . mysql_real_escape_string(implode(',', $arrayin)) . ")");
        mysql_query("DELETE FROM `challenges` WHERE `a` IN "
                . "(" . mysql_real_escape_string(implode(',', $arrayin)) . ") "
                . "AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 "
                . "AND (`expires` < " . ((int) time()) . ")");
    }
}

Answer 1

你需要发布 MySQL 更新，删除循环之外的条件。

您已经在循环中获取 ID。

所以，最终的代码应该是:

 //Delete all matches not accepted after 1 day
    $arrayin              = array();
    $autorefund   = mysql_query("SELECT * FROM `challenges` WHERE `a` = " . $team['id'] . " AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < ".((int)time()).")");
    if (mysql_num_rows($autorefund) > 0) {
        while ($autorefund  = mysql_fetch_assoc($autorefund)) {
             $arrayin[] = $autorefund['id'];
        }
    }
mysql_query("UPDATE `teams` SET `balance` =  `balance` + " . $autorefund['credits'] . " WHERE `id` IN (" . mysql_real_escape_string(implode(',', $arrayin)) . ")");
mysql_query("DELETE FROM `challenges` WHERE `a` IN (" . mysql_real_escape_string(implode(',', $arrayin)) . ") AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < ".((int)time()).")");

不要使用 mysql_ 函数，因为它们已被弃用，并将在未来的 PHP 版本中删除。