Am Programming with My Android Phone (Palapa Web Server)
我想在每次加载单个帖子时获得准确的帖子浏览量计数,但是我已经尝试使用以下代码,当我加载或查看带有代码的帖子时,它会计数,但在数据库中它会在准确计数上添加额外的一个。
(例如,最后一个计数是"20",但是当我重新加载帖子时,它将在数据库中显示"22")。
这是代码:
<?php
// Set queries
$q ="SELECT views FROM chaly_post WHERE id ='$post_id' LIMIT 1";
$r=@mysqli_query($connect,$q);
while ($row=mysqli_fetch_assoc($r)){
echo $views=$row['views'];
}
if ($views){
$f ="UPDATE chaly_post SET views=(views+1) WHERE id=$post_id";
$s = @mysqli_query($connect,$f);
}
?>
更改:
$f ="UPDATE chaly_post SET views=(views+1) WHERE id=$post_id";
自
$views = $views + 1;
$f ="UPDATE chaly_post SET views='{$views}' WHERE id=$post_id";
删除此处的 @:
$r=@mysqli_query($connect,$q);
在这里:
$s = @mysqli_query($connect,$f);