http://www.meekro.com) API:http://www.meekro.com/docs.php
MeekroDB (MeekroDB is a mysqli wrapper PHP 5.3+ fork (smaller file size)
Setup
Composer
If you are using composer, then add ronisaha/meekro4php5.3
as a dependency:
composer require ronisaha/meekro4php5.3
In this case, you would include composer's auto-loader at the top of your source files:
<?php
require __DIR__ . '/vendor/autoload.php';
Manually
If you don't have composer available, then simply download the code and include autoload.php
:
git clone https://github.com/ronisaha/meekrodb
<?php
require __DIR__ . '/meekrodb/autoload.php';
Configuration
use Meekro\DB;
DB::$user = 'my_database_user';
DB::$password = 'my_database_password';
DB::$dbName = 'my_database_name';
Quick Doc / example
Grab some rows from the database and print out a field from each row.
$accounts = DB::query("SELECT * FROM accounts WHERE type = %s AND age > %i", $type, 15);
foreach ($accounts as $account) {
echo $account['username'] . "\n";
}
Insert a new row.
DB::insert('mytable', array(
'name' => $name,
'rank' => $rank,
'location' => $location,
'age' => $age,
'intelligence' => $intelligence
));
Grab one row or field
$account = DB::row("SELECT * FROM accounts WHERE username=%s", 'Joe');
$number_accounts = DB::field("SELECT COUNT(*) FROM accounts");
Use a list in a query
DB::query("SELECT * FROM tbl WHERE name IN %ls AND age NOT IN %li", array('John', 'Bob'), array(12, 15));
Nested Transactions
Config::$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