DatabaseQuerySelect class

Located in file /wire/core/DatabaseQuerySelect.php

Click any linked item for full usage details and examples. Hookable methods are indicated with the icon. In addition to those shown below, the DatabaseQuerySelect class also inherits all the methods and properties of: DatabaseQuery, WireData and Wire.

Common

Name	Return	Summary
DatabaseQuerySelect::comment	`string`	Comments for query
DatabaseQuerySelect::field	`Field`	Field object that is referenced by this query.
DatabaseQuerySelect::from() DatabaseQuerySelect::from($sql) DatabaseQuerySelect::from($sql)	`$this`	Can also be used as property: DatabaseQuerySelect::from
DatabaseQuerySelect::getQuery() DatabaseQuerySelect::getQuery() DatabaseQuerySelect::getQuery()	`string`	Return the resulting SQL ready for execution with the database
DatabaseQuerySelect::group	`string`	Selector group (for OR-groups) if applicable.
DatabaseQuerySelect::groupby() DatabaseQuerySelect::groupby($sql) DatabaseQuerySelect::groupby($sql)	`$this`	Can also be used as property: DatabaseQuerySelect::groupby
DatabaseQuerySelect::join() DatabaseQuerySelect::join($sql) DatabaseQuerySelect::join($sql, $params = array)	`$this`	) Can also be used as property: DatabaseQuerySelect::join
DatabaseQuerySelect::leftjoin() DatabaseQuerySelect::leftjoin($sql) DatabaseQuerySelect::leftjoin($sql, $params = array)	`$this`	) Can also be used as property: DatabaseQuerySelect::leftjoin
DatabaseQuerySelect::limit() DatabaseQuerySelect::limit($sql) DatabaseQuerySelect::limit($sql)	`$this`	Can also be used as property: DatabaseQuerySelect::limit
DatabaseQuerySelect::orderby() DatabaseQuerySelect::orderby($value) DatabaseQuerySelect::orderby($value, bool $prepend = false)	`$this`	Add an ORDER BY section to the query Can also be used as property: DatabaseQuerySelect::orderby
DatabaseQuerySelect::parentQuery	`DatabaseQuerySelect`	Parent query object, if applicable.
DatabaseQuerySelect::select() DatabaseQuerySelect::select($sql) DatabaseQuerySelect::select($sql, $params = array)	`$this`	) Can also be used as property: DatabaseQuerySelect::select
DatabaseQuerySelect::selector	`Selector`	Selector object referenced by this query.
DatabaseQuerySelect::selectors	`Selectors`	Original selectors (all) that $selector is part of.
DatabaseQuerySelect::where() DatabaseQuerySelect::where($sql) DatabaseQuerySelect::where($sql, $params = array)	`$this`	) Can also be used as property: DatabaseQuerySelect::where

Additional methods and properties

In addition to the methods and properties above, DatabaseQuerySelect also inherits the methods and properties of these classes:

API reference based on ProcessWire core version 3.0.236

Located in file /wire/core/DatabaseQuerySelect.php

Common

Additional methods and properties

Newest forum posts

Latest news

Subscribe to weekly ProcessWire news