$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

Latest news

  • ProcessWire Weekly #553
    In the 553rd issue of ProcessWire Weekly we'll check out the latest weekly update from Ryan, introduce a new third party module called Text Synthesis, and more. Read on!
    Weekly.pw / 14 December 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

“ProcessWire is like a breath of fresh air. So powerful yet simple to build with and customise, and web editors love it too.” —Margaret Chatwin, Web developer