<?php

class conexion{

private $conexion;
private $host = "localhost";
private $usu = "root";
private $pass = "";
private $db = "gimnasio";

public function __construct(){

    $this->conexion = new mysqli($this->host, $this->usu, $this->pass,
 $this->db);

    if($this->conexion->connect_errno){
        die("error no se conecto con mysql:(".$this->conexion-
>connect_errno.")");
    }
}

public function cerrar(){
    $this->conexion->close();
}

public function login($login, $pass){
    try {
        $login=htmlentities(addslashes($_POST["login"]));
        $password=htmlentities(addslashes($_POST["password"]));

        $base=new PDO("mysql:host=localhost; dbname=gimnasio" , "root", "");
        $base->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $sql="SELECT * FROM personas WHERE idPersonas= :login";

        $resultado=$base->prepare($sql);
        $resultado->execute(array(":login"=>$login));

        while($registro=$resultado->fetch(PDO::FETCH_ASSOC)){
            #echo "Usuario: " . $registro['idPersonas'] . " Contraseña: " .$registro['Nombres'] . "<br>";#
            if($_SESSION['roles_idRoles'] == 1){
                header("Location:../vista/interfaz_admi_nueva.php");
            } else {
                header('Location:/index/Usuario/index.php');
            }
        }

        $resultado->closeCursor();

        /*
        $this->user = $usuario;
        $this->password = $upass;

        $query = "SELECT idPersonas, Contrasena, roles_idRoles FROM personas WHERE idPersonas ='".$this->user."' AND Contrasena = '".$this->password."'";

        $consulta = $this->conexion->query($query);

        if($row = mysqli_fetch_array($consulta)){

            session_start();

            $_SESSION['idPersonas'] = $row['idPersonas'];
            $_SESSION['Contrasena'] = $row['Contrasena'];
            $_SESSION['roles_idRoles'] = $row['roles_idRoles'];

            if($_SESSION['roles_idRoles'] == 1){
                header("Location:../vista/interfaz_admi_nueva.php");
            } else {
                header('Location:/index/Usuario/index.php');
            }
        } else {
            echo "usuario o password incorrectos";
        }
        */
    } catch(Exception $e) {
        die("Error: " . $e->getMessage());
    }
}
}
?>