我的页面查看计数器在我的主页上增加了1个单位，但在次要页面上增加了3个单位

Im doing a function to count visitors, views and page_views.

For now Im just trying to count page views but Im having a strange issue.

I have a table stats with this columns: "users,visits,page_views".

And now I just want to increment my page_views when user acess some page.

Every time I acess my homepage my page_views is incremented 1 unit, but when I acess a secundary page my column page_views is incremented with 3 units, and I want just also 1 unit.

Do you know why this can be happening?

I think that problem is in my getHome() function, because If I call my function countViews() before or after my getHome(), I have different behaviors. But Im not finding why.

When I have me countViews() above my getHome(), It seems that Im calling 3 times my function countViews on my secundary pages.

But I only call my function countViews() on my index.php file and below this function I have my getHome() function where I do my navigation to all pages I have in my project.

function countViews(){
    $pdo = start();
    //if Im not logged as admin
    if(!isset($_SESSION['admin'])){
        //So at first I read my table stats, if my table dont have any row,
        // I create a row with my columns with value of '0'.
        $readStats= $pdo->prepare("SELECT * FROM stats"); 
        $readStats->execute();  

        if($readStats->rowCount()<1){
            $insStats= $pdo->prepare("INSERT INTO stats(users, views, page_views) VALUES (?,?,?)");
            $insStats->bindValue(1,'0');
            $insStats->bindValue(2,'0');
            $insStats->bindValue(3,'0');
            $insStats->execute();
        }
       //If my table stats already have one row, I want to increment page_views.  
        else{
            $resultStats= $readStats->fetch(PDO::FETCH_ASSOC);
            $incrementPageViews = $resultStats['page_views'] + 1;
            $updatePageViews =  $pdo->prepare("UPDATE stats set page_views = ?");
            $updatePageViews ->bindParam(1,$incrementPageViews);
            $updatePageViews ->execute();
        }

    }
}

My index.php is like:

<?php
  ob_start(); session_start();
  require_once('dts/db.php');
  $pdo = start();
  countViews();
 ?>
 <!DOCTYPE>
 <!-- here I have my css and js imports -->

<?php getHome(); ?>

My secundary pages:

<title>Untitled Document</title>
 </head> 
 <body>
 <!-- here I have my html -->
 </body>

getHome() function:

<?php
function getHome(){
    $url = $_GET['url'];
    $url = explode('/', $url);
    $url[0] = ($url[0] == NULL ? 'index' : $url[0]);

    if(file_exists('project/'.$url[0].'.php')){
        require_once('project/'.$url[0].'.php');
    }
    elseif(file_exists('project/'.$url[0].'/'.$url[1].'.php')){
        require_once('project/'.$url[0].'/'.$url[1].'.php');
    }
    else{
        require_once('project/404.php');
    }
}

?>

My table is like:

enter image description here

There're two possibilities I can think of.

  1. You have countViews in one of your require_once files
  2. You have some redirect code in your secondary pages.

What I'm actually saying is, I'm sure it's not magic.

I have no clue why this is happening but I can help you find.

Do the following inside your countViews():

echo "<pre>";
var_dump("Count Views beeing called from : ".__FILE__);
echo "</pre>";

If you still cannot find why using this, tell me and I will help you setup xdebug and profiling which will tell you exactly the files included and the functions called in the order they were called/included.

Like this: http://4.bp.blogspot.com/-BGYXo-b-bj8/TvIjJd0pBXI/AAAAAAAAF_0/ZssGFW9Rb7Y/s1600/drupal-6-cacherouter-memcache-fail.png

What you can do is changing your function into simpler one and check if this problem still occurs.

function countViews(){
    $pdo = start();
    //if Im not logged as admin
    if(!isset($_SESSION['admin'])){
        //So at first I read my table stats, if my table dont have any row,
        // I create a row with my columns with value of '0'.
        $sth= $pdo->query("SELECT * FROM stats LIMIT 1"); 
        $result = $sth->fetchAll(PDO::FETCH_ASSOC);

        if(!$result){
            $pdo->exec("INSERT INTO stats(users, views, page_views) VALUES (0,0,0)");

        }
       //If my table stats already have one row, I want to increment page_views.  
        else{
            $pdo->exec("UPDATE stats set page_views = page_views + 1");

        }

    }
}

If it still doesn't work you should show us what data you have in your stats table.

You route all 404 requests to index.php . It seems you have 2 missed resource on secondary pages. Try to modify countViews() function as below:

function countViews(){
    $tmp = $_SERVER["REQUEST_URI"]; // huge logging: $tmp = print_r($_SERVER, 1);
    file_put_contents($_SERVER['DOCUMENT_ROOT'].'/viewslog.txt', $tmp, FILE_APPEND | LOCK_EX );

    $pdo = start();

I would start looking at your server's log, it could tell you wich files are being requested, it seems like some files are being requested more than once.