Example #1
0
{
    function __construct()
    {
        $this->open(dirname(__FILE__) . '/test.db');
    }
    /**a wrapper method for executing a query*/
    public function executeSQL($query)
    {
        $result = $this->query($query);
        return $result;
    }
}
$d = new Delegate();
$qCreate = <<<EOQ
CREATE TABLE `entry` (
`id` INTEGER PRIMARY KEY,
`title` VARCHAR(255),
`description` TEXT
);
EOQ;
#$d->executeSQL($qCreate);
for ($i = 0; $i < 10; $i++) {
    $qAdd = sprintf("insert into `entry` (title, description) values ('%s','%s') ", uniqid(), uniqid());
    $d->executeSQL($qAdd);
}
$qGet = sprintf("select * from entry limit 0, 10");
$result = $d->executeSQL($qGet);
while ($row = $result->fetchArray()) {
    print_r($row);
}
$d->close();