kansept/dbi

Wrapper class for MySQLi prepared statements

0.2 2020-12-10 12:29 UTC

Requires

• php: >=5.5.0

Requires (Dev)

• phpunit/phpunit: ^4.8

MIT

• Vladimir Ka

• database
• mysql
• mysqli
• prepared

README

Install

Composer

composer require kansept/dbi

Then include or require the file in your php page.

require 'vendor/autoload.php';

Connection

$mysqli = new mysqli('localhost', 'user', 'password', 'db');
$mysqli->set_charset('UTF-8');

$db = new \Kansept\Dbi\Db($mysqli);

Query

Select

$db->exec("SELECT * FROM `demo` WHERE id = ?", [1])->row(); // return array
$db->exec("SELECT * FROM `demo`")->rows(); // return array

$db->exec("SELECT * FROM `demo` WHERE id = ?", [1])->one(); // return object
$db->exec("SELECT * FROM `demo`")->all(); // return object array

$db->exec("SELECT * FROM `demo`")->count(); // return count rows

$db->exec("SELECT * FROM `demo`")->yield(); // return yield

Insert

$db->insert('demo', ['name' => 'Joe', 'value' => 7]); // return bool
// INSERT INTO `demo` (`name`, 'value') VALUE('Joe', 7)

Update

$db->update('demo', ['name' => 'Joe', 'value' => 7], ['id' => 1]); // return bool
// UPDATE SET `name` = 'Joe', 'value' => 7 WHERE id = 1;

Delete

$db->delete('demo', ['id' => 1]); // return bool
// DELETE FROM demo WHERE id = 1;

Helpers

Generate UUID

$db->uuid();

LastId

Returns the auto generated id used in the latest query

$db->geLastId();

Escape

$db->escape();