PHP Classes

File: cached_mysql_query.php

Recommend this page to a friend!
  Classes of V. Yanson   RS Cache   cached_mysql_query.php   Download  
File: cached_mysql_query.php
Role: Example script
Content type: text/plain
Description: Small script to show how you can implement the rscache class to cache mysql queries. Should only be implemented with SELECT queries.
Class: RS Cache
Store and retrieve variables from cache files
Author: By
Last change:
Date: 19 years ago
Size: 581 bytes
 

Contents

Class file image Download
<?php

include_once("cache.php");

function cached_mysql_query($db, $query)
{
    $cache = new cache();
    $return = array();
   
    $uid = md5($query);
   
    $ret = $cahce->get($uid);
    if (!$ret)
    {
        $q = mysql_query($query, $db);
        while ($p = mysql_fetch_array($q))
        {
            foreach ($p as $n => $v)
            {
                if (!is_numeric($n)) $return[$n] = $v;
            }
        }
       
        $cache->save($uid, $return);
    }
   
    return $return;
}

$db = mysql_connect(...);
mysql_select_db(...);
foreach (cached_mysql_query(& $db, "select * from ... where ...") as $n => $v)
{
    ...
}

?>