Abrir
<?php
require_once 'phpmoko/db/SQLite.php';
require_once 'phpmoko/db/SQLiteCommand.php';
require_once 'phpmoko/db/SQLiteDataResult.php';
$root = RootPanel::get();
// Sin parametros se crea en memoria
$sqlite = new SQLite();
$sql = 'CREATE TABLE IF NOT EXISTS [tabla] ([campo] INTEGER);';
$command = new SQLiteCommand($sql);
$sqlite->exec($command);
for ($i = 0; $i <= 100; $i++) {
$sql = 'INSERT INTO [tabla] ([campo]) VALUES({numero})';
$command = new SQLiteCommand($sql);
$command->setVariable('numero', rand(1, 100));
$sqlite->exec($command);
}
$sql = 'SELECT [campo] FROM [tabla] ORDER BY [campo];';
$command = new SQLiteCommand($sql);
$result = $sqlite->query($command);
while ($row = $result->fetchAssoc()) {
$root->add($row['campo'].' ');
}
echo $root->toString();
?>