$sql = BaseDonnee::execQuery($bdd, "SELECT * FROM Users WHERE Username = '******'");
if (!empty($sql)) {
if ($sql[0]["Actif"] != "1") {
$success = false;
}
}
} catch (PDOEXception $e) {
echo $e->getMessage();
// display bdd error
exit;
}
if ($success) {
//Si la connexion à réussie
if (isset($_SESSION["erreur_login"])) {
unset($_SESSION["erreur_login"]);
}
$_SESSION["pseudo"] = $pseudo;
// On connecte l'user
$_SESSION["token"] = time();
$ip_client = getenv('HTTP_CLIENT_IP') ?: getenv('HTTP_X_FORWARDED_FOR') ?: getenv('HTTP_X_FORWARDED') ?: getenv('HTTP_FORWARDED_FOR') ?: getenv('HTTP_FORWARDED') ?: getenv('REMOTE_ADDR');
BaseDonnee::updateLastSignIn($bdd, $pseudo, $ip_client);
header("Location: ../index.php");
//Redirection vers l'accueil
exit;
} else {
//Echec de la connexion
$_SESSION["erreur_login"] = "******";
header("Location: ./login.php");
//Redirection vers la page de login
exit;
}
