doucong8553 2016-04-11 08:17
浏览 37
已采纳

在php中获取视图计数

I have code like this for count view after visit my page.
But this code add two not one.
web.php file:

$host="localhost";
$user="root";
$password="";
$dbname="test";
$coms_conect = new mysqli($host, $user, $password, $dbname);
mysqli_set_charset($coms_conect,"utf8");
$coms_conect->query("update news set view=view+1 where id=244");

For example befor execute code view is 20 after execute in 22. This is .htaccess file

<IFMODULE mod_rewrite.c>
  RewriteEngine On
  RewriteCond %{REQUEST_FILENAME}       !-f
  RewriteCond %{REQUEST_FILENAME}       !-d
 RewriteRule ^(.*) web.php


php_flag register_globals off
php_value session.auto_start 0 
php_value session.use_only_cookies 1 
php_value session.use_trans_sid 0
  • 写回答

2条回答 默认 最新

  • duanliao3826 2016-04-11 08:42
    关注

    This is a very common problem. What happens is that the script is getting executed twice. The reason for that is because the browser tries to get a .ico file from the server. And from what i am guessing you have some kind of routing in php. Have a look at access logs of the server and you will know the reason.I am pretty sure that is the problem.

    Edit

    Not the best solution This is specific to condition if you want to edit your web.php file. Although there are better alternatives.

    /* This will only tract /home,/ and /temp url.
   You can edit them on your own
*/
$allowed_hosts = array("/home","/","/temp");
if(in_array($_SERVER['REQUEST_URI'], $allowed_hosts)
{
    //execute sql query here
}

    Alternatively better solution

    What i was saying by views is. Where you have written you html tag as in

    <?php
    ....
    //You can add sql here and it wont run twice
?>
<html>
    ....
</html>

    Try this:

    if($_SERVER['REQUEST_URI']!="/favicon.ico")
$coms_conect->query("update new_ads set view=view+1 where id=1");
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 执行 virtuoso 命令后，界面没有，cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料