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

报告相同问题？