PHP session variable undefined

Question

I have this session variable which i am trying to set to an access level when the users logs in with this:

 $accessquery = mysql_query("SELECT roleid FROM person WHERE email = '". $email ."'");
 $access = mysql_fetch_array($accessquery);

 $_SESSION['Access'] = $access;

However it says that 'Access' is undefined, what is the problem?

EDIT*

if (($_SESSION['Access']) == "2")

Error appears here

EDIT*

Session Start has been called.

Where does it say that? Did you remember to start the session? — JJJ
– JJJ, Commented Nov 27, 2011 at 20:34
I don't see where the access is being defined nor do I see session_start(); — Mārtiņš Briedis
– Mārtiņš Briedis, Commented Nov 27, 2011 at 20:35
You should really watch out for SQL injections with code like this. If this were production code, your site would be hacked within 2 minutes. — Tom van der Woerdt
– Tom van der Woerdt, Commented Nov 27, 2011 at 20:50

TylerH · Accepted Answer · 2017-02-02 15:43:19Z

6

Two possibilities here :

Start the session by using session_start(); at the begining of page.

use the following code:

$accessquery = mysqli_query($conn, "SELECT roleid FROM person WHERE email = '". $email ."'", mysqli_store_result($conn));

$access = mysqli_fetch_row($accessquery);

$_SESSION['Access'] = $access[0];

edited Feb 2, 2017 at 15:43

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered Nov 27, 2011 at 20:40

Ariful Islam

7,6837 gold badges38 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gilles Quénot · Accepted Answer · 2011-11-27 20:40:08Z

0

To figure out what's going on, I recommend you to use

print_r($any_variable);

See http://php.net/print_r

answered Nov 27, 2011 at 20:40

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

Comments

Bill · Accepted Answer · 2011-11-27 20:42:19Z

0

Did you call session_start();?

Try to debug your code with just a fixed value: $_SESSION["Test"]="test"; and then do a var_dump($_SESSION);

answered Nov 27, 2011 at 20:42

Bill

3,2393 gold badges35 silver badges49 bronze badges

Collectives™ on Stack Overflow

PHP session variable undefined

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related