Guest User

Untitled

a guest
Feb 2nd, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. if (isset($_POST['entrar'])) {
  2. require "functions.php";
  3. $error = [];
  4. $user = ValidUser($error);
  5. if(empty($error)){
  6. logearUsuario($user);
  7. header("Location: application.php");
  8. }
  9. }
  10.  
  11. try{
  12.  
  13. $dsn = 'mysql:host=localhost; dbname=controlusuarios';
  14. $userBBDD = 'root';
  15. $passBBDD = '';
  16. $conn = new PDO($dsn, $userBBDD, $passBBDD);
  17. return $conn;
  18.  
  19. }catch(Exception $e){
  20.  
  21. die('Error: ' . $e->GetMessage());
  22.  
  23. }
  24.  
  25. if((!isset($_POST['user'])) || (!isset($_POST['pass']))){
  26. $error[0] = "Usuario y/o contraseña incorrectos.";
  27. return null;
  28. }
  29. $user = $_POST['user'];
  30. $pass = $_POST['pass'];
  31. if(($user == '') || ($pass == '')){
  32. $error[0] = "Usuario y/o contraseña incorrectos.";
  33. return null;
  34. }else{
  35.  
  36. $con = connection();
  37. $sql = "SELECT name FROM usuarios WHERE name = :user AND password = :pass";
  38. $query = $con->prepare($sql);
  39. $query-> bindParam(':user', $user);
  40. $query-> bindParam(':pass', $pass);
  41. $query-> execute();
  42. $contador = $query -> rowCount();
  43. if($contador != 1){
  44. $error[0] = "Usuario y/o contraseña incorrectos.";
  45. return null;
  46. }
  47. $con = null;
  48. return $user;
  49. }
  50.  
  51. session_start();
  52. $_SESSION['name'] = $user;
Add Comment
Please, Sign In to add comment