I am trying to cache a database recordset so users can sort, etc without hitting the database everytime. I'm using ADODB to access a MSSQL database.
$s = "SELECT id, part, description FROM parts\n"; $r = $db->Execute($s);
$parts = array(id=>array(),part=>array(),desc=>array())
while(!$r->EOF){ array_push($parts['id'],$r->fields[0]); array_push($parts['part'],$r->fields[0]); array_push($parts['desc'],$r->fields[0]); $r->MoveNext(); }
// print_r($parts) displays array data. Here's what I'm doing:
$v = serialize($parts);
echo "<a href=\"{$_SERVER['PHP_SELF']}?getvar=$v\">Link</a>\n";
If($_GET['getvar']){
$newvar = unserialize($_GET['getvar']);
//This does nothing echo $newvar; print_r($newvar);
}
Am i missing something very simple?
You did not tell what is the problem, so I only guess - urlencode? Or the recordset exceeds allowed size for query string? (But I've once seen 3 or 4 EULAs in one link on microsofts site :))
Should I make the array a $_SESSION variable, or how do others "cache" a recordset?
I don't as it gives more trouble than help.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
