|
|
|
|
|
|
Friday, March 12th, 2010
MySQL Cache Script |
|
|
|
|
|
. : : MySQL Cache Script |
|
|
This script cache's a variable or an array of variables for a specified amount of time in a MySQL table. Useful for pages that fetch data from other websites, so that you don't have to query the remote site every time you want data. Requires MySQL
 |
Explanations:
cache.php - The script page. Include it in the page you need caching with, then call its functions.
gpl.txt - A copy of the General Public License.
readme.txt - A quick readme file.
SQL.sql - The SQL table.
|
EXAMPLE:
<?
# Format:
# cache($id, $seconds, $data)
# $id is a unique indentifying string
# $seconds is the number of seconds you want to cache the data
# $data is what you want cached
include ("cache.php");
$cached = cache("animals");
if ($cached){ //CHECK IF IT'S ALREADY CACHED
$test = $cached;
echo "\n<br>CACHED DATA\n<br>";
}else{ //AQUIRE THE DATA, THEN CACHE IT
$test = array('turtle', "monkey", date("M j, Y", time()), "fish");
$cached = cache("animals", 60, $test); //CACHES FOR 60 SECONDS
echo "\n<br>FRESH DATA\n<br>";
} //DO WHATEVER TO THE DATA
//print_r(slash($test, 2));
print_r($test);
?>
-- DOWNLOAD --
742 Downloads To Date
LASTEST UPDATES:
December 31, 2005
Changed format, so now you specify the length of time to cache it for at the time of caching.
|
|
|
|
|
|
|
|
|
