Advertisement
Guest User

Untitled

a guest
Dec 3rd, 2016
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. <?php
  2.  
  3. $errmsg_arr = array();
  4. $errflag = false;
  5. // configuration
  6. $dbhost = "sql307.byethost31.com";
  7. $dbname = "b31_19211007_contact";
  8. $dbuser = "b31_19211007";
  9. $dbpass = "";
  10.  
  11. // database connection
  12. $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
  13.  
  14. // new data
  15.  
  16. $user = $_POST['uname'];
  17. $password = $_POST['pword'];
  18.  
  19. if($user == '') {
  20. $errmsg_arr[] = 'Vous devez entrer votre identifiant!!';
  21. $errflag = true;
  22. }
  23. if($password == '') {
  24. $errmsg_arr[] = 'Vous devez entrer votre mot de passe!!';
  25. $errflag = true;
  26. }
  27.  
  28. // query
  29. $result = $conn->prepare("SELECT * FROM users WHERE username= :identifiant AND password= :pass");
  30. $result->bindParam(':identifiant', $user);
  31. $result->bindParam(':pass', $password);
  32. $result->execute();
  33. $rows = $result->fetch(PDO::FETCH_NUM);
  34. if($rows > 0) {
  35. header("location: online.php");
  36. }
  37. else{
  38. $errmsg_arr[] = 'identifiant et mot de passe non trouvés';
  39. $errflag = true;
  40. }
  41. if($errflag) {
  42. $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  43. session_write_close();
  44. header("location: index.php");
  45. exit();
  46. }
  47.  
  48. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement