README

MeekroDB 是一个mysqli包装PHP 5.3+分支（文件大小更小）

设置

Composer

如果你使用composer，则将 ronisaha/meekro4php5.3 添加为依赖项

composer require ronisaha/meekro4php5.3

在这种情况下，你需要在源文件顶部包含composer的自动加载器

<?php
require __DIR__ . '/vendor/autoload.php';

手动

如果你没有composer，只需下载代码并包含 autoload.php

git clone https://github.com/ronisaha/meekrodb

<?php
require __DIR__ . '/meekrodb/autoload.php';

配置

use Meekro\DB;

DB::$user = 'my_database_user';
DB::$password = 'my_database_password';
DB::$dbName = 'my_database_name';

快速文档/示例

从数据库中获取一些行并打印每行的字段。

$accounts = DB::query("SELECT * FROM accounts WHERE type = %s AND age > %i", $type, 15);
foreach ($accounts as $account) {
  echo $account['username'] . "\n";
}

插入新行。

DB::insert('mytable', array(
  'name' => $name,
  'rank' => $rank,
  'location' => $location,
  'age' => $age,
  'intelligence' => $intelligence
));

获取一行或字段

$account = DB::row("SELECT * FROM accounts WHERE username=%s", 'Joe');
$number_accounts = DB::field("SELECT COUNT(*) FROM accounts");

在查询中使用列表

DB::query("SELECT * FROM tbl WHERE name IN %ls AND age NOT IN %li", array('John', 'Bob'), array(12, 15));

嵌套事务

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

更多内容 - 查看：http://www.meekro.com/docs.php