MeekroDB (http://www.meekro.com) API:http://www.meekro.com/docs.php
MeekroDB is a one-liner mysqli wrapper PHP 5.4+ fork (smaller file size)
require_once 'db.class.php';
DB::$user = 'my_database_user';
DB::$password = 'my_database_password';
DB::$dbName = 'my_database_name';
//array
$accounts = DB::query("SELECT * FROM accounts WHERE type = %s AND age > %i", $type, 15);
foreach ($accounts as $account) {
echo $account['username'] . "\n";
}
//row
$account = DB::queryFirstRow("SELECT * FROM accounts WHERE username=%s", 'Joe');
//field
$number_accounts = DB::queryFirstField("SELECT COUNT(*) FROM accounts");
DB::insert('mytable', [
'name' => $name,
'rank' => $rank,
'location' => $location,
'age' => $age,
'intelligence' => $intelligence
]);
DB::query("INSERT INTO %b %lb VALUES %ll?", 'accounts',
['username', 'password', 'last_login_timestamp'],
[
['Joe', 'joes_password', new DateTime('yesterday')],
['Frank', 'franks_password', new DateTime('last Monday')]
]
);
DB::query("SELECT * FROM tbl WHERE name IN %ls AND age NOT IN %li", ['John', 'Bob'], [12, 15]);
DB::$nested_transactions = true;
DB::startTransaction(); // outer transaction
// .. some queries..
$depth = DB::startTransaction(); // inner transaction
echo $depth . 'transactions are currently active'; // 2
// .. some queries..
DB::commit(); // commit inner transaction
// .. some queries..
DB::commit(); // commit outer transaction