Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <meta name="viewport" content="initial-scale=1, maximum-scale=1, user-scalable=no, width=device-width">
- <title>Prueba db</title>
- <script src="js/jquery-3.2.1.min.js"></script>
- <script>
- $(document).ready(Principal);
- function Principal(){
- $("#btnenv").click(loguea);
- }
- function loguea(){
- var email = $("#email").val();
- var passw = $("#passw").val();
- $.ajax({
- type: "POST",
- url: "http://www.nombredominiogratis.cf/tareas_u/oiga/validate.php",
- data: {mail:email,pass:passw},
- success: function(data){
- $("#olvi").html(data);
- console.log(data);
- }
- });
- }
- </script>
- </head>
- <body>
- <form method="post">
- <div class="field-wrap">
- <label>Correo Electronico<span class="req">*</span></label>
- <input id="email" name="mail" type="email" required autocomplete="off"/>
- </div>
- <div class="field-wrap">
- <label>Password<span class="req">*</span></label>
- <input id="passw" name="pass" type="password" required autocomplete="off"/>
- </div>
- <p class="forgot"><a id="olvi" href="#">Aquí va el número que traigo desde el php</a></p>
- </form>
- <button id="btnenv" class="button button-block"/>Ingresa!</button>
- <script type="text/javascript" src="cordova.js"></script>
- </body>
- </html>
- <?php
- header('Access-Control-Allow-Origin: *');
- header('Access-Control-Allow-Methods: GET, POST');
- include 'connect.php';
- $mail= $_POST['mail'];
- $pass= $_POST['pass'];
- $invi=$db->prepare("SELECT * FROM `invitados` WHERE correo = :mail AND clave = :pass");
- $invi->bindValue(':mail',$mail,PDO::PARAM_STR);
- $invi->bindValue(':pass',$pass,PDO::PARAM_STR);
- $invi->execute();
- $user=$db->prepare("SELECT * FROM `usuarios` WHERE correo = :mail AND clave = :pass");
- $user->bindValue(':mail',$mail,PDO::PARAM_STR);
- $user->bindValue(':pass',$pass,PDO::PARAM_STR);
- $user->execute();
- if($user->rowCount()>0){ //Si el usuario está registrado
- echo 1;
- }
- else{ //sino,
- if($invi->rowCount()>0) echo 2; //si es invitado
- else echo 3; //si no existe
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement