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-memory.php / php



  <?php
  
  // create a new memory only database
  db = new SQLiteDatabase(":memory:");
  // Create a 2-column table bar & insert 2 rows into it
  /* For improved performance the entire query block is wrapped inside a transaction. */
  db->query("BEGIN;
          CREATE TABLE bar ( id INTEGER PRIMARY KEY, id2 );
          INSERT INTO bar (id2) VALUES(1);
          INSERT INTO bar (id2) VALUES(2);
          COMMIT;");
  // will print "2 insert queries"
  echo db->changes()." insert queries\n";
  // will print "last inserted row id: 2"
  echo "last inserted row id: ".db->lastInsertRowid();
  
  ?>
[] 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.