PHPackages                             qingbing/php-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. qingbing/php-database

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

qingbing/php-database
=====================

database 配置的设置和获取.

1.0.1(6y ago)015111MITPHP

Since Sep 25Pushed 6y agoCompare

[ Source](https://github.com/qingbing/php-database)[ Packagist](https://packagist.org/packages/qingbing/php-database)[ Docs](http://www.phpcorner.net)[ RSS](/packages/qingbing-php-database/feed)WikiDiscussions master Synced 5d ago

READMEChangelogDependencies (4)Versions (2)Used By (11)

php-database
============

[](#php-database)

描述
--

[](#描述)

Database 相关操作。可以单独使用。

注意事项
----

[](#注意事项)

- database的参数配置参考 qingbing/php-config 组件
- DB类为数据库连接器，并提供基础的db查询、
- Model类为数据表映射类

Db 使用方法
-------

[](#db-使用方法)

### 1. 获取db实例

[](#1-获取db实例)

```
// 单独使用，只有一个配置时使用方式
$db = \Db::getInstance('database');

// 配合后面的db-model
$db = Db::getInstance([
    'c-file' => 'database',
    'c-group' => 'master',
]);

```

### 2. 基础信息获取

[](#2-基础信息获取)

```
// 获取数据库的服务信息
$serverInfo = $db->getServerInfo();
var_dump($serverInfo);
// 获取数据库的版本信息
$serverVersion = $db->getServerVersion();
var_dump($serverVersion);
// 获取驱动的版本信息
$clientVersion = $db->getClientVersion();
var_dump($clientVersion);

```

### 3. sql语句操作

[](#3-sql语句操作)

```
// sql 插入语句范例
$sql = "INSERT INTO `{{stu}}` (`name`,`sex`) VALUES (:name,:sex)";
$res = $db->insertBySql($sql, [
    ':name' => 'name_12',
    ':sex' => 'sex_12',
]);
var_dump($res);
// sql 更新语句范例
$sql = "UPDATE `{{stu}}` SET `sex`=:sex WHERE id>=:bid AND id=:bid AND id:startId";
$res = $db->pagination($sql, [
    ':startId' => 2
], 2);
var_dump($res);

```

### 9. TableSchema 获取表结构信息

[](#9-tableschema-获取表结构信息)

```
// 获取表结构
$schema = $db->getTable('{{stu}}');
var_dump($schema);

```

====== 异常代码集合 ======
--------------------

[](#-异常代码集合-)

异常代码格式：1013 - XXX - XX （组件编号 - 文件编号 - 代码内异常）

```
 - 101300101 : 数据库连接串"dsn"不能为空
 - 101300102 : 数据库连接失败
 - 101300103 : PDO连接数据库失败
 - 101300104 : PDO连接库"{className}"不存在
 - 101300201 : "{type}"查询参数不完整
 - 101300301 : "{type}"查询参数不完整
 - 101300302 : "{type}"查询参数不完整
 - 101300401 : "{type}"查询参数不完整
 - 101300501 : Find查询必须带有"table"参数
 - 101300502 : "offset"必须和"limit"配对出现
 - 101300601 : "Transaction"尚属未激活状态，不能执行"commit"和"rollback"操作
 - 101300602 : "Transaction"尚属未激活状态，不能执行"commit"和"rollback"操作
 - 101300701 : pagination 构建参数"sqlment"无效

```

###  Health Score

28

—

LowBetter than 54% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity10

Limited adoption so far

Community14

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

 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

Unknown

Total

1

Last Release

2426d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/9379d2ee4885074de75faa3fa12970614186826f762df3c4aa0905dc1ff3b513?d=identicon)[qingbing](/maintainers/qingbing)

---

Top Contributors

[![qingbing](https://avatars.githubusercontent.com/u/33932784?v=4)](https://github.com/qingbing "qingbing (18 commits)")

---

Tags

phpdatabasedb

### Embed Badge

![Health badge](/badges/qingbing-php-database/health.svg)

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

###  Alternatives

[stefangabos/zebra_database

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

11812.0k](/packages/stefangabos-zebra-database)[tomatophp/filament-translations

Manage your translation with DB and cache, you can scan your languages tags like trans(), \_\_(), and get the string inside and translate them use UI.

6230.1k3](/packages/tomatophp-filament-translations)[jawira/db-draw

📐 Takes a DoctrineORM connection and generates a database diagram in .puml format

2295.1k2](/packages/jawira-db-draw)[webparking/laravel-db-rebuild

A laravel package that allows for quick database rebuilds with presets.

448.8k](/packages/webparking-laravel-db-rebuild)

PHPackages © 2026

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