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