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 使用微信开发者工具实现一个“婚博会”小程序
  • ¥15 ros的rviz仿真机器人
  • ¥15 关于#linux#的问题(输入输出错误):出现这个界面接着我重新装系统,又让修电脑的师傅帮我扫描硬盘(没有问题)用着用着又卡死(相关搜索:固态硬盘)
  • ¥15 cv::resize不同线程时间不同
  • ¥15 web课程,怎么做啊😭没好好听课 根本不知道怎么下手
  • ¥15 做一个关于单片机的比较难的代码,然后搞一个PPT进行解释
  • ¥15 python提取.csv文件中的链接会经常出现爬取失败
  • ¥15 数据结构中的数组地址问题
  • ¥15 maya的mel里,怎样先选择模型A,然后利用mel脚本自动选择有相同名字的模型B呢。
  • ¥15 Python题,根本不会啊