Login   Register  
PHP Classes
elePHPant
Icontem

File: cached_mysql_query.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 9 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)
{
    ...
}

?>