help....SESSIONS

[garfx]

I'm new to php and programming to be honest with you, so please keep it simple....

I have the following session code stored in a mysql DB as a text entry

$SESSION['part'][4] = 1;
$SESSION['part'][5] = 1;
$_SESSION['part'][6] = 1;

I have done this so a can retrieve this information ($row->part) and run it again - i.e. reactivating the session values... can someone please help me.. how can i run the row value( $row->part) so that the session are activated...

thanks Gareth

[thorpe]

this is poor design. just store the values in mysql (if need be), then re instantiate the sessions with those variable. eg;

if ($result = mysql_query("SELECT sessionvals FROM sessions")) {
  session_start();
  $row = mysql_fetch_row($result);
  $_SESSION['part'][4] = $row[0]; 
  $_SESSION['part'][5] = $row[1]; 
  $_SESSION['part'][6] = $row[2];
}

there are better ways of storing sessions in a db, but as a newbie you might not want to go there as yet.

[garfx]

thanks Thorpe

but the session will change for each user... I need simple system to store all session data in one row and retrieve it at a later date... is there an easy solution?

G

[thorpe]

your best bet would be to use a custom sessions class, serialize it into a string, save the string into the db, and then retrieve it and unserialize it back into your sessions object.

have a look at the [man]session_set_save_handler[/man] for some examples of building your own sessions class.

I'm new to php and programming to be honest with you, so please keep it simple....

this is a fairly complex task, but thats the way i would do it.