PHPackages                             haoa/mix-database - 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. haoa/mix-database

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

haoa/mix-database
=================

v2.0.9(2mo ago)0381PHPPHP >=7.2.0

Since Jul 29Pushed 2mo agoCompare

[ Source](https://github.com/hao-php/mix-database)[ Packagist](https://packagist.org/packages/haoa/mix-database)[ RSS](/packages/haoa-mix-database/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependencies (5)Versions (18)Used By (1)

Installation
------------

[](#installation)

```
composer require haoa/mix-database

```

Quick start
-----------

[](#quick-start)

注意：[协程环境中，不可在并发请求中使用单例](https://openmix.org/mix-php/docs/3.0/#/zh-cn/instructions?id=%e5%8d%8f%e7%a8%8b%e5%8d%95%e4%be%8b%e5%ae%9e%e4%be%8b%e5%8c%96)

```
$db = new Haoa\MixDatabase\Database('mysql:host=127.0.0.1;port=3306;charset=utf8;dbname=test', 'username', 'password');
```

创建

```
$db->insert('users', [
    'name' => 'foo',
    'balance' => 0,
]);
```

查询

```
$db->table('users')->where('id = ?', 1)->first();
```

更新

```
$db->table('users')->where('id = ?', 1)->update('name', 'foo1');
```

删除

```
$db->table('users')->where('id = ?', 1)->delete();
```

启动连接池 Pool
----------

[](#启动连接池-pool)

在 `Swoole` 协程环境中，启动连接池

```
$maxOpen = 50;        // 最大开启连接数
$maxIdle = 20;        // 最大闲置连接数
$maxLifetime = 3600;  // 连接的最长生命周期
$waitTimeout = 0.0;   // 从池获取连接等待的时间, 0为一直等待
$db->startPool($maxOpen, $maxIdle, $maxLifetime, $waitTimeout);
Swoole\Runtime::enableCoroutine(); // 必须放到最后，防止触发协程调度导致异常
```

连接池统计

```
$db->poolStats(); // array, fields: total, idle, active
```

创建 Insert
---------

[](#创建-insert)

创建

```
$data = [
    'name' => 'foo',
    'balance' => 0,
];
$db->insert('users', $data);
```

获取 InsertId

```
$data = [
    'name' => 'foo',
    'balance' => 0,
];
$insertId = $db->insert('users', $data)->lastInsertId();
```

替换创建

```
$data = [
    'name' => 'foo',
    'balance' => 0,
];
$db->insert('users', $data, 'REPLACE INTO');
```

批量创建

```
$data = [
    [
        'name' => 'foo',
        'balance' => 0,
    ],
    [
        'name' => 'foo1',
        'balance' => 0,
    ]
];
$db->batchInsert('users', $data);
```

使用函数创建

```
$data = [
    'name' => 'foo',
    'balance' => 0,
    'add_time' => new Mix\Database\Expr('CURRENT_TIMESTAMP()'),
];
$db->insert('users', $data);
```

查询 Select
---------

[](#查询-select)

### 获取结果

[](#获取结果)

方法名称描述get(): array获取多行first(): array or object获取第一行value(string $field): mixed获取第一行某个字段statement(): \\PDOStatement获取原始结果集### Where

[](#where)

#### AND

[](#and)

```
$db->table('users')->where('id = ? AND name = ?', 1, 'foo')->get();
```

```
$db->table('users')->where('id = ?', 1)->where('name = ?', 'foo')->get();
```

#### OR

[](#or)

```
$db->table('users')->where('id = ? OR id = ?', 1, 2)->get();
```

```
$db->table('users')->where('id = ?', 1)->or('id = ?', 2)->get();
```

#### IN

[](#in)

```
$db->table('users')->where('id IN (?)', [1, 2])->get();
```

```
$db->table('users')->where('id NOT IN (?)', [1, 2])->get();
```

### Select

[](#select)

```
$db->table('users')->select('id, name')->get();
```

```
$db->table('users')->select('id', 'name')->get();
```

```
$db->table('users')->select('name AS n')->get();
```

### Order

[](#order)

```
$db->table('users')->order('id', 'desc')->get();
```

```
$db->table('users')->order('id', 'desc')->order('name', 'asc')->get();
```

### Limit

[](#limit)

```
$db->table('users')->limit(5)->get();
```

```
$db->table('users')->offset(10)->limit(5)->get();
```

### Group & Having

[](#group--having)

```
$db->table('news')->select('uid, COUNT(*) AS total')->group('uid')->having('COUNT(*) > ?', 0)->get();
```

```
$db->table('news')->select('uid, COUNT(*) AS total')->group('uid')->having('COUNT(*) > ? AND COUNT(*) < ?', 0, 10)->get();
```

### Join

[](#join)

```
$db->table('news AS n')->select('n.*, u.name')->join('users AS u', 'n.uid = u.id')->get();
```

```
$db->table('news AS n')->select('n.*, u.name')->leftJoin('users AS u', 'n.uid = u.id AND u.balance > ?', 10)->get();
```

更新 Update
---------

[](#更新-update)

更新单个字段

```
$db->table('users')->where('id = ?', 1)->update('name', 'foo1');
```

获取影响行数

```
$rowsAffected = $db->table('users')->where('id = ?', 1)->update('name', 'foo1')->rowCount();
```

更新多个字段

```
$data = [
    'name' => 'foo1',
    'balance' => 100,
];
$db->table('users')->where('id = ?', 1)->updates($data);
```

使用表达式更新

```
$db->table('users')->where('id = ?', 1)->update('balance', new Mix\Database\Expr('balance + ?', 1));
```

```
$data = [
    'balance' => new Mix\Database\Expr('balance + ?', 1),
];
$db->table('users')->where('id = ?', 1)->updates($data);
```

使用函数更新

```
$db->table('users')->where('id = ?', 1)->update('add_time', new Mix\Database\Expr('CURRENT_TIMESTAMP()'));
```

```
$data = [
    'add_time' => new Mix\Database\Expr('CURRENT_TIMESTAMP()'),
];
$db->table('users')->where('id = ?', 1)->updates($data);
```

删除 Delete
---------

[](#删除-delete)

删除

```
$db->table('users')->where('id = ?', 1)->delete();
```

获取影响行数

```
$rowsAffected = $db->table('users')->where('id = ?', 1)->delete()->rowCount();
```

原生 Raw
------

[](#原生-raw)

```
$db->raw('SELECT * FROM users WHERE id = ?', 1)->first();
```

```
$db->exec('DELETE FROM users WHERE id = ?', 1)->rowCount();
```

事务 Transaction
--------------

[](#事务-transaction)

手动事务

```
$tx = $db->beginTransaction();
try {
    $data = [
        'name' => 'foo',
        'balance' => 0,
    ];
    $tx->insert('users', $data);
    $tx->commit();
} catch (\Throwable $ex) {
    $tx->rollback();
    throw $ex;
}
```

自动事务，执行异常自动回滚并抛出异常

```
$db->transaction(function (Mix\Database\Transaction $tx) {
    $data = [
        'name' => 'foo',
        'balance' => 0,
    ];
    $tx->insert('users', $data);
});
```

调试 Debug
--------

[](#调试-debug)

```
$db->debug(function (Mix\Database\ConnectionInterface $conn) {
        var_dump($conn->queryLog()); // array, fields: time, sql, bindings
    })
    ->table('users')
    ->where('id = ?', 1)
    ->get();
```

日志 Logger
---------

[](#日志-logger)

日志记录器，配置后可打印全部SQL信息

```
$db->setLogger($logger);
```

`$logger` 需实现 `Mix\Database\LoggerInterface`

```
interface LoggerInterface
{
    public function trace(float $time, string $sql, array $bindings, int $rowCount, ?\Throwable $exception): void;
}
```

License
-------

[](#license)

Apache License Version 2.0,

###  Health Score

40

—

FairBetter than 88% of packages

Maintenance88

Actively maintained with recent releases

Popularity10

Limited adoption so far

Community13

Small or concentrated contributor base

Maturity43

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 78.5% 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 ~37 days

Recently: every ~0 days

Total

17

Last Release

61d ago

Major Versions

v1.0.6 → v2.0.02026-03-11

### Community

Maintainers

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

---

Top Contributors

[![onanying](https://avatars.githubusercontent.com/u/16074765?v=4)](https://github.com/onanying "onanying (153 commits)")[![quhaowk](https://avatars.githubusercontent.com/u/42995157?v=4)](https://github.com/quhaowk "quhaowk (38 commits)")[![cexll](https://avatars.githubusercontent.com/u/26520956?v=4)](https://github.com/cexll "cexll (3 commits)")[![NHZEX](https://avatars.githubusercontent.com/u/14545600?v=4)](https://github.com/NHZEX "NHZEX (1 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/haoa-mix-database/health.svg)

```
[![Health](https://phpackages.com/badges/haoa-mix-database/health.svg)](https://phpackages.com/packages/haoa-mix-database)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90440.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)[wildside/userstamps

Laravel Userstamps provides an Eloquent trait which automatically maintains `created\_by` and `updated\_by` columns on your model, populated by the currently authenticated user in your application.

7511.7M13](/packages/wildside-userstamps)

PHPackages © 2026

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