# php-orm **Repository Path**: gaotiefeng/php-orm ## Basic Information - **Project Name**: php-orm - **Description**: No description available - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2021-05-26 - **Last Updated**: 2021-10-18 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # php-orm > 来源thinkphp > 本地环境测试 > 自学demo ## 查询 ```php Db::table('admin_router')->select(); ``` ### filed ```php Db::table('admin_router')->field('sort,id')->select(); ``` ### group ```php Db::table('admin_router')->group('sort')->select(); ``` ### where ```php Db::table('admin_router')->where(['id'=>3])->select(); ``` ### order ```php Db::table('admin_router')->order(['id' => 'desc'])->select(); ``` ### having ```php Db::table('admin_router')->having('sort > 66')->select(); ``` ### limit ```php Db::table('admin_router')->limit(3,9)->select(); ``` ## 新增 ```php $data = ['name'=>'test'.rand(0,10),'phone'=>'1590004678'.rand(0,9),'email' => '1096392101@qq.com','pwd' => '123456']; $ii = Db::table('admin_user')->insert($data); ``` ## 更新 ```php Db::table('admin_user')->where(['id'=>3])->update(['name'=>'test12212']); ``` ## 删除 ```php Db::table('admin_user')->where(['id'=>4])->delete(); ```