<?php
 define('DB_SERVER', 'localhost:8889');
 define('DB_USERNAME', 'root');
 define('DB_PASSWORD', 'root');
 define('DB_DATABASE', 'ProgramaPruebas');
 $db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
 ?>

<?php
 include("config.php");


 if($_SERVER["REQUEST_METHOD"] == "POST") {


  $myusername =    mysqli_real_escape_string($db,$_POST['user_nickname']);
  $mypassword = mysqli_real_escape_string($db,$_POST['password']);



  $sqlusertype = "SELECT ID_Perfil FROM Usuarios WHERE user_nickname = '$myusername' and password = '$mypassword";
  $result1 = mysqli_query($sqlusertype, $db);


  $sql = "SELECT User_Id FROM Usuarios WHERE user_nickname = '$myusername' and password = '$mypassword'";
  $result = mysqli_query($db,$sql);


  $count = mysqli_num_rows($result);



  if($count == 1 && result1 == 001 ) {



    echo '<script type="text/javascript">
    alert("Inicio de Sesión Exitoso");
    window.location.href="MenuExamenes.php";

    </script>';

     alert("Inicio de Sesión Exitoso");

     }
     elseif($count == 1 && result1 == 002 ){
     echo '<script type="text/javascript">
     alert("Inicio de Sesión Exitoso");
     window.location.href="MenuPrincipal.php";

     }else{
     $error = "El usuario/contraseña son incorrectos";
  }
  }
  ?>