session variables

[seanlyons]

I have a login which defines a session variable 'logged_on" which contains the contents of the username field of my database, and this is used to allow users to move between pages seeing only their info.

However, in another part of my site, (its an on-line learning application) I would like tutors to be able to look at the scores of multiple students but only students that they teach.

Each tutor has a school id (not the username) and each student taught by them has that code assigned to them.

Can I assign another value to another session id at login, if they are all stored in the same database as ther original username and password?

Even I'm confused

How do I assign a session variable to a field in a database, after log-in

Thanks

Sean

[adrian_quah]

// The SQL query
$result3=mysql_query("SELECT * FROM users_access_rights WHERE Login=\"$username_input\"", $linkID) or die ("Could not determine Rights");
$row3=mysql_fetch_array($result3);
$users_group_id = $row3["Group_ID"];

//Register as session variable:
session_register("users_group_id");

Hope this helps u...it's part of what i used...Change the SQL statement according to ur database table..it should be okay 😃

[seanlyons]

thanks, for the speedy response.

I am very new to this so sorry if I am asking some dumb questions

"SELECT * FROM users_access_rights WHERE Login=\"$username_input\"", $linkID

after the FROM statement will be the name of my table...yes?

The word Login , do I need to change that to something from my table

$username_input, do I also need to change this

Thanks for your help

Sean

[adrian_quah]

it's okay..that's how we all learn..i ask many basic questions too, but i find PHP fun 2 work with. Anyway, here's the format for a SELECT function: -

SELECT * FROM table_name WHERE field_name[/]=variable_that_contains_user_name[/I]

Pls reply if u're still not clear abt this..I suggest u try a few times, it should be working 🙂

[adrian_quah]

Sorry, here is the statement again: -

SELECT * FROM table_name WHERE field_name=variable_that_contains_user_name

[seanlyons]

Thanks, will give it a go tomorrow....its getting late here in New Zealand. Will let you know how I get on...I am sure I will still have some questions

Thanks again

Sean

[seanlyons]

Hope your still around

The server gives me a parse error on the first line of the code

$result3=mysql_query("SELECT * FROM login WHERE username="$logged_on"", $linkID) or die ("Could not determine Rights");
$row3=mysql_fetch_array($result3);
$users_group_id = $row3["school_id"];

//Register as session variable:
session_register("school_id_session"); 

So the table name is login, the username field is called loggin, I think the variable name is $logged_on (Following is the code that leads me to believe this)

mysql_free_result($rsLogin);
session_register("logged_on");
$logged_on = $HTTP_POST_VARS['username'];

and school_id is the field that contains the identifier

Can you see whats wrong here?

[adrian_quah]

Yepp, still around 🙂

a longer version would include the database connection properties at the top:

//Database properties
$linkID = @mysql_connect("database_host_name", "database_login", "database_password"); // DB connection, username & password to access DB
mysql_select_db("your_database_name", $linkID);

// SQL query to get the 
$result=mysql_query("SELECT * FROM login WHERE loggin="$logged_on"", $linkID) or die ("Sorry, mistake somewhere.");
$row=mysql_fetch_array($result);
$school_id_session = $row3["school_id"]; // Gets the value of table based on field name 'school_id'
$logged_on = $HTTP_POST_VARS['username']; // but...where does the variable 'username' come from?

//Register as session variables:
session_register("school_id_session");
session_register("logged_on");

Sean, hope it gives u a better understanding..I suggest u spend some time learning more SQL so you can write the queries to the database, and get to know more of database connections and variable functions in PHP. That'll help u a lot once u've got it right, and u can begin writing more complex SQL queries 😃 faster.
The PHP manual which is downloadable from www.php.net is a good place for PHP language reference.

[adrian_quah]

oops..
One of the lines should have read: -

$school_id_session = $row["school_id"]; 

[seanlyons]

Thanks for all your help so far. I don't know if you can help me any more but everything I try seems to come back to the same parse error on the

$result=mysql_query

line.

I have pulled out most of my hair

The complete code I am using is

$linkID = @mysql_connect("sql-01.portlandpremium", "s*****s", "****"); // DB connection, username & password to access DB
mysql_select_db("s*****s", $linkID);


$result=mysql_query("SELECT * FROM login WHERE username="$logged_on"" , $linkID) or die ("Sorry, mistake somewhere.");
$row=mysql_fetch_array($result);
$school_id_session = $row["school_id"]; // Gets the value of table based on field name 'school_id'
$logged_on = $HTTP_POST_VARS['username']; 

//Register as session variables:
session_register("school_id_session");
$school_id_session = $row["school_id"];
session_register("logged_on");

I think I understand a little more about the query syntax, and I will go and try to study it when I have some time.

Any further comments will be graciously recieved

Sean😕