Here is index.php
post_data = {'username':username, 'old_pass':old_pass, 'new_pass':new_pass};
$.post('change_pass.php', post_data, function(result) {
if(result.text == 'success') {
$("#message").text("Password changed successfully");
} else {
$("#message").text("Error changing password");
}
}, 'json');
and the change_pass.php is
@mysql_connect("localhost","root","") or die('Connection problem');
@mysql_select_db("my_db");
$username = filter_var($_POST["username"], FILTER_SANITIZE_STRING);
$old_pass = filter_var($_POST["old_pass"], FILTER_SANITIZE_STRING);
$new_pass = filter_var($_POST["new_pass"], FILTER_SANITIZE_STRING);
if(mysql_num_rows(mysql_query("UPDATE `users` SET `pass`='".$new_pass."' WHERE `pass`='".$old_pass."' AND `user`='".$username."'")) == 1) {
$output = json_encode(array('text' => 'success'));
die($output);
} else {
$output = json_encode(array('text' => 'failure'));
die($output);
}
?>
The password changing happens successfully but the callback doesn't work. why?
But the callback works if I avoid the query. So I think something goes wrong when i use the query.