[how-to] Cache some table

[Adrian Schneider]

Query it, create a serialized version of the resultset, then insert that into a new datastore column.

Place the colum name in the $specialtemplates array in your script (and unserialize) and you won't have to query for it every time.

[Milad]

THank you
This is exactly what I want
But can you gice a php example?

[Adrian Schneider]

wrote this real quick

PHP Code:

// Preparing
$eggnog = $db->query_read("
    SELECT *
    FROM stuff
    ORDER BY stuffName ASC
");

$allNogs = array();
while ($nog = $db->fetch_array($eggnog))
{
    $allNogs[] = $nog;
}

$serialized = serialize($allNogs);

$db->query_write("
    UPDATE " . TABLE_PREFIX . "datastore
    SET data = '" . $db->escape_string($serialized) . "'
    WHERE title = 'nog'
");

// Usage

$specialtemplates = array(
    'nog'
);

require_once('./global.php');

//$vbulletin->nog now contains serialized array

$vbulletin->nog = unserialize($vbulletin->nog); 


[Milad]

Thank you very much.

Originally Posted by SirAdrian

PHP Code:

$db->query_write("
    UPDATE " . TABLE_PREFIX . "datastore
    SET data = '" . $db->escape_string($serialized) . "'
    WHERE title = 'nog'
"); 


I think we can use build_datastore instead of this query