gaotiefeng/php-orm

php src/orm

dev-master 2021-10-18 05:34 UTC

Requires

• php: >=7.1
• ext-pdo: *
• sethink/swoole-orm: dev-master

Requires (Dev)

• phpunit/phpunit: ^6.2

MIT

• gaotiefeng

README

来源thinkphp 本地环境测试 自学demo

查询

Db::table('admin_router')->select();

filed

Db::table('admin_router')->field('sort,id')->select();

group

Db::table('admin_router')->group('sort')->select();

where

Db::table('admin_router')->where(['id'=>3])->select();

order

Db::table('admin_router')->order(['id' => 'desc'])->select();

having

Db::table('admin_router')->having('sort > 66')->select();

limit

Db::table('admin_router')->limit(3,9)->select();

新增

$data = ['name'=>'test'.rand(0,10),'phone'=>'1590004678'.rand(0,9),'email' => '[e-mail]','pwd' => '123456'];
$ii = Db::table('admin_user')->insert($data);

更新

Db::table('admin_user')->where(['id'=>3])->update(['name'=>'test12212']);

删除

Db::table('admin_user')->where(['id'=>4])->delete();