How to use header while using AJAX?

Question

I have my login page where i need to check whether that username and password exists in my database or not So i have fired select query where username and password is entered by the user. Now I want is when there are no rows in result that means Username or Password is incorrect.

This header method is not working.What i need to do?

$sql="SELECT * FROM login WHERE username='$username' and password='$password'";
$result=mysqli_query($con,$sql);

$count=mysqli_num_rows($result);
if($count==0)
{
echo "Login Failed: Please Try Again";
}
if($count==1)
{
header('Location:something.php');
}

check return data from ajax and redirect via js window.location — Mustafa ASAN
– Mustafa ASAN, Commented Aug 15, 2015 at 10:46

Lajos Arpad · Accepted Answer · 2015-08-15 11:00:10Z

2

You already have an ajax call. Use this function as a callback:

function success(message) {
    if (message === "success") {
        window.location.href = yourpath; //yourpath is a string involving something.php
    } else {
        alert(message);
    }
}

And change your PHP to something like:

$sql="SELECT * FROM login WHERE username='$username' and password='$password'";
$result=mysqli_query($con,$sql);

$count=mysqli_num_rows($result);
if ($count==0) {
    echo "Login Failed: Please Try Again";
} else if ($count==1) {
    echo "success";
}

When you manage to make this work, you should fix other issues as well, namely:

your code is vulnerable to SQL injection, therefore your site can easily be hacked
you did not encrypt the password, which is a security leak

answered Aug 15, 2015 at 11:00

Lajos Arpad

80.4k42 gold badges123 silver badges235 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rng Over a year ago

This code is not working.The problem remains still same.

Lajos Arpad Over a year ago

Try to integrate it successfully.

Collectives™ on Stack Overflow

How to use header while using AJAX?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related