Need help saving session id

[JOV17]

Hello,

I'll pose my question as simply as possible, as I do respect your time.

I have a user login form on my site. I need to save the session id to my database when a user registers for a username and password. I need this because in a different table I will store book information that corresponds to the same session id that exists in the "users" table.

Basically, I need to know how to save the session ID upon user registration & how to call it when they login, so that I can show the user the books they've posted when they login.

A good example of this can be found on my site at www.bookstorebandits.com

This site was programmed with Lasso, and I'm trying to reprogram it with PHP.

Any help is appreciated.

Thanks in advance!

[Stoned_Gecko]

You can extract the current session ID using the session_id() function. In your case it would be something like this:

//Start the session
session_start();

//Get the session ID
$sid = session_id();

//Insert it
$query = "INSERT INTO sessions (id,user) VALUES ('$sid','$user_name')";

//or get the associated username
$query = "SELECT user FROM sessions WHERE id = '$sid'";

Hope this helps