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"); }