PHPackages                             kansept/dbi - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. kansept/dbi

ActiveLibrary[Database & ORM](/categories/database)

kansept/dbi
===========

Wrapper class for MySQLi prepared statements

0.2(5y ago)0311MITPHPPHP >=5.5.0

Since Sep 20Pushed 5y ago1 watchersCompare

[ Source](https://github.com/Kansept/Dbi)[ Packagist](https://packagist.org/packages/kansept/dbi)[ RSS](/packages/kansept-dbi/feed)WikiDiscussions master Synced 4d ago

READMEChangelog (1)Dependencies (1)Versions (3)Used By (0)

kansept/dbi - MySQLi Wrapper
============================

[](#kanseptdbi---mysqli-wrapper)

Install
-------

[](#install)

### Composer

[](#composer)

```
composer require kansept/dbi

```

Then include or require the file in your php page.

```
require 'vendor/autoload.php';
```

Connection
----------

[](#connection)

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

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

Query
-----

[](#query)

### Select

[](#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

[](#insert)

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

### Update

[](#update)

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

### Delete

[](#delete)

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

Helpers
-------

[](#helpers)

### Generate UUID

[](#generate-uuid)

```
$db->uuid();
```

### LastId

[](#lastid)

Returns the auto generated id used in the latest query

```
$db->geLastId();
```

### Escape

[](#escape)

```
$db->escape();
```

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community5

Small or concentrated contributor base

Maturity40

Maturing project, gaining track record

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~80 days

Total

2

Last Release

1981d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/a0aea8ba7aae838d39efff63278bb964417fe7d0e83c8f9c25b376a41b06e02c?d=identicon)[Kansept](/maintainers/Kansept)

---

Tags

databasemysqlmysqliprepared

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/kansept-dbi/health.svg)

```
[![Health](https://phpackages.com/badges/kansept-dbi/health.svg)](https://phpackages.com/packages/kansept-dbi)
```

###  Alternatives

[sergeytsalkov/meekrodb

The Simple PHP/MySQL Library

341387.0k10](/packages/sergeytsalkov-meekrodb)[ezsql/ezsql

Advance database access library. Make interacting with a database ridiculously easy. An universal interchangeable CRUD system.

86946.7k](/packages/ezsql-ezsql)[websitebeaver/simple-mysqli

Wrapper class for MySQLi prepared statements

623.9k](/packages/websitebeaver-simple-mysqli)[stefangabos/zebra_database

An advanced, compact and lightweight MySQL database wrapper library, built around PHP's MySQLi extension.

11812.0k](/packages/stefangabos-zebra-database)[go/db

Database library

6624.1k](/packages/go-db)[krugozor/database

PHP class library for simple, convenient, fast and safe work with MySql database, using PHP mysqli extension and imitation of prepared queries.

392.5k](/packages/krugozor-database)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)