SQLLite PHP test

sqllite_example.php

<?php

# see https://bitbucket.org/lidio601/framework-fabio
# PHP Framework derived from Joomla CMS Libraries
require_once("framework_fabio.php");

$options = array(
	'driver' => 'sqllite',
	'file' => './dbfile.xmf'
);

$db = _getDBO($options);

if ($db) { 
	if( !$db->tableExists('foo') ) {
    $db->setQuery('CREATE TABLE foo (bar varchar(10))');
    $db->query();
	}
  $db->setQuery("INSERT INTO foo VALUES ('fnord')");
  $db->query();
  $db->setQuery('select bar from foo');
  $result = $db->loadObjectList();
  print_r($result);; 
} else {
  print_r($db);
}

?>