Ajax вход в систему ⇐ Php

[Anonymous]

разъем PHP < /p>

Код: Выделить всё

// Connect to server and select database.
mysql_connect($host, $username, $password)or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

/* escape entered values to prevent sql nastyness */
$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);

if(!empty($username) && !empty($password)){

/* we query through our database to search for a username that has been entered */
$query = mysql_query("SELECT * FROM $tbl_name WHERE UserLogin = '$username' AND UserPass='$password'");

if(mysql_num_rows($query) == 1){
/* if there is a match with the database, we select the username and password from the database corresponding to the entered username */
while($row = mysql_fetch_assoc($query)){
$db_username = $row['username'];
$db_password = $row['password'];
}
/* we compare the entered username and password with the ones we just selected from the database */
if($username == $db_username && $password == $db_password){
/* If the entered username and password are correct, return 1 */
echo '1';
}
} else {
/* If the entered username or password do not match, return 2 */
echo 'Username or Password are wrong';
}
} else {
/* If both fields are empty, return 3 */
echo 'Username and Password are empty';
}
< /code>
javascript < /p>
    $(document).ready(function() {

$('#login_form').submit(function() {

$.ajax({
type: "POST",
url: 'php/check_login_online.php',
data: {
username: $("#username").val(),
password: $("#password").val()
},
success: function(data)
{
if (data === '1') {
window.location.replace('php/search.php');
}
else {
alert(data);
}
}
});

});

});
< /code>
html < /p>




test Login

Я сокращаю дополнительный код, но когда я нажимаю кнопку входа в систему, URL -адрес изменяется, но остается на странице входа в систему с именем пользователя и паролем, но не существует проверки.

Подробнее здесь: https://stackoverflow.com/questions/182 ... ogin-issue