README

a esay method operating mysql.

环境需求

• PHP >= 5.6

Installing

$ composer require shencongcong/mysql -vvv

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

You can contribute in one of three ways:

1. File bug reports using the issue tracker.
2. Answer questions or fix bugs on the issue tracker.
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

MIT