从基于会话数据的表中获取值

Question

I have an admin section to one of my websites I am building.

The variables it logs in by is email address and password.

Obviously each email address is unique to each admin, although I do have an 'admin_id' column which increments automatically per row.

The other columns stored within my admin table are - First Name (String), Last Name(String), Level(int).

I have tried -

$_SESSION['admin_id']=$_GET['admin_id'];

But when I try and simply echo the id, nothing is displayed.

Yet this line of code:

if(!isset($_SESSION['admin_email'])) 
die("<meta http-equiv='refresh' content='0; url=login.php'> ");

Manages to get the 'Admin_email' column from the table.

I am confused as to how to add other columns into my session data.

Many thanks in advance.

Answer 1

I have figured out why the 'admin_id' was not successful in been retrieved from the database.

The login.php where the admin first must authenticate themselves from is where the session data is saved - for it to be used in the admin session once logged in.

In order to solve this, I added the following line within the login.php (whilst the email address were been retrieved from the database):

$dblevel = $row['level']; 

and then to save it to a session:

$_SESSION['admin_level']=$dblevel; 

I logged out and then back in to reinitiate the session and it worked.