如何定义客户端访问网站的时间

Question

I have a site and I want to measure how long a client was connected to my site, one hour or two hour... or? how is it possible? can someone help me in this regard. it will be appreciated.

Answer 1

As mentioned in the comments, it's best to use analytic software but if you are looking for something simple (or just learning experience)

<?php

session_start();

if(!isset($_SESSION['sessionId'])) // No session, first time (subject to session timeout)
{
    mysqli_query("INSERT INTO visitor_sessions(`started_on`, `last_checkin`) (" . time() . ", " . time() .")");
$_SESSION['sessionId'] = mysqli_insert_id();    // start the 'visiting session'
 }
else
{
    mysqli_query("UPDATE  visitor set `last_checkin` = " . time() . " WHERE id = " .$_SESSION['sessionId']); // Update last checkin
}

?>

visitor_sessions is a table with 3 columns, id, started_on and last_checkin (timestamps).

You can include this script in your pages thus updating last check_in with each new page opened or have jquery call it every x seconds to maintain time even if they just view a page.

PS: Code was not tested but this is the general idea