# 函數原型 ~~~ public function order($mixExpr); ~~~ 說明：參數支持字符串以及它們構成的一維數組。 # 用法如下 ~~~ # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` ORDER BY `test`.`id` DESC,`test`.`name` ASC database::table ( 'test', 'tid as id,tname as value' ) ->orderBy('id DESC') ->orderBy('name') ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` ORDER BY `post`.`id` DESC database::table ( 'test', 'tid as id,tname as value' ) ->orderBy('post.id DESC') ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` ORDER BY SUM(`test`.`num`) ASC database::table ( 'test', 'tid as id,tname as value' ) ->orderBy('{SUM([num]) ASC}') ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` ORDER BY `test`.`title` ASC,`test`.`id` ASC,concat('1234','`test`.`id`','ttt') DESC database::table ( 'test', 'tid as id,tname as value' ) ->orderBy("title,id,{concat('1234','[id]','ttt') desc}") ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` ORDER BY `test`.`title` ASC,`test`.`id` ASC,`test`.`ttt` ASC,`test`.`value` DESC database::table ( 'test', 'tid as id,tname as value' ) ->orderBy(['title,id,ttt','value desc']) ->getAll (); # SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` ORDER BY `test`.`title` DESC,`test`.`id` DESC,`test`.`ttt` ASC,`test`.`value` DESC database::table ( 'test', 'tid as id,tname as value' ) ->orderBy(['title,id,ttt asc','value'],'desc') ->getAll (); ~~~