I'm creating a login interface in Intel XDK for a mobile app. When I hit login, I'm getting alert "login error". Username and password is exist in MySQL db but cant login.
HTML login form
<input type="text" placeholder="Email" id="email"> <input type="password" placeholder="Password" id="pass"> <button class="button widget uib_w_13 d-margins button-positive button-clear" id="login" data-uib="ionic/button" data-ver="0">Login</button>
Javascript
$(document).on("click", "#login", function(evt) { var email=$("#email").val(); var pass=$("#pass").val(); var dataString="email="+email+"&pass="+pass+"&login="; if($.trim(email).length>0 & $.trim(pass).length>0) { $.ajax({ type: "POST", url: 'http://localhost/signup.php', data: dataString, crossDomain: true, cache: false, beforeSend: function(){ $("#login").html('Connecting...');}, success: function(data){ if(data=="success") { localStorage.login="true"; localStorage.email=email; activate_page("#userpage"); } else(data="failed"); { alert("Login error"); $("#login").html('Login'); } } }); } return false; });
PHP Code
if(isset($_POST['login'])) { $email=mysql_real_escape_string(htmlspecialchars(trim($_POST['email']))); //example pass. do not use without bcrypt $pass=mysql_real_escape_string(htmlspecialchars(trim($_POST['pass']))); $login=mysql_num_rows(mysql_query("select * from `login` where `email`='$email' and `pass`='$pass'")); if($login!=0) { echo "success"; } else { echo "failed"; } }
Any help appreciated. Thank you