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.

Show class?             Show args?        

Common

NameReturnSummary 
DatabaseQuerySelect::comment string Comments for query 
DatabaseQuerySelect::field Field Field object that is referenced by this query. 
DatabaseQuerySelect::from($sql)
$this
Can also be used as property: DatabaseQuerySelect::from
DatabaseQuerySelect::getQuery()
stringReturn the resulting SQL ready for execution with the database 
DatabaseQuerySelect::group string Selector group (for OR-groups) if applicable. 
DatabaseQuerySelect::groupby($sql)
$this
Can also be used as property: DatabaseQuerySelect::groupby
DatabaseQuerySelect::join($sql)
$this)
Can also be used as property: DatabaseQuerySelect::join
DatabaseQuerySelect::leftjoin($sql)
$this)
Can also be used as property: DatabaseQuerySelect::leftjoin
DatabaseQuerySelect::limit($sql)
$this
Can also be used as property: DatabaseQuerySelect::limit
DatabaseQuerySelect::orderby($value)
$thisAdd 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($sql)
$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($sql)
$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

Latest news

  • ProcessWire Weekly #515
    In the 515th issue of ProcessWire Weekly we’ll check out the latest core updates, new modules, and more. Read on!
    Weekly.pw / 23 March 2024
  • Invoices Site Profile
    The new invoices site profile is a free invoicing application developed in ProcessWire. It enables you to create invoices, record payments to them, email invoices to clients, print invoices, and more. This post covers all the details.
    Blog / 15 March 2024
  • Subscribe to weekly ProcessWire news

“Indeed, if ProcessWire can be considered as a CMS in its own right, it also offers all the advantages of a CMF (Content Management Framework). Unlike other solutions, the programmer is not forced to follow the proposed model and can integrate his/her ways of doing things.” —Guy Verville, Spiria Digital Inc.