DatabaseQuery class

Located in file /wire/core/DatabaseQuery.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 DatabaseQuery class also inherits all the methods and properties of: WireData and Wire.

Show class?             Show args?        

Common

NameReturnSummary 
DatabaseQuery::bindKeys array 
DatabaseQuery::bindOption($optionName)
string int arrayGet or set a bind option 
DatabaseQuery::bindOptions array 
DatabaseQuery::bindValue(string $key, mixed $value)
$thisBind a parameter value 
DatabaseQuery::bindValueGetKey($value)
stringBind value and get unique key that refers to it in one step 
DatabaseQuery::bindValues array 
DatabaseQuery::copyBindValuesTo($query)
intCopy bind values from this query to another given DatabaseQuery or \PDOStatement 
DatabaseQuery::copyTo(DatabaseQuery $query)
intCopy queries from this DatabaseQuery to another DatabaseQuery 
DatabaseQuery::execute()
PDOStatement boolExecute the query with the current database handle 
DatabaseQuery::getBindValues()
array intGet bind values, with options 
DatabaseQuery::getDebugQuery()
stringGet SQL query with bind params populated for debugging purposes (not to be used as actual query) 
DatabaseQuery::getQuery()
stringGenerate the SQL query based on everything set in this DatabaseQuery object 
DatabaseQuery::getQueryMethod(string $method)
stringReturn the generated SQL for specific query method 
DatabaseQuery::getSQL()
stringReturn generated SQL for entire query or specific method 
DatabaseQuery::getUniqueBindKey()
stringGet a unique key to use for bind value 
DatabaseQuery::prepare()
PDOStatementPrepare and return a PDOStatement 
DatabaseQuery::query string 
DatabaseQuery::sql string 
DatabaseQuery::where($sql)
$this)
Can also be used as property: DatabaseQuery::where

Additional methods and properties

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

API reference based on ProcessWire core version 3.0.244

Latest news

  • ProcessWire Weekly #559
    The 559th issue of ProcessWire Weekly brings in all the latest news from the ProcessWire community. Modules, sites, and more. Read on!
    Weekly.pw / 25 January 2025
  • ProcessWire 3.0.244 new main/master version
    ProcessWire 3.0.244 is our newest main/master/stable version. It's been more than a year in the making and is packed with tons of new features, issue fixes, optimizations and more. This post covers all the details.
    Blog / 18 January 2025
  • Subscribe to weekly ProcessWire news

I just love the easy and intuitive ProcessWire API. ProcessWire rocks!” —Jens Martsch, Web developer