session serialize format

[John Smith]

Hi,
I am using a custom Session Handler.
session_set_sav e_handler is working well.

But i want to read the data direct from the database.
My problem:
php don't uses the standard serialize function:

For example:

print_r($_SESSI ON):

Array
(
[var1] => 12345
[var2] => Array
(
[ebene1] => e1
[ebene2] => e2
)

)
print_r($_SESSI ON); :

a:2:{s:4:"var1" ;s:5:"12345";s: 4:"var2";a:2:{s :6:"ebene1";s:2 :"e1";s:6:"eben e2";s:2:"e2"; }}

and the data in the database is:

var1|s:5:"12345 ";var2|a:2:{s:6 :"ebene1";s:2:" e1";s:6:"ebene2 ";s:2:"e2"; }:

Can anybody help me?
Anybody has an idea how to make an array from the database data?

Thanx John

[Pedro Graca]

John Smith wrote:

My problem:
php don't uses the standard serialize function:
????? What? :)

(snip) print_r($_SESSI ON); :
I guess you mean
echo serialize($_SES SION);
a:2:{s:4:"var1" ;s:5:"12345";s: 4:"var2";a:2:{s :6:"ebene1";s:2 :"e1";s:6:"eben e2";s:2:"e2"; }}

and the data in the database is:

var1|s:5:"12345 ";var2|a:2:{s:6 :"ebene1";s:2:" e1";s:6:"ebene2 ";s:2:"e2"; }:
This appears to have been put into the database with
<?php
$serial = '';
foreach ($_SESSION as $name=>$value)
$serial .= $name . '|' . serialize($valu e);
$sql = "insert ... values('$serial ')";
// ...
?>
Why don't you simply do:
<?php
$sql = "insert ... values('" . mysql_escape_st ring(serialize( $_SESSION)) . "')";
// ...
?>
Can anybody help me?
Anybody has an idea how to make an array from the database data?

Either serialize (and unserialize) the whole $_SESSION, or you're going
to have a hard time to parse the data in the database to repopulate the
$_SESSION array.
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[John Smith]

Pedro Graca wrote:

John Smith wrote:

a:2:{s:4:"var 1";s:5:"12345"; s:4:"var2";a:2: {s:6:"ebene1";s :2:"e1";s:6:"eb ene2";s:2:"e2"; }}

and the data in the database is:

var1|s:5:"123 45";var2|a:2:{s :6:"ebene1";s:2 :"e1";s:6:"eben e2";s:2:"e2"; }:

This appears to have been put into the database with
<?php
$serial = '';
foreach ($_SESSION as $name=>$value)
$serial .= $name . '|' . serialize($valu e);
$sql = "insert ... values('$serial ')";
// ...
?>
Why don't you simply do:
<?php
$sql = "insert ... values('" . mysql_escape_st ring(serialize( $_SESSION)) . "')";
// ...
?>

If am using session_set_sav e_handler.
http://www.php.net/session_set_save_handler

Php serializes the data, not my script.

The script only writes and reads the data form/to the database.

Ciao John

[Pedro Graca]

John Smith wrote:

If am using session_set_sav e_handler.

Php serializes the data, not my script.

The script only writes and reads the data form/to the database.

I had never looked at how the string is formatted by PHP before it
reaches the write function. My PHP formats it the same as yours.

I did a small script just to verify that that is right.

<?php
/* handler functions */
function OK($p1='', $p2='') { return true; }
function read($dummy) {
return 'var1|s:5:"1234 5";var2|a:2:{s: 6:"ebene1";s:2: "e1";s:6:"ebene 2";s:2:"e2";}:' ;
}
session_set_sav e_handler('OK', 'OK', 'read',
'OK', 'OK', 'OK');

/* *** */
session_start() ;
print_r($_SESSI ON);
?>

Works as expected with PHP 4.3.3.
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[Justin Koivisto]

John Smith wrote:

I am using a custom Session Handler.
session_set_sav e_handler is working well.

But i want to read the data direct from the database.

My problem:
php don't uses the standard serialize function:

For example:

print_r($_SESSI ON):

Array
(
[var1] => 12345
[var2] => Array
(
[ebene1] => e1
[ebene2] => e2
)

)

print_r($_SESSI ON); :
a:2:{s:4:"var1" ;s:5:"12345";s: 4:"var2";a:2:{s :6:"ebene1";s:2 :"e1";s:6:"eben e2";s:2:"e2"; }}

and the data in the database is:
var1|s:5:"12345 ";var2|a:2:{s:6 :"ebene1";s:2:" e1";s:6:"ebene2 ";s:2:"e2"; }:

Can anybody help me?
Anybody has an idea how to make an array from the database data?

Here are the basics of the functions that I use:

function sess_read($key) {
$query='SELECT value FROM psa_sessions WHERE sesskey=\''.
$key.'\' AND expiry > '.time();
}

function sess_write($key ,$val){
global $SESS_LIFE;
// Calculate the session end time
$expiry=time()+ $SESS_LIFE;
$query='SELECT sesskey FROM psa_sessions WHERE sesskey=\''.
$key.'\'';

// if exists
$query='UPDATE psa_sessions SET expiry='.$expir y.', value=\''.
$val.'\' WHERE sesskey=\''.$ke y.'\' AND expiry > '.time();
// if afected rows > 0
return strlen($val);
// else Session has expired
return FALSE;
// else
$query='INSERT INTO psa_sessions SET sesskey=\''.$ke y.
'\', expiry='.$expir y.', value=\''.$val. '\'';
return strlen($val);
}
session_set_sav e_handler('sess _open','sess_cl ose','sess_read ','sess_write', 'sess_destroy', 'sess_gc');

My handlers are all abstracted for Metabase and specific to a package I
wrote (with a lot of file-logging lines in it), so I think giving you
the entire session handler include file would be more confusing that
helpful.

--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.
SEO Competition League: http://seo.koivi.com/

[John Smith]

Justin Koivisto wrote:

Here are the basics of the functions that I use:

function sess_read($key) {
$query='SELECT value FROM psa_sessions WHERE sesskey=\''.
$key.'\' AND expiry > '.time();
}

function sess_write($key ,$val){
global $SESS_LIFE;
// Calculate the session end time
$expiry=time()+ $SESS_LIFE;
$query='SELECT sesskey FROM psa_sessions WHERE sesskey=\''.
$key.'\'';

// if exists
$query='UPDATE psa_sessions SET expiry='.$expir y.', value=\''.
$val.'\' WHERE sesskey=\''.$ke y.'\' AND expiry > '.time();
// if afected rows > 0
return strlen($val);
// else Session has expired
return FALSE;
// else
$query='INSERT INTO psa_sessions SET sesskey=\''.$ke y.
'\', expiry='.$expir y.', value=\''.$val. '\'';
return strlen($val);
}
session_set_sav e_handler('sess _open','sess_cl ose','sess_read ','sess_write', 'sess_destroy', 'sess_gc');

Thanx for your answer,
but that's not the problem.

I am seraching for a solution how to
turn the session string
var1|s:5:"12345 ";var2|a:2:{s:6 :"ebene1";s:2:" e1";s:6:"ebene2 ";s:2:"e2"; }:
to an array.
Standard serialize doesn't work.
Ciao John

[Chung Leong]

Uzytkownik "John Smith" <j.*****@gmx.de > napisal w wiadomosci
news:40******** *************** @newsread4.arco r-online.net...

Can anybody help me?
Anybody has an idea how to make an array from the database data?

I tried something like that once without success. The main problem is that
PHP doesn't escape the ';' in the serialization string, so you can't just do
an explode(';', ... ) to separate the string into name|serialized-string
pairs. Maybe we can first escape the semi-colons with slashes, then do a
preg_split with a lookbehind check...or write a char-by-char parser a la C.

for($i = 0, $l = strlen($s); $i < $l; $++) {
$c = $s{$i};
if(!$state) {
if($c == '|') {
$state = 1;
}
else {
$var_name .= $c;
}
}
else {
if($inside_stri ng) {
if($c == '\\') {
.... etc etc...
}
}
}
}

[R. Rajesh Jeba Anbiah]

John Smith <j.*****@gmx.de > wrote in message news:<40******* *************** *@newsread4.arc or-online.net>...

Hi,
I am using a custom Session Handler.
session_set_sav e_handler is working well.

But i want to read the data direct from the database.
My problem:
php don't uses the standard serialize function:

For example:

print_r($_SESSI ON):

Array
(
[var1] => 12345
[var2] => Array
(
[ebene1] => e1
[ebene2] => e2
)

)
print_r($_SESSI ON); :

a:2:{s:4:"var1" ;s:5:"12345";s: 4:"var2";a:2:{s :6:"ebene1";s:2 :"e1";s:6:"eben e2";s:2:"e2"; }}

and the data in the database is:

var1|s:5:"12345 ";var2|a:2:{s:6 :"ebene1";s:2:" e1";s:6:"ebene2 ";s:2:"e2"; }:

Can anybody help me?
Anybody has an idea how to make an array from the database data?

Unfortunately, nowadays vandals badly deletes some useful usernotes
from php.net <http://groups.google.c om/groups?selm=not e-23908%40php.net >
Fortunately, Google has archived this page. It is worth to note that
Google totally stopped archiving php.* groups.

--
"Success is not what you achieve, but it is what you die for"
If you live in USA, please support John Edwards.
Email: rrjanbiah-at-Y!com

[John Smith]

R. Rajesh Jeba Anbiah wrote:

print_r($_SES SION); :

a:2:{s:4:"var 1";s:5:"12345"; s:4:"var2";a:2: {s:6:"ebene1";s :2:"e1";s:6:"eb ene2";s:2:"e2"; }}

and the data in the database is:

var1|s:5:"123 45";var2|a:2:{s :6:"ebene1";s:2 :"e1";s:6:"eben e2";s:2:"e2"; }:

Can anybody help me?
Anybody has an idea how to make an array from the database data?

Unfortunately, nowadays vandals badly deletes some useful usernotes
from php.net <http://groups.google.c om/groups?selm=not e-23908%40php.net >
Fortunately, Google has archived this page. It is worth to note that
Google totally stopped archiving php.* groups.

Thanx, it's working.