PHPackages workerman/mysql - 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. workerman/mysql ActiveLibrary[Database & ORM](/categories/database) workerman/mysql =============== Long-living MySQL connection for daemon. v1.0.9(1y ago)6491.7k↑1084.4%22[4 issues](https://github.com/walkor/mysql/issues)12MITPHPPHP >=5.3 Since Mar 4Pushed 1y ago6 watchersCompare [ Source](https://github.com/walkor/mysql)[ Packagist](https://packagist.org/packages/workerman/mysql)[ Docs](http://www.workerman.net)[ RSS](/packages/workerman-mysql/feed)WikiDiscussions master Synced 2d ago READMEChangelog (10)DependenciesVersions (11)Used By (12) Workerman\\Mysql\\Connection ============================ [](#workermanmysqlconnection) Long-living MySQL connection for daemon. Install ======= [](#install) `composer require workerman/mysql` Usage ===== [](#usage) ``` $db = new Workerman\MySQL\Connection($mysql_host, $mysql_port, $user, $password, $db_bname); // Get all rows. $db1->select('ID,Sex')->from('Persons')->where('sex= :sex')->bindValues(array('sex'=>'M'))->query(); // Equivalent to. $db1->select('ID,Sex')->from('Persons')->where("sex='F'")->query(); // Equivalent to. $db->query("SELECT ID,Sex FROM `Persons` WHERE sex='M'"); // Get one row. $db->select('ID,Sex')->from('Persons')->where('sex= :sex')->bindValues(array('sex'=>'M'))->row(); // Equivalent to. $db->select('ID,Sex')->from('Persons')->where("sex= 'F' ")->row(); // Equivalent to. $db->row("SELECT ID,Sex FROM `Persons` WHERE sex='M'"); // Get a column. $db->select('ID')->from('Persons')->where('sex= :sex')->bindValues(array('sex'=>'M'))->column(); // Equivalent to. $db->select('ID')->from('Persons')->where("sex= 'F' ")->column(); // Equivalent to. $db->column("SELECT `ID` FROM `Persons` WHERE sex='M'"); // Get single. $db->select('ID,Sex')->from('Persons')->where('sex= :sex')->bindValues(array('sex'=>'M'))->single(); // Equivalent to. $db->select('ID,Sex')->from('Persons')->where("sex= 'F' ")->single(); // Equivalent to. $db->single("SELECT ID,Sex FROM `Persons` WHERE sex='M'"); // Complex query. $db->select('*')->from('table1')->innerJoin('table2','table1.uid = table2.uid')->where('age > :age') ->groupBy(array('aid'))->having('foo="foo"')->orderByASC/*orderByDESC*/(array('did')) ->limit(10)->offset(20)->bindValues(array('age' => 13)); // Equivalent to. $db->query(SELECT * FROM `table1` INNER JOIN `table2` ON `table1`.`uid` = `table2`.`uid` WHERE age > 13 GROUP BY aid HAVING foo="foo" ORDER BY did LIMIT 10 OFFSET 20“); // Insert. $insert_id = $db->insert('Persons')->cols(array( 'Firstname'=>'abc', 'Lastname'=>'efg', 'Sex'=>'M', 'Age'=>13))->query(); // Equivalent to. $insert_id = $db->query("INSERT INTO `Persons` ( `Firstname`,`Lastname`,`Sex`,`Age`) VALUES ( 'abc', 'efg', 'M', 13)"); // Update. $row_count = $db->update('Persons')->cols(array('sex'))->where('ID=1') ->bindValue('sex', 'F')->query(); // Equivalent to. $row_count = $db->update('Persons')->cols(array('sex'=>'F'))->where('ID=1')->query(); // Equivalent to. $row_count = $db->query("UPDATE `Persons` SET `sex` = 'F' WHERE ID=1"); // Delete. $row_count = $db->delete('Persons')->where('ID=9')->query(); // Equivalent to. $row_count = $db->query("DELETE FROM `Persons` WHERE ID=9"); // Transaction. $db1->beginTrans(); .... $db1->commitTrans(); // or $db1->rollBackTrans(); ``` ### Health Score 48 — FairBetter than 93% of packages Maintenance40 Moderate activity, may be stable Popularity47 Moderate usage in the ecosystem Community31 Small or concentrated contributor base Maturity64 Established project with proven stability Bus Factor1 Top contributor holds 76.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 ~326 days Recently: every ~642 days Total 10 Last Release 473d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/c8bc354ebf6983ed6334dd25ad0c1003b0034bcd148111d2d7ef463171f4dcba?d=identicon)[workerman](/maintainers/workerman) --- Top Contributors [![walkor](https://avatars.githubusercontent.com/u/6073368?v=4)](https://github.com/walkor "walkor (29 commits)")[![don6105](https://avatars.githubusercontent.com/u/9106797?v=4)](https://github.com/don6105 "don6105 (2 commits)")[![keppelcao](https://avatars.githubusercontent.com/u/1754641?v=4)](https://github.com/keppelcao "keppelcao (1 commits)")[![KrasilnikovKB](https://avatars.githubusercontent.com/u/16627494?v=4)](https://github.com/KrasilnikovKB "KrasilnikovKB (1 commits)")[![liuquanhao](https://avatars.githubusercontent.com/u/7736182?v=4)](https://github.com/liuquanhao "liuquanhao (1 commits)")[![tonop01](https://avatars.githubusercontent.com/u/29866948?v=4)](https://github.com/tonop01 "tonop01 (1 commits)")[![woodongwong](https://avatars.githubusercontent.com/u/9292647?v=4)](https://github.com/woodongwong "woodongwong (1 commits)")[![yuandalu](https://avatars.githubusercontent.com/u/3860040?v=4)](https://github.com/yuandalu "yuandalu (1 commits)")[![jichangfeng](https://avatars.githubusercontent.com/u/34360195?v=4)](https://github.com/jichangfeng "jichangfeng (1 commits)") --- Tags mysqlmysqlpdopdo\_mysql ### Embed Badge ![Health badge](/badges/workerman-mysql/health.svg) ``` [![Health](https://phpackages.com/badges/workerman-mysql/health.svg)](https://phpackages.com/packages/workerman-mysql) ``` ### Alternatives [doctrine/dbal Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. 9.7k605.0M6.8k](/packages/doctrine-dbal)[ifsnop/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k6.0M77](/packages/ifsnop-mysqldump-php)[nette/database 💾 Nette Database: layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle. 5687.0M262](/packages/nette-database)[dibi/dibi Dibi is Database Abstraction Library for PHP 5014.0M134](/packages/dibi-dibi)[aura/sql A PDO extension that provides lazy connections, array quoting, query profiling, value binding, and convenience methods for common fetch styles. Because it extends PDO, existing code that uses PDO can use this without any changes to the existing code. 5892.7M56](/packages/aura-sql)[aura/sqlquery Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library. 4883.1M39](/packages/aura-sqlquery) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)