Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class conexion{
- private $conexion;
- private $server= "localhost";
- private $usuario= "root";
- private $pass= "";
- private $db= "senaconnection";
- private $user;
- private $password;
- public function __construct(){
- $this->conexion= new mysqli($this->server,$this->usuario,$this->pass,$this->db);
- if ($this->conexion->connect_errno) {
- die("Fallo al tratar de conectar con MySQL: (".$this->conexion->connect_errno.")");
- }
- }
- public function cerrar(){
- $this->conexion->close();
- }
- public function login($email,$pass){
- $this->user= $email;
- $this->password= $pass;
- $query="select id_usuario,nombres,apellidos,correo_sena,contraseña from usuario where correo_sena='".$this->user."' and contraseña='".$this->password."'";
- $consulta=$this->conexion->query($query);
- if ($row = mysqli_fetch_array($consulta)) {
- session_start();
- $_SESSION['id']= $row['id_usuario'];
- $_SESSION['nom']= $row['nombres'];
- $_SESSION['ape']= $row['apellidos'];
- echo "Has iniciado sesion";
- echo $_SESSION['id'];
- echo $_SESSION['nom'];
- echo $_SESSION['ape'];
- }else{
- echo "usuario o contraseña incorrectos";
- }
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement