Advertisement
Guest User

Untitled

a guest
Sep 13th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <meta name="viewport" content="initial-scale=1, maximum-scale=1, user-scalable=no, width=device-width">
  6. <title>Prueba db</title>
  7. <script src="js/jquery-3.2.1.min.js"></script>
  8. <script>
  9. $(document).ready(Principal);
  10. function Principal(){
  11. $("#btnenv").click(loguea);
  12. }
  13.  
  14. function loguea(){
  15. var email = $("#email").val();
  16. var passw = $("#passw").val();
  17. $.ajax({
  18. type: "POST",
  19. url: "http://www.nombredominiogratis.cf/tareas_u/oiga/validate.php",
  20. data: {mail:email,pass:passw},
  21. success: function(data){
  22. $("#olvi").html(data);
  23. console.log(data);
  24. }
  25. });
  26. }
  27.  
  28. </script>
  29. </head>
  30. <body>
  31. <form method="post">
  32. <div class="field-wrap">
  33. <label>Correo Electronico<span class="req">*</span></label>
  34. <input id="email" name="mail" type="email" required autocomplete="off"/>
  35. </div>
  36. <div class="field-wrap">
  37. <label>Password<span class="req">*</span></label>
  38. <input id="passw" name="pass" type="password" required autocomplete="off"/>
  39. </div>
  40. <p class="forgot"><a id="olvi" href="#">Aquí va el número que traigo desde el php</a></p>
  41. </form>
  42. <button id="btnenv" class="button button-block"/>Ingresa!</button>
  43. <script type="text/javascript" src="cordova.js"></script>
  44. </body>
  45. </html>
  46.  
  47. <?php
  48.  
  49. header('Access-Control-Allow-Origin: *');
  50. header('Access-Control-Allow-Methods: GET, POST');
  51.  
  52. include 'connect.php';
  53.  
  54. $mail= $_POST['mail'];
  55. $pass= $_POST['pass'];
  56.  
  57. $invi=$db->prepare("SELECT * FROM `invitados` WHERE correo = :mail AND clave = :pass");
  58. $invi->bindValue(':mail',$mail,PDO::PARAM_STR);
  59. $invi->bindValue(':pass',$pass,PDO::PARAM_STR);
  60. $invi->execute();
  61.  
  62. $user=$db->prepare("SELECT * FROM `usuarios` WHERE correo = :mail AND clave = :pass");
  63. $user->bindValue(':mail',$mail,PDO::PARAM_STR);
  64. $user->bindValue(':pass',$pass,PDO::PARAM_STR);
  65. $user->execute();
  66.  
  67. if($user->rowCount()>0){ //Si el usuario está registrado
  68. echo 1;
  69. }
  70. else{ //sino,
  71. if($invi->rowCount()>0) echo 2; //si es invitado
  72. else echo 3; //si no existe
  73. }
  74. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement