5ucms论坛
标题:
13 模型和关联-下
[打印本页]
作者:
admin
时间:
2019-9-21 10:00
标题:
13 模型和关联-下
批量新增
$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字段的值 数组方式
复制代码
查询操作,按字段内容搜索式查询 getBy
Xxxx
()方法
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();
复制代码
或者使用
Users::destroy(2593);
复制代码
欢迎光临 5ucms论坛 (http://bbs.5ucms.com/)
Powered by Discuz! X3.2