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.236

Latest news

  • ProcessWire Weekly #519
    In the 519th issue of ProcessWire Weekly we'll check out a new third party module called RockForms, introduce the latest ProcessWire core updates, and more. Read on!
    Weekly.pw / 20 April 2024
  • ProFields Table Field with Actions support
    This week we have some updates for the ProFields table field (FieldtypeTable). These updates are primarily focused on adding new tools for the editor to facilitate input and management of content in a table field.
    Blog / 12 April 2024
  • Subscribe to weekly ProcessWire news

“We chose ProcessWire because of its excellent architecture, modular extensibility and the internal API. The CMS offers the necessary flexibility and performance for such a complex website like superbude.de. ProcessWire offers options that are only available for larger systems, such as Drupal, and allows a much slimmer development process.” —xport communication GmbH