PHPackages                             colaphp/db - 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. colaphp/db

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

colaphp/db
==========

1.0.4(3y ago)048MITPHPPHP >=5.6

Since Jul 30Pushed 3y ago1 watchersCompare

[ Source](https://github.com/nydia87/colaphp-db)[ Packagist](https://packagist.org/packages/colaphp/db)[ RSS](/packages/colaphp-db/feed)WikiDiscussions main Synced 4d ago

READMEChangelogDependenciesVersions (6)Used By (0)

colaphp-db
==========

[](#colaphp-db)

配置部分，单独配置或读写分离配置
================

[](#配置部分单独配置或读写分离配置)

```
$config = [
	'driver'    => 'mysql',
	'host'      => '192.168.0.1',
	'database'  => 'test',
	'username'  => 'root',
	'password'  => 'root',
	'charset'   => 'utf8',
	'collation' => 'utf8_unicode_ci',
	'prefix'    => '',
];

$config2 = [
	'driver'    => 'mysql',
	'write'=>[
        'host'      => '192.168.0.1',
        'database'  => 'test',
        'username'  => 'root',
        'password'  => 'root',
	],
	'read'=>[
        'host'      => '192.168.0.2',
        'database'  => 'test',
        'username'  => 'root',
        'password'  => 'root',
	],
	'charset'   => 'utf8',
	'collation' => 'utf8_unicode_ci',
	'prefix'    => '',
];
```

创建对象
====

[](#创建对象)

```
    // 直接调用
	$dbFactory = new  \Colaphp\Db\Connectors\ConnectionFactory();
	$db = $dbFactory->make($config,'MYSQL');
    // 助手函数调用
	$db = getPDO('default.mysql',$config);
```

调试日志
====

[](#调试日志)

```
	//开启日志
	$db->enableQueryLog();
	//获取日志
	$db->getQueryLog();
```

增删改查
====

[](#增删改查)

```
	//查找一条记录
	$db->selectOne("select * from member where mobile = ?",['19812345678']);
	$db->selectOne("select * from member where mobile = :mobile",[':mobile'=>'19812345678']);
	//查找多条记录
	$db->select("select * from member where mobile = ?",['19812345678']);
	//插入
	$db->insert(
		"insert into member (`username`,`mobile`,`created_at`,`updated_at`) values (?, ?, NOW(), NOW());",
		['wang3','19812345678']
	);
	//修改
	$db->update(
		"update member set `created_at` = :created_at where id = :id",
		[ ':created_at' => date('Y-m-d H:i:s'), ':id'=>12 ]
	);
	//删除
	$db->delete("delete from member where id = ?", [16]);
	//exec操作
	$db->unprepared("delete from member where id = 17");
```

事务操作
====

[](#事务操作)

```
	//常规事务操作
	try{
		$db->beginTransaction();
		//事务数
		var_dump($db->transactionLevel());
		$db->update(
			"update member set `created_at` = :created_at where id = :id",
			[ ':created_at' => date('Y-m-d H:i:s'), ':id'=>13 ]
		);
		$db->insert(
			"insert into member (`username`,`mobile`,`created_at`,`updated_at`) values (?, ?, NOW(), NOW());",
			['wang','19812345678']
		);
		$db->commit();
	}catch(Exception $e){
		$db->rollBack();
		var_dump( $e->getMessage() );
	}

	// Closure事务
	$result = $db->transaction(function($me){
		$r1 = $me->update(
			"update member set `created_at` = :created_at where id = :id",
			[ ':created_at' => date('Y-m-d H:i:s'), ':id'=>13 ]
		);
		$r2 = $me->insert(
			"insert into member (`username`,`mobile`,`created_at`,`updated_at`) values (?, ?, NOW(), NOW());",
			['wang4','19812345678']
		);
		return $r1 .'~'. $r2;
	});
```

###  Health Score

23

—

LowBetter than 27% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity50

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

Every ~145 days

Total

5

Last Release

1171d ago

PHP version history (2 changes)1.0.0PHP >=5.6.40

1.0.2PHP >=5.6

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/11849800?v=4)[nydia87](/maintainers/nydia87)[@nydia87](https://github.com/nydia87)

---

Top Contributors

[![nydia87](https://avatars.githubusercontent.com/u/11849800?v=4)](https://github.com/nydia87 "nydia87 (6 commits)")

---

Tags

phpdbcolaphp

### Embed Badge

![Health badge](/badges/colaphp-db/health.svg)

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

###  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)[swoft/db

swoft database component

24167.4k11](/packages/swoft-db)[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)[simple-swoole/db

A db component for Simps.

216.3k3](/packages/simple-swoole-db)

PHPackages © 2026

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