Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function dbConnect(){
- try
- {
- $db = new PDO('mysql:host=localhost;dbname=armada;charset=utf8', 'root', '');
- return $db;
- }
- catch(Exception $e)
- {
- die('Erreur : '.$e->getMessage());
- }
- }
- function checkUserPresence($mail){
- $presenceUser = false;
- $db = dbConnect();
- $request = $db->prepare('SELECT mail FROM user WHERE mail = ?');
- $request->execute(array($mail));
- while ( $request->fetch() )
- {
- $presenceUser = true;
- }
- $request->closeCursor();
- return $presenceUser;
- }
- function addUser($mail, $password, $fName, $sName){
- $db = dbConnect();
- $request = $db->prepare("INSERT INTO user VALUES(0, :mail , :nom , :prenom , :passwordd ,null )");
- $request->execute(array(
- 'mail' => $mail,
- 'nom' => $sName,
- 'prenom' => $fName,
- 'passwordd' => password_hash($password, PASSWORD_DEFAULT),
- ));
- $request->closeCursor();
- }
- function checkLogin($mail, $password, $passwordIsHashed){
- $connexion = false;
- $db = dbConnect();
- $request = $db->prepare('SELECT password FROM user WHERE mail = ?');
- $request->execute(array($mail));
- if ( $data = $request->fetch() )
- {
- if($passwordIsHashed){
- if( $password == $data['password'] ){
- $connexion = true;
- setSessionInformation($mail);
- }
- }
- else{
- if( password_verify($password, $data['password']) ){
- $connexion = true;
- setSessionInformation($mail);
- }
- }
- }
- $request->closeCursor();
- return $connexion;
- }
- function setSessionInformation($mail){
- $db = dbConnect();
- $request = $db->prepare('SELECT * FROM user WHERE mail = ?');
- $request->execute(array($mail));
- $data = $request->fetch();
- $_SESSION['id']=$data['id'];
- $_SESSION['mail']=$data['mail'];
- $_SESSION['name']=$data['nom'];
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement