<?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();
?>