$database->queryLog() method

Log a query, start/stop query logging, or return logged queries

  • To log a query, provide the $sql argument containing the query (string).
  • To retrieve the query log, call this method with no arguments.
  • Note the core only populates the query log when $config->debug mode is active.
  • Specify boolean true for $sql argument to reset and start query logging (3.0.173+)
  • Specify boolean false for $sql argument to stop query logging (3.0.173+)

Usage

// basic usage
$array = $database->queryLog();

// usage with all arguments
$array = $database->queryLog(string $sql = '', string $note = '');

Arguments

NameType(s)Description
sql (optional)string

Query (string) to log, boolean true to reset/start query logging, boolean false to stop query logging

note (optional)string

Any additional debugging notes about the query

Return value

array bool int

Returns query log array, boolean true on success, boolean false if not


$database methods and properties

API reference based on ProcessWire core version 3.0.178

Twitter updates

  • Today a new version of FormBuilder has been released in the FormBuilder support board (our 50th version) and it has a lot of interesting new features, which we’ll take a closer look at in this post— More
    11 June 2021
  • ProcessWire 3.0.179 adds great new admin theme customization tools that put you in full control over the Uikit admin styles— More
    28 May 2021
  • ProcessWire updates for week of 21 May 2021— More
    22 May 2021

Latest news

  • ProcessWire Weekly #370
    In the 370th issue of ProcessWire Weekly we're going to check out the latest version of the commercial FormBuilder module, introduce a couple of brand new third party modules, and more. Read on!
    Weekly.pw / 12 June 2021
  • ProcessWire FormBuilder v50 updates
    Today a new version of FormBuilder has been released in the FormBuilder support board (our 50th version) and it has a lot of interesting new features, which we'll take a closer look at in this post.
    Blog / 11 June 2021
  • Subscribe to weekly ProcessWire news

“…building with ProcessWire was a breeze, I really love all the flexibility the system provides. I can’t imagine using any other CMS in the future.” —Thomas Aull