Page 1 of 1

php username help

Posted: Tue Jun 23, 2015 5:52 pm
by Mark
Hello,

I use this code to display my users

[PHP]echo "<b>Select Username</b>";
$users = mysql_query("SELECT `id`, `username` FROM `users`");
while ($run_user = mysql_fetch_array($users)){
$user = $run_user['id'];
$username = $run_user['username'];

echo "<p><a href='start.php?username=$user'>$username</a></p>";
}[/PHP]

How can i get it so my username dosent show as im logged in?

Re: php username help

Posted: Thu Jun 25, 2015 1:21 pm
by Filip
Do you get any errors?

Re: php username help

Posted: Thu Jun 25, 2015 3:33 pm
by Mark
Nope i got that resolved.

I'm having problems here this is the code i have
Code: Select all
<?php

if ($username){
    
    echo "<p>Hello, $username | </p>";
    
    require("scripts/connect.php"); 
    $query = mysql_query("SELECT user_level FROM users WHERE user_level='1'"); 
    $numrows = mysql_num_rows($query); 
     
        echo '<table><tbody>';
        while($row = mysql_fetch_assoc($query)){ 
            $id = $row['id']; 
            $user_level = $row['user_level'];
            
             
            echo "<tr><td><a href='admin.php'>Admin Center</a></td></tr>"; 
        } 
        echo '</tbody></table>';  
}
else
    echo "
    
    <p>
    Please Login Using The Form Below.
    <form action='login.php' method='post'>
    <table>
    <tr>
        <td>Username:</td>
        <td><input type='text' name='username'></td>
        <td><a href='register.php'>Register</a></td>
    </tr>
    <tr>
        <td>Password:</td>
        <td><input type='password' name='password'></td>
        <td><input type='submit' name='loginbtn' value='Login'></td>
    </tr>
    </table>
    </form><br/>
    
    Forgot Password <a href='forgotpass.php'>Click Here</a>.
im trying to display an admin.php link if the user_level is set to 1 and if its a 0 then it dosent show the link my table is called users?