nbHit + 1;
mysql_query("update compteurs set nbHit = $cpt where cle = '$cle'");
}
mysql_free_result($result);
}
// --------------------------------
function getCompteurs($cle) {
$result = mysql_query("select * from compteurs where cle = '$cle'");
$row = mysql_fetch_object($result);
if ($row)
$cpt = $row->nbHit;
else
$cpt = 0;
mysql_free_result($result);
return $cpt;
}
// --------------------------------
function getNom($cle) {
$result = mysql_query("select * from compteurs where cle = '$cle'");
$row = mysql_fetch_object($result);
if ($row)
$res = $row->nomComplet;
else
$res = "";
mysql_free_result($result);
return $res;
}
// --------------------------------
function getTotalHitsCompteurs() {
$result = mysql_query("select sum(nbHit) as total from compteurs");
$row = mysql_fetch_object($result);
if ($row)
$total = $row->total;
else
$total = 0;
mysql_free_result($result);
return $total;
}
// --------------------------------
function getNbVisiteurs() {
$result = mysql_query("select count(*) as res from visiteurs");
$row = mysql_fetch_object($result);
if ($row) {
$res = $row->res;
if ($res == 0) $res = 1;
} else {
$res = 1;
}
mysql_free_result($result);
return $res;
}
// ------------------------------------
function updateNbVisiteurs() {
$ip = getenv("REMOTE_HOST");
if (!$ip) {
$ip = getenv("REMOTE_ADDR");
}
mysql_query("delete from visiteurs where limite < now()");
$result = mysql_query("select * from visiteurs where ip = '$ip'");
$row = mysql_fetch_object($result);
if ($row) {
$query = "update visiteurs set limite = now() + 300 where ip = '$ip'";
mysql_query($query);
} else {
$query = "insert into visiteurs (ip, limite) values ('$ip', now() + 300)";
mysql_query($query);
}
mysql_free_result($result);
}
?>