$database->prepare() method

Prepare an SQL statement for accepting bound parameters

Usage

// basic usage
$pDOStatement = $database->prepare(string $statement);

// usage with all arguments
$pDOStatement = $database->prepare(string $statement, $driver_options = [], string $note = '');

Arguments

NameType(s)Description
statementstring
driver_options (optional)array, string, bool

Optionally specify one of the following:

  • Boolean true for WireDatabasePDOStatement rather than PDOStatement (also assumed when debug mode is on) 3.0.162+
  • Driver options array
  • or you may specify the $note argument here
note (optional)string

Debug notes to save with query in debug mode

Return value

PDOStatement WireDatabasePDOStatement


$database methods and properties

API reference based on ProcessWire core version 3.0.236

Newest forum posts

Latest news

  • ProcessWire Weekly #549
    In the 549th issue of ProcessWire Weekly we’re going to check out the latest core updates, highlight one older yet still very relevant third party module, and more. Read on!
    Weekly.pw / 17 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

“Yesterday I sent the client a short documentation for their ProcessWire-powered website. Today all features already used with no questions. #cmsdoneright—Marc Hinse, Web designer/developer