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

Latest news

  • ProcessWire Weekly #547
    In the 547th issue of ProcessWire Weekly we're going to check out the latest core updates, introduce a couple of new modules, and more. Read on!
    Weekly.pw / 2 November 2024
  • Custom Fields Module
    This week we look at a new ProFields module named Custom Fields. This module provides a way to rapidly build out ProcessWire fields that contain any number of subfields/properties within them.
    Blog / 30 August 2024
  • Subscribe to weekly ProcessWire news

“The end client and designer love the ease at which they can update the website. Training beyond how to log in wasn’t even necessary since ProcessWire’s default interface is straightforward.” —Jonathan Lahijani