Logowanie Opcje

[rafkam]

Kod

<?



if ((!$username) || (!$password)) {

    header("Location: http://localhost/show_login.html");

    exit;

}





$db_name = "test";

$table_name = "logowanie";



$connection = @mysql_connect("localhost", "", "")

    or die("Couldn't connect.");



$db = mysql_select_db($db_name, $connection)

    or die("Couldn't select database.");



$sql = "SELECT * FROM $table_name

    WHERE username = "$username" AND password = password("$password")

    ";



$result = mysql_query($sql)

        or die ("Can't execute query.");



$num = mysql_numrows($result);



if ($num != 0) {



    $cookie_name = "auth";

    $cookie_value = "ok";

    $cookie_expire = "";

    $cookie_domain = "";

    

    setcookie($cookie_name, $cookie_value, $cookie_expire, "/" , $cookie_domain, 0);

itd..

W bazie obok userów zamiescilem kolumne z levelami dostepu. Jak zrobić aby po podaniu sprawdzał oprócz login i haslo odpowiedni level i przekierowywal go na taką odpowiednia mu strone.