README

用于操作 PostgreSQL 数据库的类

##使用方法

创建数据库实例

$db = new Ikitiki\DB();

$db->setHost('127.0.0.1');
$db->setUsername('postgres');
$db->setDbName('test');

###执行查询

单行查询

$res = $db->execOne(
	"select id, name from users where email = '%s' and status_id = %d limit 1", 
	Ikitiki\DB::quote('john_doe@company.com'),
	1
);
// Executes "select id, email from users where email = 'john_doe@company.com' and status_id = 1"
// $res = [
//   'id' => 1,
//   'name' => 'John Doe'
// ];

键值查询

$res = $db->exec("select id, name from users")->fetchArray('id', 'name');
// $res = [
//   1 => 'John Doe',
//   2 => 'Richard Roe',
//   3 => 'Mark Moe',
//   ...
// ]

或

$res = $db->exec("select id, name, department_id from users")->fetchArray('id');
// $res = [
//   1 => ['name' => 'John Doe', 'department_id' => 1],
//   2 => ['name' => 'Richard Roe', 'department_id' => 1],
//   3 => ['name' => 'Mark Moe', 'department_id' => 2]
//   ...
// ];

###使用复杂数据类型

$res = $db->exec('select \'{"id":1,"name":"John Doe","department":"Sales"}\'::json as j from users')->fetchArray('j');
//$res = [
//  'id' => 1,
//  'name' => 'John Doe',
//  'department' => 'Sales',
//]

ikitiki/pgdb

维护者

详细信息

README