PHP script only shows when admin is loggedin

[as4s1n]

When people log into my site up at the top right shows their profile picture, a link to their account and a sign out link (regular user). But whenever people log in the top right is invisible, even on the source. Only the admin and not logged in users (register & log-in) can see it.

<?php
$name = (isset($_SESSION['loggedin'])) ? $_SESSION['loggedin'] : '0';
if($name == '0') {
    echo "<a href=\"index.php?p=signInForm\">Log in</a>&nbsp;\n";
    echo "<a href=\"index.php?p=registerForm\">Register</a>\n";
} else {
    $sth = $dbh->query("SELECT id,username,avatar,admin FROM users WHERE username = '$name'");        
    
    while($row=$sth->fetch()){
        $userID = $row['id'];
        $username = $row['username'];
        $avatar = $row['avatar'];
        $admin = $row['admin'];
        
        echo "<a href=\"http://x10hosting.com/forums/images/userImages/avatars/$avatar\"><img src=\"http://x10hosting.com/forums/images/userImages/avatars/$avatar\" width='50' height='50' align='left' /></a><br />\n";
        echo "Welcome $username<br />\n";
        echo "<a href=\"index.php?p=viewProfile&id=$userID\">My profile page</a><br />\n";
        echo "<a href=\"index.php?p=signOutFinish\">Sign Out</a>\n";
if($admin == 1) {
        echo "<a href=\"index.php?p=admin/admin_checkentries\">Administration</a>";
    }
}
}
?>

I have no idea what is wrong

[descalzo]

Got session_start() ?

[as4s1n]

Yes that is in my index page in which I include this page.

[descalzo]

Well, you are assuming that the value for $_SESSION['loggedin'] is a valid username, ie in the database. If your query returns 0 rows, you get no output.

Try echoing its value to the page. Perhaps your code that supposed to set it when they log in is faulty. Maybe you misspelled 'loggedin' there, or something else.

[as4s1n]

Nope, it returns the value I want it. But it does not do what I want with the value... Which confuses me

[descalzo]

<?php
$name = (isset($_SESSION['loggedin'])) ? $_SESSION['loggedin'] : '0';
if($name == '0') {   #### $name not '0', otherwise this would be in source
    echo "<a href=\"index.php?p=signInForm\">Log in</a>&nbsp;\n";
    echo "<a href=\"index.php?p=registerForm\">Register</a>\n";
} else {
    $sth = $dbh->query("SELECT id,username,avatar,admin FROM users WHERE username = '$name'");     
    ####   
    #### query should be ok, otherwise next line should cause an error, 
    #### since $sth would be false, not an object
    ####
    while($row=$sth->fetch()){   
        ##
        ## if you got at least one row, you would get something printed.
        ##  ergo, your request returned 0 rows
        ##  
        $userID = $row['id'];
        $username = $row['username'];
        $avatar = $row['avatar'];
        $admin = $row['admin'];
        
        echo "<a href=\"http://x10hosting.com/forums/images/userImages/avatars/$avatar\"><img src=\"http://x10hosting.com/forums/images/userImages/avatars/$avatar\" width='50' height='50' align='left' /></a><br />\n";
        echo "Welcome $username<br />\n";
        echo "<a href=\"index.php?p=viewProfile&id=$userID\">My profile page</a><br />\n";
        echo "<a href=\"index.php?p=signOutFinish\">Sign Out</a>\n";
if($admin == 1) {
        echo "<a href=\"index.php?p=admin/admin_checkentries\">Administration</a>";
    }
}
}
?>

[as4s1n]

I do not understand what you changed.

[descalzo]

I didn't. I added comments.

The only way for nothing to show up is for $name to be set to a username that is not in the database.
If it is set to '0' you get the Sign In links.
So it cannot be '0'
So it contains the contents of $_SESSION['loggedin']
If your query returned an error, you should get an error message. You do not. So, no error.
If the query returns any rows, something is printed.
Nothing is printed.
Hence, your query returns 0 rows--except when it is an admin.
So, when a regular user logs in, it appears that $_SESSION['loggedin'] is not set to the proper value, but when an admin signs in, it does.
Or your regular users are not actually in the db.

Edit/Add: you might want to use phpMyAdmin to view the contents of that table.

[as4s1n]

So how can I fix this?

[as4s1n]

Waiting for server to come back online to see if your solution worked.