<?php
//Login en la base de datos
$servername = "xxx";
$username = "xxx";
$password = "xxx";
$dbname = "xxx";

//Coge las variables del ajax
$email = $_POST["email"];
$contraseña = $_POST['password'];
// Crea una nueva conexion
$conn = new mysqli($servername, $username, $password, $dbname);

// Comprueba la conexion
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$total = mysqli_num_rows(mysqli_query($conn," SELECT email FROM USUARIOS where email = '$email' and password = '$contraseña'"));
    if($total == 1){

        $admin = $conn,"SELECT role FROM USUARIOS where email = '$email' and password = '$contraseña'" ->get_result() ;
        if( $admin == 'admin'){
 echo "U are a admin user" . $admin;
            header('Location: ../admin.html');
        } else {
            echo "U are a normal user" . $admin;
header('Location: ../user.html');
        }
    }else{
        echo "Error login";
    }

$conn->close();

?>