sqlite_cache.php

Ir a la documentación de este archivo.

<?php
class SqliteCache extends Cache
{
    protected $_db = null;
    
    public function __construct() 
    {
        $this->_db = sqlite_open(APP_PATH . 'temp/cache.db');
        $result = sqlite_query($this->_db, "SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name='cache' ");
        $count = sqlite_fetch_single($result);
       
        if(!$count) {
            sqlite_exec($this->_db, ' CREATE TABLE cache (id TEXT, "group" TEXT, value TEXT, lifetime TEXT) ');
        }
        
        return $this->_db;
    }
    
        public function get($id, $group='default') 
    {
        $this->_id = $id;
        $this->_group = $group;
    
        $id = addslashes($id);
        $group = addslashes($group);
        
        $id = addslashes($id);
        $group = addslashes($group);
        $lifetime = time();
        
        $result = sqlite_query($this->_db, " SELECT value FROM cache WHERE id='$id' AND \"group\"='$group' AND lifetime>'$lifetime' OR lifetime='undefined' ");
        return sqlite_fetch_single($result);
    }
    
        public function save($value, $lifetime=null, $id=false, $group='default')
    {
        if (! $id) {
            $id = $this->_id;
            $group = $this->_group;
        }
        
        if ($lifetime) {
            $lifetime = strtotime($lifetime);
        } else {
            $lifetime = 'undefined';
        }
        
        $id = addslashes($id);
        $group = addslashes($group);
        $value = addslashes($value);
        
        $result = sqlite_query($this->_db, " SELECT COUNT(*) FROM cache WHERE id='$id' AND \"group\"='$group' ");
        $count = sqlite_fetch_single($result);
        
        
        // Ya existe el elemento cacheado
        if($count) {
            return sqlite_exec($this->_db, " UPDATE cache SET value='$value', lifetime='$lifetime' WHERE id='$id' AND \"group\"='$group' ");
        }
        
        return sqlite_exec($this->_db, " INSERT INTO cache (id, \"group\", value, lifetime) VALUES ('$id','$group','$value','$lifetime') ");
    }
    
        public function clean($group=false)
    {
        if($group) {
            $group = addslashes($group);
            return sqlite_exec($this->_db, " DELETE FROM cache WHERE \"group\"='$group' ");
        }
        return sqlite_exec($this->_db, " DELETE FROM cache ");
    }
    
        public function remove($id, $group='default')
    {
        $id = addslashes($id);
        $group = addslashes($group);
        
        return sqlite_exec($this->_db, " DELETE FROM cache WHERE id='$id' AND \"group\"='$group' ");
    }
}