A simplified version of our query caching system

GeekCache_SimpleQuery.php

<?php
//=================================================================================================
class GeekCache_SimpleQuery extends GeekCache_TrackedCache
{	
	//==============================================================================================
	public function __construct( $query, $timelimit, $namespaces=array(), $filename = '' )
	{	
		if ( !$filename )
			$filename = 'query_' . md5( $query );
			
		$this->_query = $query;			
				
		return parent::__construct( $filename, $timelimit, $namespaces );
	}

	//==============================================================================================
	function GetRecords( $query, &$numitems=0, $debug=false, &$gotcache, $regen=false, $slave=false )
	{
			$dataobj = $this->get( $this->filename );

		if ( $dataobj != null  )
		{
			$dataobj = unserialize( $dataobj );
			$records  = &$dataobj->records;
			$numitems = $dataobj->numitems; 
		}
		else
		{
			$records  = $GLOBALS[$database]->GetRecords( $query );
			$countobj = $GLOBALS[$database]->GetRecord( "SELECT FOUND_ROWS() AS numitems" );
			$numitems = $countobj['numitems'];
				
			$newdataobj->records  = &$records;
			$newdataobj->numitems = $numitems;								
		
			$this->put( serialize( $newdataobj ) );
		}
		
		return $records;
	}
?>