DatabaseQuery::getBindValues() method

Get bind values, with options

  • If given a \PDOStatement or DatabaseQuery, it is assumed to be the query option.
  • When copying, you may prefer to use the copyBindValuesTo() method instead (more readable).

Note: The $options argument was added in 3.0.156, prior to this it was a $method argument, which was never used so has been removed.

Usage

// basic usage
$array = $databaseQuery->getBindValues();

// usage with all arguments
$array = $databaseQuery->getBindValues($options = []);

Arguments

NameType(s)Description
options (optional)string, \PDOStatement, DatabaseQuery, array

Optionally specify an option:

  • query (\PDOStatement|DatabaseQuery): Copy bind values to this query object (default=null)
  • count (bool): Get a count of values rather than array of values (default=false) 3.0.157+
  • inSQL (string): Only get bind values referenced in this given SQL statement

Return value

array int

Returns one of the following:

  • Associative array in format [ ":column" => "value" ] where each "value" is int, string or NULL.
  • if count option specified as true then it returns a count of values instead.

DatabaseQuery methods and properties

API reference based on ProcessWire core version 3.0.244

Latest news

  • ProcessWire Weekly #560
    In the 560th issue of ProcessWire Weekly we'll check out the latest core updates, cover newly released ProcessWire modules, and more. Read on!
    Weekly.pw / 1 February 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

“We were really happy to build our new portfolio website on ProcessWire! We wanted something that gave us plenty of control on the back-end, without any bloat on the front end - just a nice, easy to access API for all our content that left us free to design and build however we liked.” —Castus, web design agency in Sheffield, UK