Question

以下两条线路在发表评论后更新了数据库,删除了<代码>comment_ Total-1。如果<代码>comment_ Total,就会出现错误情况是零,因为我们可以从零起把1级从零敲碎打。只有<代码>comment_ Total更大,然后0,否则就将其细分为0。

$query = $this->EE->db->query("SELECT comment_total FROM exp_channel_titles WHERE entry_id =  $entry_id ");
$this->EE->db->query("UPDATE exp_channel_titles set comment_total =  ".($query->row( comment_total ) - 1)."  WHERE entry_id =  $entry_id ");

Answer 1

You can do this entirely on the database side using a single query

UPDATE exp_channel_titles SET comment_total = GREATEST(comment_total - 1, 0)
WHERE entry_id = ?

Answer 2

引证。我增加了<代码>max功能:

$query = $this->EE->db->query("SELECT comment_total FROM exp_channel_titles WHERE entry_id =  $entry_id ");
$this->EE->db->query("UPDATE exp_channel_titles set comment_total =  ".max(0,$query->row( comment_total ) - 1)."  WHERE entry_id =  $entry_id ");

Documentation for max can be found here: http://www.php.net/manual/en/function.max.php

Answer 3

正在确定总评值的标值。

if ($query->row( comment_total ) > 0) {
    $this->EE->db->query("UPDATE exp_channel_titles set comment_total = ".($query->row( comment_total ) - 1)." WHERE entry_id =  $entry_id ");
}

友情链接