Location: PHPKode > scripts > ezSQL > ezsql-1-26/mysql/disk_cache_example.php
<?php

	// Standard ezSQL Libs
	include_once "../shared/ez_sql_core.php";
	include_once "ez_sql_mysql.php";

	// Initialise singleton
	$db = new ezSQL_mysql('db_user', 'db_pass', 'db_name');

	// Cache expiry
	$db->cache_timeout = 24; // Note: this is hours

	// Specify a cache dir. Path is taken from calling script
	$db->cache_dir = 'ezsql_cache';

	// (1. You must create this dir. first!)
	// (2. Might need to do chmod 775)

	// Global override setting to turn disc caching off
	// (but not on)
	$db->use_disk_cache = true;

	// By wrapping up queries you can ensure that the default
	// is NOT to cache unless specified
	$db->cache_queries = true;

		// At last.. a query!
		$db->get_results("SHOW TABLES");
		$db->debug();

		// Select * from use
		$db->get_results("SELECT * FROM User");
		$db->debug();

	// This ensures only the above querys are cached
	$db->cache_queries = false;

	// This query is NOT cached
	$db->get_results("SELECT * FROM User LIMIT 0,1");
	$db->debug();

/*

	Of course, if you want to cache EVERYTHING just do..

	$db = new ezSQL_mysql('db_user', 'db_pass', 'db_name');
	$db->use_disk_cache = true;
	$db->cache_queries = true;
	$db->cache_timeout = 24;

*/

?>
Return current item: ezSQL