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条)

报告相同问题？

悬赏问题

  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测，loss值优化，参数优化算法
  • ¥15 基于卷积神经网络的声纹识别
  • ¥15 Python中的request，如何使用ssr节点，通过代理requests网页。本人在泰国，需要用大陆ip才能玩网页游戏，合法合规。
  • ¥100 为什么这个恒流源电路不能恒流？
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson，入参实体类Person，出参布尔值
  • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题，上传的坐标文件里是怎么对无序点进行编号的，以及xy坐标在处理的时候是进行整体模型分片处理的吗
  • ¥15 一直显示正在等待HID—ISP
  • ¥15 Python turtle 画图