i was just trying the new DBMS , herd it was kinda faster than MySql in some case.
the below is the code i have taken (Standard example) and still i am getting error.
<?php
// create new database (OO interface)
$db = new SQLiteDatabase("db.sqlite");
// 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);
?>
The error is something like this
Fatal error: Class 'SQLiteDatabase' not found in C:\wamp\www\db\db2.php on line 4
i have no idea on how to make this stuff work , i would be glad if u guys could help me out.