PHPackages                             mejinke/merrdb - 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. mejinke/merrdb

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

mejinke/merrdb
==============

A pleasant mysql library

6127PHP

Since Feb 7Pushed 8y ago1 watchersCompare

[ Source](https://github.com/mejinke/merrdb)[ Packagist](https://packagist.org/packages/mejinke/merrdb)[ RSS](/packages/mejinke-merrdb/feed)WikiDiscussions master Synced 1w ago

READMEChangelogDependenciesVersions (1)Used By (0)

merrdb
======

[](#merrdb)

一个简单、快速的Mysql数据库操作类库。

### 安装

[](#安装)

```
composer require mejinke/merrdb

```

### 快速入门

[](#快速入门)

```
require __DIR__.'/../vendor/autoload.php';

//创建一个连接
$conn = new \Merrdb\Connection([
    'host' => 'localhost',
    'database' => 'test',
    'username' => 'root',
    'password' => '123456'
]);

//实例化Merrdb，同时传递连接
$mdb = new \Merrdb\Merrdb([$conn]);

//设置接下来要操作的表以及表的主键（如果不使用get方法可以不设置主键）
$mdb->table('user')->id('user_id');

//开启debug ，将会输出SQL
$mdb->debug();

//查询全表
$rows = $mdb->select();
print_r($rows);

$mdb->debug();
//查询主键值为1的数据
$row = $mdb->get(1);
```

### 条件表达式

[](#条件表达式)

通过在条件字段尾部添加英文逗号`,`来注明要使用的表达式，默认为`等于`。 包括 `=`、`!`、`>`、`>=` 、`select([
    "name" => "张三"
]);

//不等于 > SELECT * FROM user WHERE (`name` != '张三')
$mdb->select([
    "name,!" => "张三"
]);
//大于 > SELECT * FROM `user` WHERE (`user_id` > '1')
$mdb->select([
    "user_id,>" => 1
]);

//IN > SELECT * FROM user WHERE (`name` IN('张三', '李四', '王五'))
$mdb->select([
    "name" => ["张三", "李四", "王五"]
]);

//NOT IN > SELECT * FROM user WHERE (`name` NOT IN('张三', '李四', '王五'))
$mdb->select([
    "name,!" => ["张三", "李四", "王五"]
]);

//BETWEEN > SELECT * FROM user WHERE (`user_id` BETWEEN '1' AND '10' )
$mdb->select([
    "user_id," => [1, 10]
]);
//SELECT * FROM `user` WHERE (`user_id` BETWEEN '1' AND '1' )
$mdb->select([
    "user_id," => 10
]);

//NOT BETWEEN > SELECT * FROM user WHERE (`id` NOT BETWEEN '1' AND '10')
$mdb->select([
    "user_id,>