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

professional-web-01-v1-watch.php / php



  <?php
  global HTTP_RAW_POST_DATA;
  if (!isset(HTTP_RAW_POST_DATA))
     HTTP_RAW_POST_DATA = file_get_contents("php://input");
  
  function openDb() {
    if (!db = new SQLiteDatabase("/tmp/db", 0666, sqliteerror)) {
      die(sqliteerror);
    }
    query = db->query("SELECT name FROM sqlite_master WHERE type='table'", SQLITE_NUM);
    result = query->fetchAll(SQLITE_NUM);
    tables = array();
    foreach (result as entry) {
         tables[]=entry[0];
    }
    if (!in_array("watches", tables)){
      db->queryExec("CREATE TABLE watches (title TEXT, description TEXT, symbol TEXT, tag TEXT, PRIMARY KEY ( symbol )) ");
    }
    return db;
  }
  
  function write() {
    global HTTP_RAW_POST_DATA;
    db=openDb();
    dom = new DOMDocument();
    dom->loadXML(HTTP_RAW_POST_DATA);
    if (!dom->relaxNGValidate ( 'watch.rng')) {
        die("unvalid document");
    }  
    xml = simplexml_import_dom(dom);
    foreach (xml->children() as element) {
      element['escaped'] = sqlite_escape_string(trim(element));
    }
    //echo xml->asXML();
    query = db->query(
      "SELECT symbol from watches where symbol='".
        xml->symbol['escaped'].
        "'", 
      SQLITE_NUM);
    req = "";
    if (query->fetch()) {
      req="update watches set ";
      req .= "tag='".xml->tag['escaped']."', ";
      req .= "title='".xml->title['escaped']."', ";
      req .= "description='".xml->description['escaped']."' ";
      req .= "where symbol='".xml->symbol['escaped']."'";
    } else {
      req="insert into watches (symbol, tag, title, description) values (";
      req .= "'".xml->symbol['escaped']."', ";
      req .= "'".xml->tag['escaped']."', ";
      req .= "'".xml->title['escaped']."', ";
      req .= "'".xml->description['escaped']."')";
    }
    //echo req;
    db->queryExec(req);
    echo "<ok/>";
  }
  
  function displayOne(row) {
    xml = simplexml_load_string("<watch><symbol/><tag/><title/><description/></watch>");
    xml->symbol=row['symbol'];
    xml->tag=row['tag'];
    xml->title=row['title'];
    xml->description=row['description'];
    asXML = xml->asXML();
    print substr(asXML, strpos(asXML, '<', 2));
  }
  
  function readOne() {
    db=openDb();
    query = db->query(
      "SELECT * from watches where symbol='".
        sqlite_escape_string(trim(_GET['name']))."'"
      , SQLITE_ASSOC);
    if (row = query->fetch(SQLITE_ASSOC)) {
      displayOne(row);
    } else {
      xml = simplexml_load_string("<watch/>");
      asXML = xml->asXML();
      print substr(asXML, strpos(asXML, '<', 2));
    }
  }
  
  function listAll() {
    db=openDb();
    echo "<watches>";
    query = db->query("SELECT * from watches order by symbol", SQLITE_ASSOC);
    while (row = query->fetch(SQLITE_ASSOC)) {
      displayOne(row);
    } 
    echo "</watches>";
  }
  
   header("Cache-Control: max-age=60");
   header("Content-type: application/xml");
   echo '<?xml version="1.0" encoding="utf-8"?>';
   if (strlen(HTTP_RAW_POST_DATA)>0) {
     write();
   } else if (_GET['name']) {
     readOne();
   } else {
     listAll();
   }
  ?>
[] 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.