$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.244

Latest news

  • ProcessWire Weekly #558
    In the 558th issue of ProcessWire Weekly we'll check out the blog post that introduces ProcessWire 3.0.244, share some recent ProcessWire highlights, and more. Read on!
    Weekly.pw / 18 January 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

I just love the easy and intuitive ProcessWire API. ProcessWire rocks!” —Jens Martsch, Web developer