查询语句orderby的用法

$news = M("cms_news");
$news->pageSize = 15;
$news->field = 'id,sUrl,title,hits,addtime,istop';

1.一维数组,一个字段
$news->orderby(['id' => 'asc']);

2. 二维数组,两个字段
$news->orderby(['id' => 'desc', 'hits' => 'asc']);

3.方法传入字符串格式,完整解析
1news->orderby('id desc,hits desc');
$news->orderby('order by id desc,hits desc');

3.orderby直接赋值字符串,完美解析
$news->orderby = 'id desc,hits desc';
$news->orderby = 'order by id desc,hits desc';

字符串格式可包含order by字符串,不分大小写


//调用getList查询
$news->getList();

(c) CodaCms.
Design & Develop by Coda IntelliSoft