TP5.0 编辑时排除当前操作账户后进行查询，例如手机号或账户是否存在

努力的去实现梦想

于 2018-09-12 18:31:00 发布

阅读量525

点赞数

分类专栏： TP5

本文链接：https://blog.csdn.net/u014202165/article/details/82666175

版权

TP5 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

//验证手机号或账号是否已经存在
if(!empty($_REQUEST['staff_id'])){
    $ver_staff_where['staff_id'] = array('neq',$_REQUEST['staff_id']);
}

$ver_staff_with['staff_account'] = $params['staff_account'];
$ver_staff_with['staff_phone'] = $params['staff_phone'];

$verification = Db::name('staff_info')->where($ver_staff_where)
    ->where("staff_account=:staff_account OR staff_phone=:staff_phone",
        ['staff_account' => $ver_staff_with['staff_account'], 'staff_phone' => $ver_staff_with['staff_phone']])->find();