how I program a login in php that redirects the user according to the role
<?php
$usuario = $_POST['usuario'];
$pass = $_POST['password']; if(empty($usuario) || empty($pass)){
header("");
exit();
} mysqli_connect('localhost','root','') or die("Error al conectar " . mysql_error()); mysql_select_db('smart') or die ("Error al seleccionar la Base de datos: " . mysql_error());
$result = mysql_query("SELECT * from users where email='" . $usuario . "'");
$rol = mysql_query("SELECT * FROM users WHERE id_rol = '" . $rol. "'");
if($row = mysql_fetch_array($result)){
if($row['password'] == $pass){
session_start(); $_SESSION['usuario'] = $usuario; if(isset($_SESSION["usuario"])){
if($_SESSION["id_rol"] == 1)
header("Location: dashboard_root.php");
}
elseif($_SESSION["id_rol"] == 2){
header("Location: dashboard_project.php");
}
elseif($_SESSION["id_rol"] == 3){
header("Location: dashboard.php");
}else{
header("Location: index.php");
}
}
}
?>