方法1:直接在字段后跟值,自动判断
- $this->dbSelect('info',[
- 'fetchSql' => false,
- 'limit' => $limit,
- 'field' => 'info_id,info_name,info_unit_id,info_cover,info_excerpt,info_views',
- 'where' => [
- 'info_status' => 'normal',
- ],
- 'order' => [
- $orderField => 'desc',
- ],
- ])
复制代码 方法2:手动给查询表达式
- $list = model('common/User','loglic')->selectPage([
- 'where' => [
- ['user_unit_id','eq',2],
- ],
- 'order' => [
- 'user_id' => 'desc',
- ],
- ],$this->pageSize,$this->site['page'],false,$this->query);
复制代码
|