db\QueryTrait orderBy()

orderBy() public method

Sets the ORDER BY part of the query.

See also addOrderBy().

public $this orderBy ( $columns )
$columns string|array|yii\db\Expression

The columns (and the directions) to be ordered by. Columns can be specified in either a string (e.g. "id ASC, name DESC") or an array (e.g. ['id' => SORT_ASC, 'name' => SORT_DESC]).

The method will automatically quote the column names unless a column contains some parenthesis (which means the column contains a DB expression).

Note that if your order-by is an expression containing commas, you should always use an array to represent the order-by information. Otherwise, the method will not be able to correctly determine the order-by columns.

Since version 2.0.7, an yii\db\Expression object can be passed to specify the ORDER BY part explicitly in plain SQL.

return $this

The query object itself

doc_Yii
2016-10-30 16:59:32
Comments
Leave a Comment

Please login to continue.