pwfoo / sqlite-dbintrd Goto Github PK

$ sudo apt-get update & apt-get upgrade
$ sudo apt-get install curl php-curl php-cli php-sqlite
$ curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer

"require": {
    "intrd/sqlite-dbintrd": ">=2.0.x-dev <dev-master"
}

$ composer install -o #to install
$ composer update -o #to update

Always use -o to rebuild autoload.

require __DIR__ . '/vendor/autoload.php';
use database\dbintrd as db;

$root=dirname(__FILE__)."/"; 
$db_path=$root.'vendor/intrd/sqlite-dbintrd/data/sample.dat'; //path of SQLite sample.dat (sample database included)
$debug=true; //enable SQL queries debug

/*
 * GET all data from table=users
 */
$users = new db("users","all"); 
var_dump($users); //print data

/*
 * GET all data from table=orders + CHILDS data
 */
$users = new db("orders","all",true); 
var_dump($users); //print data

/*
 * GET from tables=users, object where id=40, SET a different email and UPDATE
 */
$user = new db("users",40); 
$user->{0}->email="[email protected]"; 
var_dump($user); 
$user->save(true); 

/*
 * CREATE a fresh new object where table=users, SET a email and password and INSERT 
 */
$user = new db("users"); 
$user->email="[email protected]"; 
$user->password="123"; 
var_dump($user);
$user->save(); 

/*
 * GET a object from table=users filtering where [email protected]
 */
$users = new db("users","filter:email|[email protected]"); 
var_dump($users); 

/*
 * GET a object from table=users w/ combined filtering (following SQLite sintax)
 */
$users = new db("users","filter:email='[email protected]' and email='[email protected]'"); 
var_dump($users); //print data

/*
 * GET a object from table=orders filtering and returning CHILDS
 */
$orders = new db("orders","filter:qty|11",TRUE); 
var_dump($orders); 

/**
 * FULL CUSTOM SELECT (following SQLite sintax)
 */
$users = new db("users","custom:SELECT users.email FROM users WHERE id=40",false);