calling username and membership level

[Mynxie]

I've installed an extra feature for a site, but I need it to be able to verify the username and that username's "level" of membership before allowing the user to proceed to the new feature. The usernames and levels are already in the database(MySql), but I'm new to php and haven't the foggiest idea how to begin or what to put to pull that info... can anyone help?

[Pinkmischief]

You could use a switch on the users level
example

//retrieved users level from database $result['level'] equals your level column in db.
$level = $result['level']
switch ($level){

case 1:
echo "Highest user here";
break;

case 2:
echo "Intermediate User";
break

case 3:
echo "Novice User";
break;

default:
echo "Unknown Level";
break;
}

i,m fairly new to php myself but i have used this method before so i know it works 😃

[Mynxie]

Thanks for your fast reply!!

The levels are listed in a column in the username row, how would i get it to check the username, and then check that column for their level number (1-4), then direct those with level 1 on to the new feature, and send the others (user levels 2-4) on to the old feature?

[Houdini]

Just check for level 1 then send them to one page otherwise send them to the regular part of the site. You could use a WHERE clause in the sql query and merely check if that username is level 1

SELECT * FROM tablename WHERE level = 1 AND username ='$username'

[Mynxie]

cooool, thanks Houdini!!

[Pinkmischief]

you could use houdinis way or alternatively another possibility is to do this.

function userlevel(){
//if submit/login is pressed
if(isset($_POST['Submit'])){
$username = $_POST['username'];
$password = $_POST['password'];

     $sql = ("select * from users where username = '".$username."' and password = '".$password."')";
     $query = mysql_query($sql) or die (mysql_error()."".);
     $result = mysql_fetch_array($query);
     $level = $result['level'] 
switch ($level){ 

case 1: 
//if level 1 user send to admin control page
header ('Location: admin.php'); 
break; 

case 2: 
//if intermediate user 
header ('Location: intermediate.php'); 
break 

case 3: 
//if normal user
header ('Location: public.php');
break; 

default:
//if level unknown send user to unknown page 
header ('Location: unknownlevel.php');
break; 
}
}
//i presume you know about includes etc.... if not look below
//in your template page put this at the top 
//NOTE this code will only work if checklevel.php is in the same folder as the template page.
<?php include_once('checklevel.php'); ?>
//then somwhere in your page use this 
<?php userlevel(); ?>

// What i done when i used this method was to have the coding for each users page in each case statement and then call this function in a blank page to fill a template page with all the content for the relevant user.

[/code]

Its a bit cheeky as you can effectively put 4 users pages in the one switch without having to have 4 pages server side as it will only display one in the template so therefore saves you a bit of time i think for editing as you only need to edit the html in each case depending on whose page you wish to edit.

PHEW!!! lol i hope this helps you
🙂
Regards Pinky.