<?php
$Host = "localhost"; //Host name
$User = "root"; // Username
$Mdp = "alvan"; // Password
$Base = "test"; // Database Name
mysql_connect ( $Host , $User , $Mdp );
//Timeout in seconds
$TimeOut = 60;
$ip = getenv( "REMOTE_ADDR" );
$Requete = "DELETE FROM online_count WHERE TMP < now()";
$Resultat = mysql_db_query( $Base , $Requete );
$Requete = "SELECT count(*) FROM online_count WHERE ip='$ip'";
$Resultat = mysql_db_query( $Base , $Requete );
while ( $T = @mysql_fetch_array( $Resultat ) ) {
$Compteur = $T["count(*)"];
}
if ( $Compteur ) {
$Requete = "UPDATE online_count SET TMP=TMP + $TimeOut WHERE ip='$ip'";
} else {
$Requete = "INSERT INTO online_count (ip, TMP) VALUES ('$ip', now()+ $TimeOut)";
}
$Envoi = mysql_db_query( $Base , $Requete );
$Requete = "SELECT count(*) FROM online_count";
$Envoi = mysql_db_query( $Base , $Requete );
while ( $T = @mysql_fetch_array( $Envoi ) ) {
$Compteur = $T["count(*)"];
}
echo $Compteur;
?>