README

此包已被废弃。考虑升级到 bentools/simple-dbal，它也可以处理 PDO 和 Mysqli 连接，并且更倾向于组合而非继承。

MySqli 扩展

更好的 PHP MySqli 体验。

快捷方式

BenTools\MySqliExtended\MySqliExtended 是 \MySqli 的子类。它具有几个快捷方法来获取数据

• sqlArray() -> 获取多维数组，基本上是表中的多行。
• sqlRow() -> 获取关联数组，例如一行。
• sqlColumn() -> 获取第一个列作为索引数组。
• sqlValue() -> 获取特定值。

$cnx = new MySqliExtended();
$cnx->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5);

$cnx->real_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);

$query = "SELECT 'Bill' AS firstname, 'Gates' AS lastname UNION SELECT 'Tim' AS firstname, 'Cook' AS lastname";
$result = $cnx->sqlArray($query);

Output:
array (
  0 => 
  array (
    'firstname' => 'Bill',
    'lastname' => 'Gates',
  ),
  1 => 
  array (
    'firstname' => 'Tim',
    'lastname' => 'Cook',
  ),
)


$result = $cnx->sqlRow($query);
Output:
array (
  'firstname' => 'Bill',
  'lastname' => 'Gates',
)


$result = $cnx->sqlColumn($query);
Output:
array (
  0 => 'Bill',
  1 => 'Tim',
)


$result = $cnx->sqlValue($query);
Output:
'Bill'

预处理语句

与预处理语句一起工作现在比以前更容易

// Before :
$query = "INSERT INTO `ceo` (firstname, lastname, years_in_company) VALUES (?, ?, ?)";
$stmt = $cnx->prepare($query);
$firstname = 'Larry';
$lastname = 'Page';
$years_in_company = 12;
$stmt->bind_param('ssi', $firstname, $lastname, $years_in_company);
$stmt->execute();

// Now :
$stmt = $cnx->prepare($query);
$stmt->sql(array(
    'Larry',
    'Page',
    12
));

// or directly :
$cnx->sql($query, array(
    'Larry',
    'Page',
    12
));

// or very shortly :
$cnx($query, array(
    'Larry',
    'Page',
    12
));

您不再需要创建变量、创建引用和创建奇怪的类型提示字符串，即 'ssi'。

您还可以使用 命名参数（如 PDO），您可以在同一个查询中重复使用这些参数

$query = "INSERT INTO `ceo` (firstname, lastname, years_in_company) VALUES (:firstname, :lastname, :years_in_company) ON DUPLICATE KEY UPDATE years_in_company = :years_in_company";
$cnx->sql($query, array(
    'firstname' => 'Larry',
    'lastname' => 'Page',
    'years_in_company' => 12
));

轻松处理 预处理语句。

$query = "SELECT firstname, lastname FROM `ceo` WHERE firstname LIKE ?";
$result = $cnx($query)->sqlRow('bill%');

Ouput :
array (
  'firstname' => 'Bill',
  'lastname' => 'Gates',
)

$result = $cnx($query)->sqlRow('larry%');

Ouput :
array (
  'firstname' => 'Larry',
  'lastname' => 'Page',
)

$query = "SELECT firstname, lastname FROM `ceo` WHERE (firstname LIKE :firstname OR years_in_company > :years)";
$result = $cnx($query)->sqlArray(array(
    'firstname' => 'larry%',
    'years'      => 10
));

Output:
array (
  0 => 
  array (
    'firstname' => 'Bill',
    'lastname' => 'Gates',
  ),
  1 => 
  array (
    'firstname' => 'Tim',
    'lastname' => 'Cook',
  ),
  2 => 
  array (
    'firstname' => 'Larry',
    'lastname' => 'Page',
  ),
)

安装

将以下行添加到您的 composer.json 中

{
    "require": {
        "bentools/mysqliextended": "1.0.x"
    }
}  

享受。