Guest User

Untitled

a guest
Jan 31st, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. require_once('conf_db.php');
  2.  
  3. class BaseDatos{
  4.  
  5. protected $con;
  6. protected $db;
  7. protected $registro;
  8.  
  9. public function conectar() {
  10. $this->con = mysqli_connect(HOST, USER, PASS, DBNAME);
  11. if ($this->con == '0') DIE("Lo sentimos, no se ha podido conectar con MySQL: ".mysqli_error());
  12. //$this->db = mysqli_select_db(DBNAME, $this->con);
  13. if (DBNAME == '0') DIE("Lo sentimos, no se ha podido conectar con la base datos: ".DBNAME);
  14. return true;
  15. }
  16. public function desconectar() {
  17. if ($this->conectar->con) {
  18. mysqli_close($this->$con);
  19. }
  20. }
  21.  
  22. public function consulta(){
  23. $sentencia = 'SELECT * FROM Usuarios';
  24. $result = mysqli_query($this->con, $sentencia);
  25.  
  26. while ($fila = mysqli_fetch_assoc($result)) {
  27. $registro[] = $fila;
  28. }
  29. }
  30. }
  31. ?>
  32.  
  33. <?php
  34.  
  35. include('../include/conexion.php');
  36. $db = new BaseDatos();
  37. $db->conectar();
  38. $db->consulta();
  39.  
  40. if($db->conectar()){
  41. //Datos recogidos de login.php
  42. $user = $_POST['usuario'];
  43. $pass = $_POST['contrasena'];
  44. //Para una mayor seguridad pasamos la contraseña a un hash
  45. $hash = password_hash($_POST["contrasena"], PASSWORD_DEFAULT);
  46.  
  47. foreach ($registro as $registros) {
  48. $pass_bd = $registros['contrasena'];
  49. $user_bd = $registros['usuario'];
  50. if (($user_bd = $user) AND (password_verify($pass_bd,$hash))) {
  51. session_start();
  52. $_SESSION['logueado']=TRUE;
  53. header('Location: control.php');
  54. }
  55. else{
  56. header('Location: login.php');
  57. echo "Error";
  58. }
  59. }
  60. }
  61. ?>
Add Comment
Please, Sign In to add comment