欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  科技

THINKphp中复杂的查询

程序员文章站 2024-01-26 15:30:52
字符串拼接查询 案例一:拼接字符串(多条件查询) $where = ''; //定义字符串,用于拼接满足条件的数据字段 $value = []; // 定义空数组,用于接收值 if(!empty($nickname)){ $where .= ' AND nickname = :nickname'; ......
  • 字符串拼接查询
    案例一:拼接字符串(多条件查询)        
    $where = '';   //定义字符串,用于拼接满足条件的数据字段
            $value = [];  // 定义空数组,用于接收值
            if(!empty($nickname)){
                $where .= ' and nickname = :nickname'; //数据表字段
                $value['nickname'] = $nickname;  //赋值
            }
            if(!empty($phone)){
                $where .= ' and mobile = :mobile';
                $value['mobile'] = $phone;
            }
            if(!empty($user_status)){
                $where .= ' and user_status = :user_status';
                $value['user_status'] = $user_status;
            }
    
            if(!empty($reg_start_end)){
                $start_end = explode('|',$reg_start_end);
                if(!empty($start_end[0])){
                    $where .= ' and create_time > :start_time';
                    $value['start_time'] = strtotime($start_end[0]);
                }
                if(!empty($start_end[1])){
                    $where .= ' and create_time <= :end_time';
                    $value['end_time'] = strtotime($start_end[1]);
                }
            }
    
            if(!empty($is_proxy)){
                $where .= ' and is_proxy = :is_proxy';
                $value['is_proxy'] = $is_proxy;
            }
            if(!empty($sex)){
                $where .= ' and gender = :gender';
                $value['gender'] = $sex;
            }$list  = $obj->whereraw('1=1'.$where.'', $value)->limit($limit_start, $limit_length)->order('create_time', 'asc')->select();  //查询满足条件的数据
       db::table('表名') ->whereraw('id = :id and name like :name ', ['id' => 0, 'name' => 'thinkphp%']) ->select(); //形成的原生sql语句.



    案例二:快捷查询
    快捷查询方式是一种多字段相同查询条件的简化写法,可以进一步简化查询条件的写法,在多个字段之间用|分割表示or查询,用&分割表示and查询,可以实现下面的查询,例如:
    db::table('think_user')
        ->where('name|title','like','%thinkphp%')
        ->where('create_time&update_time','>',0)
        ->find();

    生成的查询sql如下:
    select * from `think_user` where ( `name` like 'thinkphp%' or `title` like 'thinkphp%' ) and ( `create_time` > 0 and `update_time` > 0 ) limit 1
    select * from `think_user` where ( `name` like 'thinkphp%' or `title` like 'thinkphp%' ) and ( `create_time` > 0 and `update_time` > 0 ) limit 1;



    案例三: 拼接字符串查询
    $where  = '';
    if ($status != 'all') {
            $where .= ' and status=' . $status; //拼接满足条件的表字段
    }