PHPackages easyswoole/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. [Framework](/categories/framework) 4. / 5. easyswoole/mysqli ActiveLibrary[Framework](/categories/framework) easyswoole/mysqli ================= An efficient swoole framework 4.0.10(1y ago)34120.5k↓26%29[3 issues](https://github.com/easy-swoole/mysqli/issues)20Apache-2.0PHPPHP >=8.1 Since Jul 23Pushed 1y ago1 watchersCompare [ Source](https://github.com/easy-swoole/mysqli)[ Packagist](https://packagist.org/packages/easyswoole/mysqli)[ Docs](https://www.easyswoole.com/)[ RSS](/packages/easyswoole-mysqli/feed)WikiDiscussions 4.x Synced 1mo ago READMEChangelog (10)Dependencies (3)Versions (71)Used By (20) Mysqli ====== [](#mysqli) 本Mysqli构造器基于 移植实现的协程安全版本。 单元测试 ---- [](#单元测试) ``` ./vendor/bin/co-phpunit tests ``` 安装 -- [](#安装) ``` composer require easyswoole/mysqli ``` Client实例 -------- [](#client实例) ``` $config = new \EasySwoole\Mysqli\Config([ 'host' => '', 'port' => 3300, 'user' => '', 'password' => '', 'database' => '', 'timeout' => 5, 'charset' => 'utf8mb4', ]); $client = new \EasySwoole\Mysqli\Client($config); go(function ()use($client){ //构建sql $client->queryBuilder()->get('user_list'); //执行sql var_dump($client->execBuilder()); }); ``` 查询构造器 ----- [](#查询构造器) QueryBuilder是一个SQL构造器，用来构造prepare sql。例如： ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); //执行条件构造逻辑 $builder->where('col1',2)->get('my_table'); //获取上次条件构造的预处理sql语句 echo $builder->getLastPrepareQuery(); // SELECT * FROM whereGet WHERE col1 = ? //获取上次条件构造的sql语句 echo $builder->getLastQuery(); //SELECT * FROM whereGet WHERE col1 = 2 //获取上次条件构造的预处理sql语句所以需要的绑定参数 echo $builder->getLastBindParams(); //[2] ``` ### GET [](#get) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // 获取全表 $builder->get('getTable'); // 表前缀 $builder->setPrefix('easyswoole_')->get('getTable'); // 获取总数。下面两个结果相同 $builder->withTotalCount()->where('col1', 1, '>')->get('getTable'); $builder->setQueryOption('SQL_CALC_FOUND_ROWS')->where('col1', 1, '>')->get('getTable'); // fields。支持一维数组或字符串 $builder->fields('col1, col2')->get('getTable'); $builder->get('getTable', null, ['col1','col2']); // limit 1。下面两个结果相同 $builder->get('getTable', 1) $builder->getOne('getTable') // offset 1, limit 10 $builder->get('getTable',[1, 10]) // 去重查询。 $builder->get('getTable', [2,10], ['distinct col1','col2']); // where查询 $builder->where('col1', 2)->get('getTable'); // where查询2 $builder->where('col1', 2, '>')->get('getTable'); // 多条件where $builder->where('col1', 2)->where('col2', 'str')->get('getTable'); // whereIn, whereNotIn, whereLike，修改相应的operator(IN, NOT IN, LIKE) $builder->where('col3', [1,2,3], 'IN')->get('getTable'); // orWhere $builder->where('col1', 2)->orWhere('col2', 'str')->get('getTable'); ``` #### Join [](#join) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // join。默认INNER JOIN $builder->join('table2', 'table2.col1 = getTable.col2')->get('getTable'); $builder->join('table2', 'table2.col1 = getTable.col2', 'LEFT')->get('getTable'); // join Where $builder->join('table2','table2.col1 = getTable.col2')->where('table2.col1', 2)->get('getTable'); ``` #### GroupBy Having [](#groupby-having) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // groupBy. $builder->groupBy('col1')->get('getTable'); $builder->where('col1',2)->groupBy('col1')->get('getTable'); // having $builder->groupBy('col1')->having('col1')->get('getTable'); $builder->groupBy('col1')->having('col1', 1, '>')->get('whereGet'); // and having. having第4个参数默认是 `AND`，默认多having是`且`关系 $builder->groupBy('col1')->having('col1', 1, '>')->having('col2', 1, '>')->get('whereGet'); // or having. 下面两种方法效果相等 $builder->groupBy('col1')->having('col1', 1, '>')->orHaving('col2', 1, '>')->get('whereGet'); $builder->groupBy('col1')->having('col1', 1, '>')->having('col2', 1, '>', 'OR')->get('whereGet'); ``` #### OrderBy [](#orderby) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // orderBy. 默认DESC $builder->orderBy('col1', 'ASC')->get('getTable'); $builder->where('col1',2)->orderBy('col1', 'ASC')->get('getTable'); ``` #### Union [](#union) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // union. 相当于 adminTable UNION userTable $builder->union((new QueryBuilder)->where('userName', 'user')->get('userTable')) ->where('adminUserName', 'admin')->get('adminTable'); ``` ### UPDATE [](#update) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // update $builder->update('updateTable', ['a' => 1]); // limit update $builder->update('updateTable', ['a' => 1], 5); // where update $builder->where('whereUpdate', 'whereValue')->update('updateTable', ['a' => 1]); ``` ### DELETE [](#delete) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // delete all $builder->delete('deleteTable'); // limit delete $builder->delete('deleteTable', 1); // where delete $builder->where('whereDelete', 'whereValue')->delete('deleteTable'); ``` ### INSERT [](#insert) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // insert into $builder->insert('insertTable', ['a' => 1, 'b' => "b"]); // replace into $builder->replace('replaceTable', ['a' => 1]); ``` ### SUBQUERY [](#subquery) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // 单一where条件子查询 // 等同于 SELECT * FROM users WHERE id in ((SELECT userId FROM products WHERE qty > 2)) $sub = $this->builder::subQuery(); $sub->where("qty", 2, ">"); $sub->get("products", null, "userId"); $builder->where("id", $sub, 'in')->get('users'); // 多where条件子查询 // 等同于 SELECT * FROM users WHERE col2 = 1 AND id in ((SELECT userId FROM products WHERE qty > 2)) $sub = $this->builder::subQuery(); $sub->where ("qty", 2, ">"); $sub->get ("products", null, "userId"); $this->builder->where('col2',1)->where ("id", $sub, 'in')->get('users'); // INSERT 包含子结果集 // 等同于 INSERT INTO products (`productName`, `userId`, `lastUpdated`) VALUES ('test product', (SELECT name FROM users WHERE id = 6 LIMIT 1), NOW()) $userIdQ = $this->builder::subQuery(); $userIdQ->where ("id", 6); $userIdQ->getOne ("users", "name"); $data = Array ( "productName" => "test product", "userId" => $userIdQ, "lastUpdated" => $this->builder->now() ); $this->builder->insert ("products", $data); ``` ### LOCK [](#lock) ``` use EasySwoole\Mysqli\QueryBuilder; $builder = new QueryBuilder(); // FOR UPDATE 排它锁。下面两个方法效果相同 $builder->setQueryOption("FOR UPDATE")->get('getTable'); $builder->selectForUpdate(true)->get('getTable'); // FOR UPDATE NOWAIT $builder->selectForUpdate(true, 'NOWAIT')->get('getTable'); // FOR UPDATE WAIT Second $builder->selectForUpdate(true, 'WAIT 5')->get('getTable'); // FOR UPDATE SKIP LOCKED $builder->selectForUpdate(true, 'SKIP LOCKED')->get('getTable'); // LOCK IN SHARE MODE。共享锁 $builder->lockInShareMode()->get('getTable'); $builder->setQueryOption(['LOCK IN SHARE MODE'])->get('getTable'); // LOCK TABLES 获取表锁 $builder->lockTable('table'); // UNLOCK TABLES 释放表锁 $builder->unlockTable('table'); ``` ### Health Score 52 — FairBetter than 96% of packages Maintenance33 Infrequent updates — may be unmaintained Popularity44 Moderate usage in the ecosystem Community32 Small or concentrated contributor base Maturity86 Battle-tested with a long release history Bus Factor2 2 contributors hold 50%+ of commits 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 ~33 days Recently: every ~75 days Total 69 Last Release 601d ago Major Versions 1.2.3 → 2.0.02019-09-06 2.2.11 → 3.0.02022-01-11 3.x-dev → 4.0.12023-11-27 ### Community Maintainers ![](https://www.gravatar.com/avatar/45c234d5f129ea570e630425636299127647534f0c2cbb073555e2c45d403d6f?d=identicon)[kiss291323003](/maintainers/kiss291323003) --- Top Contributors [![kiss291323003](https://avatars.githubusercontent.com/u/24490609?v=4)](https://github.com/kiss291323003 "kiss291323003 (101 commits)")[![hanwenbo](https://avatars.githubusercontent.com/u/5869741?v=4)](https://github.com/hanwenbo "hanwenbo (73 commits)")[![Player626](https://avatars.githubusercontent.com/u/44792981?v=4)](https://github.com/Player626 "Player626 (30 commits)")[![evalor](https://avatars.githubusercontent.com/u/26944445?v=4)](https://github.com/evalor "evalor (29 commits)")[![xuanyanwow](https://avatars.githubusercontent.com/u/28777109?v=4)](https://github.com/xuanyanwow "xuanyanwow (20 commits)")[![tioncico](https://avatars.githubusercontent.com/u/31308307?v=4)](https://github.com/tioncico "tioncico (2 commits)")[![liosmt0](https://avatars.githubusercontent.com/u/43941983?v=4)](https://github.com/liosmt0 "liosmt0 (2 commits)")[![XueSiLf](https://avatars.githubusercontent.com/u/31389659?v=4)](https://github.com/XueSiLf "XueSiLf (1 commits)")[![kyour-cn](https://avatars.githubusercontent.com/u/38110013?v=4)](https://github.com/kyour-cn "kyour-cn (1 commits)")[![edenleung](https://avatars.githubusercontent.com/u/31346973?v=4)](https://github.com/edenleung "edenleung (1 commits)") --- Tags asyncframeworkswooleeasyswoole ### Embed Badge ![Health badge](/badges/easyswoole-mysqli/health.svg) ``` [![Health](https://phpackages.com/badges/easyswoole-mysqli/health.svg)](https://phpackages.com/packages/easyswoole-mysqli) ``` ### Alternatives [easyswoole/easyswoole An efficient swoole framework 4.8k186.9k50](/packages/easyswoole-easyswoole)[easyswoole/redis easyswoole component 3391.8k12](/packages/easyswoole-redis)[easyswoole/kafka An efficient swoole framework 4211.1k](/packages/easyswoole-kafka)[easyswoole/compiler easyswoole component 691.1k](/packages/easyswoole-compiler)[easyswoole/fast-cache An efficient swoole framework 1030.3k2](/packages/easyswoole-fast-cache)[easyswoole/actor easyswoole component 1410.3k](/packages/easyswoole-actor) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)