topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

server-webapi-code-04-timedCacheRelease.php / php



  <?php 
  db = new SQLiteDatabase("/tmp/11.timedcache.sqlite"); 
  db->query("BEGIN; 
    CREATE TABLE timedCache(id INTEGER PRIMARY KEY, cache BLOB, tstamp TEXT); 
    COMMIT;"); 
  function cacheIsRecent()
  {
    db = sqlite_open("/tmp/11.timedcache.sqlite"); 
    query = "SELECT tstamp FROM timedCache WHERE id = 1";
    result = sqlite_query(db, query);
    row = sqlite_fetch_array(result);
    if (time() - row['tstamp'] > (60 * 10))
    {
      return false; 
    }else
    {
       return true;
    }
  }
  
  function updateCache(body)
  {
    db = new SQLiteDatabase("/tmp/11.timedcache.sqlite"); 
    time = time();
    query = "REPLACE INTO timedCache (id, cache, tstamp) VALUES (1, 'body', 'time')";
    db->query("BEGIN; query; COMMIT;");
  }
  
  function getCache()
  {
    db = sqlite_open("/tmp/11.timedcache.sqlite"); 
    query = "SELECT cache FROM timedCache WHERE id = 1";
    result = sqlite_query(db, query);
    row = sqlite_fetch_array(result);
    return row['cache'];
  }
  
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.