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

ActiveLibrary

shencongcong/mysql
==================

a esay method operating mysql

1.1.6(6y ago)3311MITPHP

Since Jul 10Pushed 6y agoCompare

[ Source](https://github.com/shencongcong/mysql)[ Packagist](https://packagist.org/packages/shencongcong/mysql)[ RSS](/packages/shencongcong-mysql/feed)WikiDiscussions master Synced 4w ago

READMEChangelogDependenciesVersions (9)Used By (0)

 mysql
=======

[](#-mysql-)

 a esay method operating mysql.

环境需求
----

[](#环境需求)

- PHP >= 5.6

Installing
----------

[](#installing)

```
$ composer require shencongcong/mysql -vvv
```

Usage
-----

[](#usage)

```
use Shencongcong\Mysql\Mysql

$config = [
          'host'     => '10.0.0.180',
          'database' => 'db',
          'user'     => 'root',
          'password' => 'root',
          'port'     => '3306',
         ],
$db = Mysql::getDbInstance($config);

### 增
$db->table('users')->insert(['user'=>'xxx','pwd'=>'xxx']);

### 删
$db->table('users')->where(['user'=>'xxx'])->delete();

### 改
$db->table('users')->where('user'=>'xxx')->update(['name'=>'xxx']);

### 查一条
$db->table('users')->where(['user'=>'xxx'])->find();

### 查全部
$db->table('users')->where(['user'=>'xxx'])->select();

### 字段查找
$db->table('users')->field('user')->where(['user'=>'xxx'])->select();

### 排序
$db->table('users')->where(['user'=>'xxx'])->order('id desc')->select();

### join
$db->table('users')->join('user_info on user_info.user_id=user.id')->select();

### 执行原生sql
$db->table('users')->query('select * from users');
```

Contributing
------------

[](#contributing)

You can contribute in one of three ways:

1. File bug reports using the [issue tracker](https://github.com/shencongcong/mysql/issues).
2. Answer questions or fix bugs on the [issue tracker](https://github.com/shencongcong/mysql/issues).
3. Contribute new features or update the wiki.

*The code contribution process is not very formal. You just need to make sure that you follow the PSR-0, PSR-1, and PSR-2 coding guidelines. Any new code contributions must be accompanied by unit tests where applicable.*

License
-------

[](#license)

MIT

###  Health Score

29

—

LowBetter than 60% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity15

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity63

Established project with proven stability

 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

8

Last Release

2488d ago

### Community

Maintainers

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

---

Top Contributors

[![shencongcong](https://avatars.githubusercontent.com/u/17448136?v=4)](https://github.com/shencongcong "shencongcong (9 commits)")

### Embed Badge

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

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

PHPackages © 2026

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