1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| <?php
//Connexion à la base de données
$db = mysql_connect($cnxhost, $cnxuser, $cnxpass) or die ("Erreur de connexion");
$sql = $_SESSION['USER_NOM'];
$ip = $_SERVER['REMOTE_ADDR'];
$dat = date("y/m/d");
$date = date("y/m/d G.i:s", time());
$nb_connectes = $sql;
$recupip = $ip;
$recupdate = $date;
$sql1 = "SELECT * FROM connectes WHERE user_nom='$sql' ORDER BY Date DESC LIMIT 1";
$query = mysql_query($sql1) or die(mysql_error());
if (mysql_num_rows($query) == 0)
{
$sql2 = "INSERT INTO connectes (user_nom,DateConnect,Date,nbre_fois,Ip) VALUES ('$nb_connectes','$recupdate','$dat',nbre_fois+1,'$recupip')";
$query1 = mysql_query($sql2) or die(mysql_error());
}
if (mysql_num_rows($query) >= 1)
{
if (mysql_result($query, 0,"Date") == $dat)
{
$sql3 = "UPDATE connectes SET DateConnect='$date', nbre_fois+1 WHERE user_nom='$sql'";
$query2 = mysql_query($sql3) or die(mysql_error());
}
else
{
$sql4 = "INSERT INTO connectes (user_nom,DateConnect,Date,nbre_fois,Ip) VALUES ('$nb_connectes','$recupdate','$dat',nbre_fois+1,'$recupip')";
$query3 = mysql_query($sql4) or die(mysql_error());
}
}
mysql_close($db);
?> |
Partager