PHPackages                             salamander/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. salamander/mysql

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

salamander/mysql
================

Long-living MySQL connection for daemon.

2.2.1(6y ago)16.2k1MITPHPPHP >=5.4

Since Aug 15Pushed 6y ago1 watchersCompare

[ Source](https://github.com/salamander-mh/mysql)[ Packagist](https://packagist.org/packages/salamander/mysql)[ Docs](http://www.51lucy.com)[ RSS](/packages/salamander-mysql/feed)WikiDiscussions master Synced 3d ago

READMEChangelog (8)DependenciesVersions (9)Used By (0)

介绍
==

[](#介绍)

Long-living MySQL connection for daemon.

Install
=======

[](#install)

`composer require salmander/mysql`

Usage
=====

[](#usage)

```
$config = [
    // 主库
    'rwdb' => [
        'host' => "127.0.0.1",
        'user' => "root",
        'password' => "666666",
        'db' => "my_db",
        'port' => 3306,
        'charset' => "utf8",
    ],
    // 从库组
    'rodb' => [
        [
            'host' => "127.0.0.1",
            'user' => "root",
            'password' => "666666",
            'db' => "my_db",
            'port' => 3306,
            'charset' => "utf8",
        ]
    ]
]

$db = new Workerman\MySQL\Connection([
    'host'     => $config['rwdb']['host'],
    'port'     => $config['rwdb']['port'],
    'user'     => $config['rwdb']['user'],
    'password' => $config['rwdb']['password'],
    'dbname'   => $config['rwdb']['db'],
    'charset'   => $config['rwdb']['charset'],
]); // 读写主库
if($config["rodb"] && is_array($config["rodb"])) {
    $dbConn->setReadOnlyDBList($config["rodb"]);
}

// 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)");

// Updagte.
$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

30

—

LowBetter than 64% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity20

Limited adoption so far

Community5

Small or concentrated contributor base

Maturity62

Established project with proven stability

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 ~47 days

Recently: every ~56 days

Total

8

Last Release

2496d ago

Major Versions

1.0.0 → 2.0.02018-11-29

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

2.0.0PHP >=5.4

### Community

Maintainers

![](https://www.gravatar.com/avatar/cdd256fe2e3716e513e3da18c516063946ea33a043c2cf87f3cbcced1e64ab8b?d=identicon)[salamander](/maintainers/salamander)

---

Tags

phpphp7mysqlpdopdo\_mysql

### Embed Badge

![Health badge](/badges/salamander-mysql/health.svg)

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

###  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)