Hello. I have one problem with header function in my login script. The code is:

PHP Code:

$_SESSION["username"] = $dbusername;
        $username1 = $_SESSION['username'];
        $_SESSION["myusername"]=$dbusername;
        $sql1 = "SELECT admin FROM admin WHERE username=$username1";
        $result1 = mysql_query($sql1) or die(mysql_error());
        while ($row1 = mysql_fetch_array($result1))
        {
            $admin = $row1['admin'];
            if ($admin != '1')
            {
                header("Location:../sales/");
            }
            else
            {
                header("Location:index.php");
            }
        } 


When i log in, it opens checklogin.php file, but it don't redirect me to 'index.php'. But, when is $admin != '1', it redirects me to sales folder. I don't know what to do. Thanks.

Try:

PHP Code:

header("Location: /index.php"); 


with a / in front of index.php

Again the same

You can try just the / without the index.php after, though I'm going to guess that won't work either. You could also try the absolute path to the domain.

You're saying it does work when you're not an admin and it takes you to the sales page?

I'm assuming the index.php page is at the root of the domain.

Try adding some other random page instead of the index.php page and see if you get redirected there. If you can redirect to the other page then the issue is how you're trying to redirect to the index.php page. If you can't get redirected to any page as admin then the system isn't understanding you're an admin and something in the programming logic needs to be fixed.

I tried to change the index.php, and it isn't working. I can send you whole code, if you want.

I also have the same problem

Any updates on this one?

Hello. I found problem. It was in SQL query. My query was:

PHP Code:

$sql1 = "SELECT admin FROM admin WHERE username=$username1"; 


I changed it:

PHP Code:

$sql1 = "SELECT admin FROM admin WHERE username='$username1'"; 


I didn't put '' on $username.
Thanks anyway. Bye.

I'm glad you were able to find the fix.

Lesson 1: Always test results of things like db queries.

Lesson 2: Put an exit(); after the header call ...