_session login issue

natman3

I think the key to solving my issue lies within this function. I just have to somehow get the field name from the table. Does anyone have any ideas?

function set_user() {
// the user, pw are taken from the login.php 
		$_SESSION['user'] = $this->user;
		$_SESSION['pw'] = $this->user_pw;
		if (isset($_SESSION['referer']) && $_SESSION['referer'] != "") {
			$next_page = $_SESSION['referer'];
			unset($_SESSION['referer']);
		}
/* I think i need something like this

$sql = sprintf("SELECT COUNT(*) AS test FROM %s WHERE divisionType";
$value  = mysql_query($sql);
 if (isset($_SESSION['highschool'] == $value) {
			header("Location: high_page.php");	
			}
 else if (isset($_SESSION['college'] == $value) {
			header("Location: college_page.php");	
			}
*/
		 else {
			$next_page = $this->main_page;
		}
		header("Location: ".$next_page);
	}

bretticus

Well, it's obvious you didn't write these classes. I say that because your code is mildly complex, but your question is pretty basic. You should pay me for going through them J/K 😃

You will need to query your users table again with the credentials that were set to properties already (as checkuser returns true or false only.) The appropriate place seems to be in the set_user() function as you have indicated. Just query the database in there for the "userpage" data that I can only assume is a part of the $this->table table.

Your query will look something like this:

$sql = sprintf("SELECT `userpage` FROM %s WHERE BINARY login = '%s' AND pw = '%s' AND active = 'y'", $this->table_name, $this->user, $this->pass);

All you have to do is set that result to your session variable and then redirect appropriately.

natman3

I am fairly new to php and classes. thanks for your help i will see what i can do.