How to update a column once per page viewed?

Question

I’m trying to create a hit counter, this code updates my column 1 time per session, but what I want is to update my column whenever the user views a new page.

if(!isset($_SESSION))session_start();

if(empty($_SESSION['counter'])){    
$_SESSION['counter'] = 1;
$mread = $conn->prepare("UPDATE table SET counter = counter + 1 WHERE id = :id");
$mread->bindParam(':id', $id, PDO::PARAM_INT);
$mread->execute();
};

If I only use the query UPDATE It will update my column whenever I reload the page, and that’s not what I want. I want you to update my column whenever the user views a new page.

How do I do that?

Answer 1

Put the name of each page in a variable, e.g.:

page1.php $nomePagina="pagina1";

page2.php $nomePagina="pagina2";

page code1.php

if(!isset($_SESSION))session_start();

    $nomePagina="pagina1";

    if(empty($_SESSION[$nomePagina])){

      ..........
      ..........


      $_SESSION[$nomePagina] = 1;

      //UPDATE

   };