PHPackages                             szjcomo/phpmysqli - 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. szjcomo/phpmysqli

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

szjcomo/phpmysqli
=================

swoole 的 mysqli客户端

v0.0.10(6y ago)1951MITPHPPHP >=7.1.0

Since Oct 23Pushed 6y ago1 watchersCompare

[ Source](https://github.com/szjcomo/phpmysqli)[ Packagist](https://packagist.org/packages/szjcomo/phpmysqli)[ RSS](/packages/szjcomo-phpmysqli/feed)WikiDiscussions master Synced today

READMEChangelogDependencies (1)Versions (11)Used By (1)

phpmysqli
=========

[](#phpmysqli)

#### 介绍

[](#介绍)

基于swoole的mysql客户端 语法兼容thinkphp db数据库操作 (回调函数操作除外)

#### 软件架构

[](#软件架构)

软件架构说明

#### 安装教程

[](#安装教程)

```
composer require szjcomo/phpmysqli

```

### 特别说明

[](#特别说明)

- 如果debug为false 不打印sql语句
- 如果debug为true 打印sql语句在控制台
- 如果debug为回调函数 则执行用户自定义的回调函数

#### 使用说明

[](#使用说明)

```
	$config = new \szjcomo\mysqli\Config([
	    'host' => '127.0.0.1',
	    'port' => 3306,
	    'user' => 'xxx',
	    'password' => 'xxx',
	    'database' => 'xxx',
	    'prefix'=>'szj_',
	    'debug'	=> function($sql,$params,$start_time,$end_time) {
			echo $sql.PHP_EOL;
			print_r($params);
			echo ($end_time - $start_time).PHP_EOL;
	    }
	]);
	$db = new \szjcomo\mysqli\Mysqli($config);
	//var_dump($db);
	try{

		//or查询
		/*$result = $db->name('article')->where('article_id',['',1],'or')->field('title,article_id')->select();
		var_dump($result);*/

		//whereNotIn查询
		/*$result = $db->name('article')->whereNotIn('article_id',[1,73,76])->field('article_id,title')->select();
		var_dump($result);*/

		//whereNotLike查询
		/*$result = $db->name('article')->whereNotLike('title','%测试%')->field('title,article_id')->select();
		var_dump($result);	*/

		//notbetween查询
		/*$result = $db->name('article')->whereNotBetween('create_time',['2019-10-30','2019-12-30'])->field('title,article_id,create_time')->select();
		var_dump($result);*/

		//between查询
		/*$result = $db->name('article')->whereBetween('create_time',['2019-10-30','2019-12-30 23:59:59'])->field('title,article_id,create_time')->select();
		var_dump($result);*/

		//wherelike查询
/*		$result = $db->name('article')->whereLike('title','%测试%')->field('title,article_id')->select();
		var_dump($result);
*/
		//wherein 查询
/*		$result = $db->name('article')->whereIn('article_id',[1,73,76])->field('title,article_id')->select();
		var_dump($result);*/

		//in查询用法
		/*$result = $db->name('article')->where('article_id','not in',[1,4,5,6])->select();
		print_r($result);*/

		//查询一条数据
		/*$info = $db->name('article')->alias('a')->leftJoin(['__ARTICLE_CATEGORY__'=>'ac'],'ac.category_id = a.category_id')
				->field('a.article_id,a.title,a.article_desc,ac.category_name,a.category_id')
				->where('a.article_id',70)
				->find();
		print_r($info);*/
		//查询多条数据
		/*$list = $db->name('article')->alias('a')->leftJoin(['__ARTICLE_CATEGORY__'=>'ac'],'ac.category_id = a.category_id')
				->field('a.article_id,a.title,a.article_desc,ac.category_name,a.category_id')
				->select();
		print_r($list);*/

		//插入数据
		/*$data = ['tag_name'=>'测试一下有没有','admin_id'=>1,'create_time'=>time()];
		$result = $db->name('tags')->insert($data);
		var_dump($result);*/

		/*$data = ['tag_name'=>'测试一下有没有','admin_id'=>1,'create_time'=>date('Y-m-d H:i:s')];
		$result = $db->name('tags')->insert($data);
		print_r($result);*/
		/*$result = $db->name('tags')->where('tag_id',2)->delete();
		print_r($result);*/

		//批量插入
		/*$data = [
			['tag_name'=>'szjcomo1','admin_id'=>1,'create_time'=>date('Y-m-d')],
			['tag_name'=>'szjcomo2','admin_id'=>1,'create_time'=>date('Y-m-d')],
			['tag_name'=>'szjcomo3','admin_id'=>1,'create_time'=>date('Y-m-d')]
		];
		$result = $db->name('tags')->insertAll($data);
		var_dump($result);*/

		//事务处理,不支持嵌套事务
		/*$db->startTrans();
		$data = ['tag_name'=>'测试一下有没有','admin_id'=>1,'create_time'=>date('Y-m-d H:i:s')];
		$id = $db->name('tags')->insert($data);
		$user = ['username'=>'szjcomo1','admin_id'=>1,'password'=>sha1('szjcomo'),'create_time'=>date('Y-m-d H:i:s')];
		$user_id = $db->name('admin_user')->insert($user);
		//$user_id = true;
		if($id && $user_id){
			echo '执行成功...'.PHP_EOL;
			$db->commit();
		} else {
			echo '执行失败'.PHP_EOL;
			$db->rollback();
		}*/

		//更新数据
/*		$data = ['tag_name'=>'xiaotao3'];
		$result = $db->name('tags')->update($data,['tag_id'=>18]);
		var_dump($result);*/
		//删除数据
		/*$result = $db->name('tags')->delete();
		var_dump($result);*/
		//查询某例的值
		/*$result = $db->name('admin_user')->column('username','id');
		print_r($result);*/
		//查询某字段值
		/*$result = $db->name('admin_user')->where('id',10)->value('username');
		var_dump($result);*/
		//统计查询
		/*$result = $db->name('article')->count('article_id');
		var_dump($result);*/
		//求最大值
		/*$result = $db->name('article_category')->max('category_sort');
		var_dump($result);*/
		//求最小值
		/*$result = $db->name('article_category')->min('category_id');
		var_dump($result);*/
		//求和
		/*$result = $db->name('article_category')->sum('category_sort');
		var_dump($result);*/
		//求平均值
		/*$result = $db->name('article_category')->avg('category_sort');
		var_dump($result);*/
		//distinct用法
		/*$result = $db->name('admin_user')->distinct(true)->field('password')->select();
		var_dump($result);
		//指定使用索引
		$result = $db->name('admin_user')->force('password')->select();
		var_dump($result);*/
		//获取查询语句
		/*$result = $db->name('admin_user')->where('id','>',1)->fetchSql(true)->select();
		echo $result.PHP_EOL;*/
		//实现子查询1
		/*$sql = $db->name('admin_user')->field('username,id')->select(true);
		$result = $db->table('('.$sql.') au')->where('id',1)->find();
		var_dump($result);*/
		//实现子查询2
		/*$buildSql = $db->name('admin_user')->field('username,id')->buildSql(true);
		$result = $db->table($buildSql.' au')->where('id',1)->field('username')->find();
		var_dump($result);*/
		//使用函数
		/*$result = $db->name('admin_user')->where('id',1)->value('UNIX_TIMESTAMP(create_time)');
		print_r($result);*/

	} catch(\Exception $err){
		echo $err->getMessage().PHP_EOL;
		//$db->rollback();
	}

```

###  Health Score

25

—

LowBetter than 37% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community11

Small or concentrated contributor base

Maturity49

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 58.3% 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

Recently: every ~17 days

Total

10

Last Release

2310d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/1ef6302d78be1eee555959fb1e9eb43578ad83603c266b0be073ada7fe015528?d=identicon)[szjcomo](/maintainers/szjcomo)

---

Top Contributors

[![luo200619](https://avatars.githubusercontent.com/u/20290887?v=4)](https://github.com/luo200619 "luo200619 (7 commits)")[![szjcomo](https://avatars.githubusercontent.com/u/54160515?v=4)](https://github.com/szjcomo "szjcomo (5 commits)")

### Embed Badge

![Health badge](/badges/szjcomo-phpmysqli/health.svg)

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

###  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.3k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M545](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

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

Reliese Components for Laravel Framework code generation.

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

PHPackages © 2026

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