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()
(nothing)Return 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' element 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.148

Twitter updates

  • Weekly update for Jan 10, 2020—front-end file uploads in LoginRegisterPro with InputfieldFrontendFile module: More
    10 January 2020
  • If you haven't seen it yet, be sure to check out this great infographic by @teppokoivula in ProcessWire Weekly #294— How ProcessWire professionals work—the results of our recent weekly polls summarised: weekly.pw/issue/294/#how…
    3 January 2020
  • Today we have a new master version released, 3.0.148! There are 25 new versions worth of upgrades, fixes and optimizations in this new master version, relative to the previous. In this post we take a closer look at what’s new, how to upgrade, & more— More
    3 January 2020

Newest forum posts

Latest news

  • ProcessWire Weekly #297
    In the 297th issue of ProcessWire Weekly we're going to check out the latest core updates (ProcessWire 3.0.149) and introduce a new third party module called StaticWire. Read on!
    Weekly.pw / 18 January 2020
  • ProcessWire 3.0.148 new master
    Today we have a new master version released, version 3.0.148! The last master version was 3.0.123, so there are 25 new versions worth of upgrades, fixes and optimizations in this new master version, relative to the previous. In this post we’ll take a closer look at what’s new, how to upgrade, and more.
    Blog / 3 January 2020
  • Subscribe to weekly ProcessWire news

“Yesterday I sent the client a short documentation for their ProcessWire-powered website. Today all features already used with no questions. #cmsdoneright—Marc Hinse, Web designer/developer