save mysql resultset for cache

[Steffel]

for a big web page with about 600 database queties i try to cache the result of a query in the user-session, so that the next time the user call this page the results are cached allready
the parameters $sql and $class are given

my code is like:

if (isset($_SESSION["ses_cache_hash"][$class][$sql]))
    return $_SESSION["ses_cache_hash"][$class][$sql];
else
    $result = mysql_query($sql);

if (!$result)
    be_dbi_fatal_error ($class . "Error executing query: " . be_dbi_error() . "\n\n<P>\n" . $sql);

// write resultset to cache
$_SESSION["ses_cache_hash"][$class][$sql] = $result;
return $result;

but when the result is cached the returnvalues are empty
plz help me how to get the correct resultset

regards,

steffel

[Sgarissta]

Originally posted by Steffel
for a big web page with about 600 database queties i try to cache the result of a query in the user-session, so that the next time the user call this page the results are cached allready
the parameters $sql and $class are given

my code is like:

if (isset($_SESSION["ses_cache_hash"][$class][$sql]))
    return $_SESSION["ses_cache_hash"][$class][$sql];
else
    $result = mysql_query($sql);

if (!$result)
    be_dbi_fatal_error ($class . "Error executing query: " . be_dbi_error() . "\n\n<P>\n" . $sql);

// write resultset to cache
$_SESSION["ses_cache_hash"][$class][$sql] = $result;
return $result;

but when the result is cached the returnvalues are empty
plz help me how to get the correct resultset

regards,

steffel [/B]

I think the issue is that the $result value is closer to a resource than a result. Your best bet is to go ahead and turn the resultset into an array, then serialize the array and put it in the session.

[Steffel]

hmm, yeah, you are right, but isn't it possible to save a resource in the session?