PHPackages zsymv/wmmysql - 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. zsymv/wmmysql ActiveLibrary[Database & ORM](/categories/database) zsymv/wmmysql ============= Long-living MySQL connection for daemon. v1.0.3(2y ago)012MITPHPPHP >=5.3 Since May 10Pushed 2y ago1 watchersCompare [ Source](https://github.com/tan-github/wmmysql)[ Packagist](https://packagist.org/packages/zsymv/wmmysql)[ Docs](http://www.workerman.net)[ RSS](/packages/zsymv-wmmysql/feed)WikiDiscussions master Synced 1mo ago READMEChangelogDependenciesVersions (5)Used By (0) 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 19 — LowBetter than 10% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity5 Limited adoption so far Community7 Small or concentrated contributor base Maturity39 Early-stage or recently created project 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 ~0 days Total 4 Last Release 735d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/613a6d9b5c6e1d53f913a82629cbcde6e593f0ccb3f14b2fc3829bc8598c86cc?d=identicon)[tan-packagist](/maintainers/tan-packagist) --- Top Contributors [![tan-github](https://avatars.githubusercontent.com/u/24643601?v=4)](https://github.com/tan-github "tan-github (4 commits)") --- Tags mysqlpdopdo\_mysql ### Embed Badge ![Health badge](/badges/zsymv-wmmysql/health.svg) ``` [![Health](https://phpackages.com/badges/zsymv-wmmysql/health.svg)](https://phpackages.com/packages/zsymv-wmmysql) ``` ### Alternatives [doctrine/dbal Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. 9.7k578.4M5.6k](/packages/doctrine-dbal)[ifsnop/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k5.5M69](/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. 5656.7M234](/packages/nette-database)[dibi/dibi Dibi is Database Abstraction Library for PHP 5013.8M120](/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. 5632.5M43](/packages/aura-sql)[aura/sqlquery Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library. 4572.9M34](/packages/aura-sqlquery) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)