<?php
/* open connection to memory database */
$db = new SQLiteDatabase(":memory:");
/* execute a regular query */
$db->query("CREATE TABLE test(a,b)");
$db->query("INSERT INTO test VALUES('1','2')");
/* retrieve data using an unbuffered query */
$r = $db->unbufferedQuery("SELECT * FROM test", SQLITE_ASSOC);
/* use object iterators to retrieve the data */
foreach ($r as $row) {
var_dump($row);
}
?>
Bundled with PHP 5 (including library)
Fast and easy interface to 'flatfiles'
Implements most of SQL92
Supports both OO and procedural API
No daemon required
Can use PHP to extend SQL language
