Login Register

db\QueryInterface orderBy()

orderBy() public abstract method

Sets the ORDER BY part of the query.

See also addOrderBy().

public abstract $this orderBy ( $columns )
$columns	string\|array	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).
return	$this	The query object itself

Links:

http://www.yiiframework.com/doc-2.0/yii-db-queryinterface.html#orderBy()-detail

doc_Yii

2016-10-30 16:59:27

Comments

Leave a Comment

Please login to continue.

Popular Articles

db\QueryInterface count() count() public abstract method Returns the number of records. public abstract integer count ( $q = '*', $db = null )$q string The COUNT expres

db\QueryInterface limit() limit() public abstract method Sets the LIMIT part of the query. public abstract $this limit ( $limit )$limit integer The limit. Use null or n

db\QueryInterface offset() offset() public abstract method Sets the OFFSET part of the query. public abstract $this offset ( $offset )$offset integer The offset. Use nul

db\QueryInterface andFilterWhere() andFilterWhere() public abstract method Adds an additional WHERE condition to the existing one ignoring empty parameters. The new condition and t

db\QueryInterface where() where() public abstract method Sets the WHERE part of the query. The $condition specified as an array can be in one of the following two formats: