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

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

ninvfeng/mysql
==============

一个简单PDO mysql数据库操作类

1.0(8y ago)2614320[2 issues](https://github.com/ninvfeng/mysql/issues)MITPHPPHP >=7.0.0

Since Feb 3Pushed 5y ago3 watchersCompare

[ Source](https://github.com/ninvfeng/mysql)[ Packagist](https://packagist.org/packages/ninvfeng/mysql)[ RSS](/packages/ninvfeng-mysql/feed)WikiDiscussions develop Synced 4d ago

READMEChangelogDependenciesVersions (3)Used By (0)

一个简单的PHP Mysql数据库操作类
====================

[](#一个简单的php-mysql数据库操作类)

依赖
--

[](#依赖)

- pdo

安装
--

[](#安装)

1. composer 安装 `composer require ninvfeng/mysql`
2. 引入/vendor目录下的autoload.php `require 'vendor/autoload.php';`

初始化
---

[](#初始化)

```
//配置
$config=[
    'host'=>'127.0.0.1',
    'port'=>3306,
    'name'=>'test'
];

//推荐使用函数进行实例化,后续操作更加方便
function db($table='null') use $config{
    static $_db;
    if(!$_db){
        $_db=new \ninvfeng\mysql($config);
    }
    return $_db->table($table);
}

```

### 增

[](#增)

```
db('user')->insert(['user'=>'ninvfeng','pass'=>'password']);
db('user')->insert(['user'=>'lvlv','pass'=>'password']);

```

### 删

[](#删)

```
db('user')->where(['user'=>'ninvfeng'])->delete();

```

### 改

[](#改)

```
db('user')->where(['user'=>'lvlv'])->update(['pass'=>'password2']);

```

### 查找一条

[](#查找一条)

```
db('user')->where(['user'=>'lvlv'])->find();

```

### 查找全部

[](#查找全部)

```
db('user')->select();

```

### 条件查找

[](#条件查找)

```
db('user')->where(['user'=>'ninvfeng'])->select();

```

### 分页查找

[](#分页查找)

```
db('user')->page(1)->select();

```

### 字段查找

[](#字段查找)

```
db('user')->field('user')->select();

```

### 排序

[](#排序)

```
db('user')->order('id desc')->select();

```

### join

[](#join)

```
db('user')->join('user_info on user_info.user_id=user.id')->select();

```

### debug 仅打印sql不执行

[](#debug-仅打印sql不执行)

```
db('user')->debug()->select();

```

### 执行原生sql

[](#执行原生sql)

```
db('user')->query("select * from user");

```

### 事务

[](#事务)

```
db('user')->trans();

```

### 返回原生对象

[](#返回原生对象)

```
db()->pdo();

```

###  Health Score

31

—

LowBetter than 68% of packages

Maintenance18

Infrequent updates — may be unmaintained

Popularity23

Limited adoption so far

Community13

Small or concentrated contributor base

Maturity59

Maturing project, gaining track record

 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

Unknown

Total

1

Last Release

3024d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/12c3988c7e44f6512401557de9fa2b4d511696dd3bd2b57ef296c95967f33790?d=identicon)[ninvfeng](/maintainers/ninvfeng)

---

Top Contributors

[![ninvfeng](https://avatars.githubusercontent.com/u/6409949?v=4)](https://github.com/ninvfeng "ninvfeng (23 commits)")

---

Tags

mysqlphpphpmysql

### Embed Badge

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

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

###  Alternatives

[leantime/leantime

Open source project management system for non-project managers. Simple like Trello, powerful like Jira. Built with neurodiversity in mind.

9.4k2.8k](/packages/leantime-leantime)[clouddueling/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

1.3k22.9k](/packages/clouddueling-mysqldump-php)[stefangabos/zebra_database

An advanced, compact and lightweight MySQL database wrapper library, built around PHP's MySQLi extension.

11812.0k](/packages/stefangabos-zebra-database)[eftec/pdoone

Minimaist procedural PDO wrapper library

1105.9k9](/packages/eftec-pdoone)[popphp/pop-db

Pop Db Component for Pop PHP Framework

1814.6k11](/packages/popphp-pop-db)[matthew-p/docker-server

Universal docker server, Nginx, PHP-FPM, MySql, Redis

112.8k](/packages/matthew-p-docker-server)

PHPackages © 2026

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