topical media & game development
server-php-sqlite-demo-object.php / php
<?php
// create new database (OO interface)
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
db->query("SELECT * FROM foo");
// iterate through the retrieved rows
while (row = row);
// proceed to next row
db);
?>
(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.