Guest User

Untitled

a guest
Feb 19th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. session_start();
  2. include("../clascn/cnxweb.php");
  3. $user = $_POST['username'];
  4. $pass = $_POST['password'];
  5. $latitud = $_POST['latitud'];
  6. $longitud = $_POST['longitud'];
  7. $accuracy = $_POST['acurracy'];
  8. $cons="SELECT * u.UsuarioId,u.Nombre,u.IdUsuario,u.Administrador,u.PASSWORD,u.NivelId,n.nivel,n.pagina FROM Usuarios AS u
  9. LEFT JOIN niveles AS n ON n.nivelid = u.NivelId where u.IdUsuario = '$user' and u.Password = '$pass'";
  10. $query = $pdo->prepare($cons);
  11. $query->execute();
  12. $row = $query->fetch();
  13. $iduser = $row['IdUsuario'];
  14. $pagina = $row['pagina'];
  15. if ($iduser == ""){ echo 'hay un error...';
  16. // header("Location: index.php?error=true");
  17. ?>
  18. <script type="text/javascript">
  19. window.location = "../index.php?error=true"
  20. </script>
  21. <? }else{
  22.  
  23. $_SESSION["user"] = $row['IdUsuario'];
  24. $_SESSION['estado'] = 'Autenticado';
  25. $_SESSION['esadmin'] = $row['NivelId'];
  26.  
  27. $fecha = date('Y-m-d');
  28. $hora = date('H:i:s');
  29. $cons="insert into accesos (fecha, hora , usuario ,latitud,longitud,accuracy )
  30. values ('$fecha','$hora','$iduser','$latitud','$longitud','$accuracy')";
  31. $query = $pdo->prepare($cons);
  32. $query->execute();
  33.  
  34. //header('Location: menus.php');
  35. ?>
  36. <script type="text/javascript">
  37. window.location = "<? echo $pagina ?>"
  38. </script>
  39. <? }
  40. ?>
Add Comment
Please, Sign In to add comment