Wallogit.com
2017 © Pedro Peláez
DB class for working with PostgreSQL
, (*1)
Class for working with PostgreSQL database, (*2)
Create db instance:, (*3)
$db = new Ikitiki\DB();
$db->setHost('127.0.0.1');
$db->setUsername('postgres');
$db->setDbName('test');
Single row query:, (*4)
$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'
// ];
Key-value queries:, (*5)
$res = $db->exec("select id, name from users")->fetchArray('id', 'name');
// $res = [
// 1 => 'John Doe',
// 2 => 'Richard Roe',
// 3 => 'Mark Moe',
// ...
// ]
or, (*6)
$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]
// ...
// ];
```php $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', //], (*7)
DB class for working with PostgreSQL
MIT
database postgresql db
DB class for working with PostgreSQL
MIT
database postgresql db