ezSQL cache test case

cache_test_case.php

<?php

    // Standard ezSQL Libs
    include_once "shared/ez_sql_core.php";
    include_once "mysql/ez_sql_mysql.php";
    
    // Initialise singleton
    $db = new ezSQL_mysql('db_user', 'db_pass', 'db_name');
    
    // Cache expiry
    $db->cache_timeout = 1; // 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!
        $results = $db->get_results("SELECT SLEEP(10)");
        print_r($results);
        //$db->debug();
        
?>