User privileges with mysql database and php -

User privileges with mysql database and php -

i'm making login page i've finished login how go having web page display diffren't things based on users privileges , how set privileges in mysql database? , utilize them in php code?

i create field in users table called admin or in case maybe privilege_level, in php, define values of field correspond levels of privilege.

edit (example):

// start session on every page using $_session array session_start(); session_name("your site name"); header("cache-control: private"); // in login file: $q = mysql_query("select uid, privilege_level users pw = 'escaped_and_preferrably_hashed_password' , username = 'escaped_username' limit 0,1"); // if row found: if($q && mysql_num_rows($q) > 0){ // associative array $array = mysql_fetch_assoc($q); // set session vars $_session['privilege_level'] = $array['privilege_level']; }

then, on pages want check privilege level can utilize switch or other command structure/design pattern load content dynamically, ie:

switch($_session['privilege_level']){ default: echo 'you have no privileges'; break; case "1": echo 'you have privileges'; break; case "2": echo 'you have lots of privileges'; break; }

php mysql user privileges