function insertLogtoBDD()
{
include "connect.inc.php";
/* Récupération date est heure */
$date = date("d-m-Y");
$heure = date("H:i");
$connect_time = $date . " " . $heure;
/* Récupération session */
if (isset($_SESSION['id_user']) && !empty($_SESSION['id_user'])) {
$id_user = $_SESSION['id_user'];
//ok
} else {
$id_user = 0;
}
if (isset($_SESSION['email']) && !empty($_SESSION['email'])) {
$email = $_SESSION['email'];
//ok
} else {
$email = 'unknow';
}
/* Récupération ip */
$ip = $_SERVER["REMOTE_ADDR"];
/* Récupération url */
$lien = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$bool = sessionValid();
/* Récupération info navigateur */
$browser = $_SERVER['HTTP_USER_AGENT'];
//echo "---->".$browser;
/* Récuperation avant derniere url */
$dernierlien = $_SERVER['REQUEST_URI'];
if ($bool == 0) {
try {
$requete_prepare = $bdd->prepare("INSERT INTO log(connect_time,ip,lien,dernierlien,browser) VALUES('{$connect_time}', '{$ip}', '{$lien}', '{$dernierlien}', '{$browser}')");
// on prépare notre requête
$requete_prepare->execute();
echo "->OK sans session";
} catch (Exception $e) {
//echo $e->errorMessage();
echo "->erreur";
}
} else {
try {
$requete_prepare = $bdd->prepare("INSERT INTO log(id_user,connect_time,email,ip,lien,dernierlien,browser) VALUES('{$id_user}', '{$connect_time}', '{$email}', '{$ip}', '{$lien}', '{$dernierlien}', '{$browser}')");
// on prépare notre requête
$requete_prepare->execute();
echo "->OK avec session";
} catch (Exception $e) {
//echo $e->errorMessage();
echo "->erreur";
}
}
}
$valPwd = $_POST['newPassword'];
$valPwd = md5($valPwd);
$id = $_SESSION['id_user'];
try {
$requete_prepare = $bdd->prepare("UPDATE user SET password='******' WHERE id_user='******'");
// on prépare notre requête
$requete_prepare->execute();
echo "->OK pwd update";
} catch (Exception $e) {
echo $e->errorMessage();
echo "->erreur";
}
}
//Valide que le formulaire
$verif = formValid();
$verifSession = sessionValid();
if ($verifSession == 1) {
if ($verif == 1) {
$verifId = verifId();
if ($verifId == 0) {
echo "->id n'existe pas";
header("location: ../profil?erreur=Erreur mdp");
} else {
if ($verifId == 1) {
echo "->mdp ne corresponde pas";
header("location: ../profil?erreur=mdp non identique");
} else {
if ($verif == 1) {
updateIdResetPwd();
header("location: ../profil?ok=success");
}
