|
批量新增
- $users = new Users;
- $list = [
- ['email' => 'test@qq.com' , 'mobile' => '123456789' ],
- ['email' => 'tes2@qq.com' , 'mobile' => '223456789' ],
- ];
- if($users - > saveAll($list)){
- echo '用户批量新增成功'
- }
复制代码
查询操作,按主键ID
- $user = Users::get(1) //查询users表里的主键为1的记录
- echo $user->mobile; //打印此行记录中的mobile字段的值
- echo $user['mobile']; //打印此行记录中的m obile字段的值 数组方式
复制代码
查询操作,按字段内容搜索式查询 getByXxxx()方法
Xxxx可以是任意数据表有的字段
- $user = Users::getByMobile('123456');
- echo $user['email'];
复制代码
根据传入数组作为查询条件
- $user = Users::get(['mobile'=>'132465','email'=>'11@qq.com']);
- $user = Users::where(['mobile','132465'])->find();
- $user = Users::where(['mobile'=>'132465','email'=>'11@qq.com'])->find(); //and方式
- echo $user['email'];
复制代码
查询操作,多个结果查询
- $user = Users::all();
- $user = Users::all(['mobile'=>'132465']);
- $user = Users::where(['level_id','<=',3)->select();
- foreach($list as $v){
- echo 'id:'.$v->level_id;
- echo '等级名称'.$v->level_name;
- }
复制代码
对于数据库查询出来的数据进行更新
- $user = Users::get(1);
- $user->mobile = '23232323';
- $user->email = 'test@5ucms.com';
- if(false !== $user->save())
- return '更新用户成功';
- else
- return $user->getError();
复制代码
对于数据库查询出来的数据进行修改后增加
- $user = Users::get(1);
- $user->mobile = '23232323';
- $user->email = 'test@5ucms.com';
- $user->user_id = null; //把主键值去掉,否则不能加成功
- if(false !== $user->isUpdate(false)->save())
- return '更新用户成功';
- else
- return $user->getError();
复制代码
自己定义数据库更新操作
- $userArr['mobile'] = '123456789';
- $userArr['email'] = 'test2@5ucms.com';
- Users::update($userArr,['user_id'=>1]);
复制代码
删除操作
- $user = Users::get(2593)
- $user -> delete();
复制代码
或者使用
|
|