[PHP][SQL] echo html jezeli ma poprawny numer w SQL

[cryptarithm]

Zrobilem system logowania ale chce miec dwa typy uzytkownika, Admin i User.
Zrobilem dwa konta w Mysql, Admin i User.

Zeby odroznic dwoch od siebie zrobilem kolumne w MySql "Level" , dla admina dalem 10 a dla usera dalem 0.

I chcialem to tak zrobic:

Jezeli Uzytkownik ma Level 10 to Echo <li><a href="/admin">Admin Panel</a></li>.
To w wyniku mi doda linka w panelu uzytkownika.

Albo zarejestrowac numer w sesji kiedy sie loguje ? Pomocy!

[camelrafal]

ale jakie jest pytanie?
skorzystaj z sesji sobie

[cryptarithm]

a no pytanie tez jest "jak to zrobic"

jestem w stanie zarejestrowac ten numer do sesji ale potem w php jak napisac " Jezeli =10 to echo...."

[camelrafal]

a jaki masz system logowania?
nie opierałeś go na sesji?
jak jakiś kolo sie zaloguje to ustawiasz jakąś zmienną w sesji z 'levelem' zalogowanego uzytkownika
poczytaj sobie o sesjach i o instrukcjach warunkowych if

[cryptarithm]

Jest na sesji

Kod:

<div id="title">
                    <h1>USER AREA</h1>
                    <h2><?php if(isset($_SESSION['success']))    echo "Welcome back ".$_SESSION['username']; ?></h2>
                </div>
                <?php
                
                
                if(isset($_SESSION['success']))
                    
                    echo '<section>
                                <ul>
                                    <li><a href="#">Account</a></li>
                                    <li><a href="/admin">Admin Panel</a></li>
                                    <li><a href="destroy.php">Logout</a></li>
                                </ul>
                            </section>';
                    
                else
                                    echo '
                <div id="form">
                    <form method="POST" action="login.php">
                        
                        <input type="text" class="input"name="username" value="" placeholder="username" autocomplete="off"  />
                
                        <input type="password" class="input" name="password" value="" placeholder="password" /><br /><br /><br />
                    
                    
                        <input type="submit" class="submit" value=""/>
                    </form>
                </div>';
                ?>
            </div>
        </div>

a to jest login

Kod:

<?php
                    session_start(); //start session
                    include('connect.php'); //connection
                    
                    // username and password sent
                    $username=$_POST['username'];
                    $password=$_POST['password'];
                    
                    
                    $encrypted=md5($password);
                    
                    // protection againt SQL injection
                    $username = stripslashes($username);
                    $encrypted = stripslashes($encrypted);
                    $username = mysql_real_escape_string($username);
                    $encrypted = mysql_real_escape_string($encrypted);
                    
                    
                    $sql="SELECT * FROM users WHERE username='$username' and password='$encrypted'";
                    $result=mysql_query($sql);
                    
                    $count=mysql_num_rows($result);
                    if($count==1){


                    session_start();
                    $_SESSION['success'] = 1;
                    $_SESSION['username'] = $username;
                    header("location:index.php");
                    }
                    else {
                    echo "Wrong Username or Password";
                    }    
                    
?>

[Kartofelek]

Pobrałeś usera z bazy, przecież tak samo możesz pobrać jego level i wstawić to do sesji.