PHPackages                             ova777/mysqli - 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. ova777/mysqli

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

ova777/mysqli
=============

MYSQLi extension library

v1.0.1(9y ago)025MITPHP

Since Aug 19Pushed 9y ago1 watchersCompare

[ Source](https://github.com/ova777/mysqli)[ Packagist](https://packagist.org/packages/ova777/mysqli)[ Docs](http://github.com/ova777/mysqli)[ RSS](/packages/ova777-mysqli/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependenciesVersions (3)Used By (0)

MYSQLi
======

[](#mysqli)

MYSQLi extension library

### 0. Установка

[](#0-установка)

```
composer require ova777/mysqli

```

После этого подключаем composer autoloader

```
require_once __DIR__.'/vendor/autoload.php';
```

### 1. Подключение к БД

[](#1-подключение-к-бд)

```
$db = new \ova777\MYSQLi\Connection('localhost', 'user', 'password', 'database');
```

### 2. Запросы на получение данных

[](#2-запросы-на-получение-данных)

```
//Все строки результата в виде массива ассоциативных массивов
$rows = $db->command('SELECT * FROM table')->queryAll();
//Первую строка результата в виде ассоциативного массива
$row = $db->command('SELECT * FROM table')->queryRow();
//Данные первой колонки результата
$column = $db->command('SELECT * FROM table')->queryColumn();
//Первый столбец первой колонки
$value = $db->command('SELECT * FROM table')->queryScalar();
```

### 3. Привязка значений к запросу

[](#3-привязка-значений-к-запросу)

```
//Один параметр
$rows = $db->command('SELECT * FROM table WHERE id=?')
    ->bind('i', 1)
    ->queryAll();

//Несколько параметров
$rows = $db->command('SELECT * FROM table WHERE id=? AND foo=?')
    ->bind('is', array(1, 'bar'))
    ->queryAll();
```

### 4. INSERT, UPDATE, DELETE запросы

[](#4-insert-update-delete-запросы)

```
$db->command('INSERT INTO table SET int_col=?, str_col=?')
    ->bind('is', array(1, 'foo'))
    ->execute();
```

### 5. Повторное использование подготовленных запросов

[](#5-повторное-использование-подготовленных-запросов)

```
//Полготавливаем запрос
$cmd = $db->command('INSERT INTO table SET a=?,b=?');
//Выполняем запросы
$cmd->bind('is', array(1, 'foo'))->execute();
$cmd->bind('is', array(2, 'bar'))->execute();
//При повторном вызове bind можно не передавать типы значений
$cmd->bind(array(3, 'xyz'))->execute();
...
$cmd->close();
```

###  Health Score

27

—

LowBetter than 49% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity64

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

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 ~9 days

Total

2

Last Release

3543d ago

### Community

Maintainers

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

---

Top Contributors

[![ovaunit](https://avatars.githubusercontent.com/u/8519980?v=4)](https://github.com/ovaunit "ovaunit (7 commits)")

---

Tags

mysqldbmysqli

### Embed Badge

![Health badge](/badges/ova777-mysqli/health.svg)

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

###  Alternatives

[aura/sqlquery

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

4572.9M34](/packages/aura-sqlquery)[envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

925511.7k13](/packages/envms-fluentpdo)[lichtner/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

921274.8k6](/packages/lichtner-fluentpdo)[fpdo/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

921244.9k7](/packages/fpdo-fluentpdo)[aplus/database

Aplus Framework Database Library

3331.6M7](/packages/aplus-database)[sergeytsalkov/meekrodb

The Simple PHP/MySQL Library

341387.0k10](/packages/sergeytsalkov-meekrodb)

PHPackages © 2026

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