!! IMPORTANT !! HOW TO READ SESSION Data stored in the MySQL Tables

[manusahi]

Hi,
I am storing the session variables in the MySQL Tables. The session values are stored in the format shopSessID|s:32:"d948b85ebb1b1bad95119c2aee072cc1";subID|s:5:"False";

Please advise me how to read this format as in

ShopSessID = d948b85ebb1b1bad95119c2aee072cc1
subID = False

Thanks

[sweatje]

see the php manual for serialize and unserialize

[manusahi]

I have just written the simple code using the unserialize function

$variable='shopSessID|s:32:"f3ca21bf090e28b38ac5412d06a253ba";subID|s:5:"False";';
$session_Date=unserialize($variable);

--I am getting this error. Please tell me how to resolve this error and i am new to serialize and unserialize functions

Error :
Notice: unserialize() [function.unserialize]: Error at offset 0 of 68 bytes in ******* on line 3

Thanks,

[Phil.Roberts]

The serialised data comes after the "shopSessID|" and "subID|" bits.

[Phil.Roberts]

<?php

$string = 'shopSessID|s:32:"d948b85ebb1b1bad95119c2aee072cc1";subID|s:5:"False";';

$var_pairs = explode(';', $string);

foreach($var_pairs as $var) {
    list($k, $v) = explode('|', $var);
    if(!empty($k)) {
        $sess_array[$k] = unserialize($v);
    }
}

print_r($sess_array);

?>