通过 
搜索
搜索jasny / db-mysql
此包已被弃用，不再维护。没有建议的替代包。
PHP用于MySQL的简单数据库层
v1.1.1
2013-01-09 00:39 UTC
Requires
- php: >=5.3.0
Suggests
- jasny/config: Configure your DB and make it work out of the box
- jasny/dbquery-mysql: Supports building, parsing and modifying MySQL queries
This package is auto-updated.
Last update: 2020-09-11 11:05:46 UTC
README
PHP用于MySQL的简单数据库层，具有以下特性：
- 全局连接（单例模式）
- 参数绑定
- 引用表/字段和值
- 获取所有行、列、键/值对和单个值
- 通过传递关联数组进行简单保存
- 查询异常（而不是返回false）
安装
Jasny DB-MySQL已在packagist上注册为jasny/db-mysql，可以使用composer轻松安装。或者，您可以简单地下载.zip文件并从“src”文件夹中复制文件。
示例
<?php
new DB($host, $user, $pwd, $dbname);
$result = DB::conn()->query("SELECT * FROM foo");
$result = DB::conn()->query("SELECT * FROM foo WHERE type = ?", $type);
$result = DB::conn()->query("SELECT * FROM foo WHERE type = ? AND cat IN ?", $type, array(1, 7));
$items = DB::conn()->fetchAll("SELECT id, name, description FROM foo WHERE type = ?", MYSQLI_ASSOC, $type);
$item = DB::conn()->fetchOne("SELECT * FROM foo WHERE id = ?", MYSQLI_ASSOC, $id);
$names = DB::conn()->fetchColumn("SELECT name FROM foo WHERE type = ?", $type);
$list = DB::conn()->fetchPairs("SELECT id, name FROM foo WHERE type = ?", $type);
$name = DB::conn()->fetchValue("SELECT name FROM foo WHERE id = ?", $id);
DB::conn()->save('foo', $values);
DB::conn()->save('foo', array($values1, $values2, $values3));