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-php-sqlite-demo-object.php / php



    <?php
  
  // create new database (OO interface)
  db = new SQLiteDatabase("server-php-sqlite-demo.db");
  
  // create table foo and insert sample data
  db->query("BEGIN;
          CREATE TABLE foo(id INTEGER PRIMARY KEY, name CHAR(255));
          INSERT INTO foo (name) VALUES('Ilia');
          INSERT INTO foo (name) VALUES('Ilia2');
          INSERT INTO foo (name) VALUES('Ilia3');
          COMMIT;");
  
  // execute a query    
  result = db->query("SELECT * FROM foo");
  // iterate through the retrieved rows
  while (result->valid()) {
      // fetch current row
      row = result->current();     
      print_r(row);
  // proceed to next row
      result->next();
  }
  
  // not generally needed as PHP will destroy the connection
  unset(db);
  
  ?>
[] 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.