Can store query result in $_SESSION

qadeer_ahmad

Hi,

i need to store Query result in $_SESSION my script is..

<?
$sql="SELECT * from PageName";
$result=mysql_query($sql);
$result=$_SESSION["result"];
print_r($result);
?>

remember my query working in this page i use query in this page like this..

<?
while($row=mysql_fetch_array($result))
{
print $row["Page"];
}
?>

in this page it working the result of print_r($result) in this page is "Resource id #9" i think thier nothing store and so i get nothing on anyother page.....

yes in the way if i give session value like this

<?
$row=mysql_fetch_array($result);
$_SESSION["result"]=$row;
?>
yes now some velues store in session but how i use these value in while loop.....?????

jonno946

you should be able to serialize the array into a byte-stream, store that in your session, and then unserialize the value when needed on other pages.

Jonno

Shrike

Some types of data can not be serialized thus stored in sessions. It includes resource variables or objects with circular references (i.e. objects which passes a reference to itself to another object).

This includes recordsets, filehandles etc.

rehfeld

Originally posted by qadeer_ahmad

yes now some velues store in session but how i use these value in while loop.....?????

use a loop

foreach() is prob easiest


foreach ($_SESSION['stored_array'] as $row) {
    // do something
}