Jamie Balfour

Welcome to my personal website.

Find out more about me, my personal projects, reviews, courses and much more here.

Official ZPE/YASS documentationDatabaseStatement

DatabaseStatement represents a named JDBC prepared statement. It is returned by Database->prepare() and is not normally created directly.

Creation

YASS
$statement = $database->prepare("SELECT * FROM people WHERE id = :id")
$statement->bind(["id" => 12])
$row = $statement->query()
  

Methods

bind(map params) ⇒ boolean
Binds values to the statement's named placeholders.
query() ⇒ list
Runs a query and returns a list of row maps.
execute() ⇒ number
Runs an update and returns its affected-row count.
is_open() ⇒ boolean
Returns whether the underlying statement remains open.
close() ⇒ boolean
Closes the prepared statement.

Its implementation was made available in ZPE 1.14.9 (Spurriergate, September 2026).

Comments

There are no comments on this page.

New comment

Comments are welcome and encouraged, including disagreement and critique. However, this is not a space for abuse. Disagreement is welcome; personal attacks, harassment, or hate will be removed instantly. This site reflects personal opinions, not universal truths. If you can’t distinguish between the two, this probably isn’t the place for you. The system temporarily stores IP addresses and browser user agents for the purposes of spam prevention, moderation, and safeguarding. This data is automatically removed after fourteen days. Your email address is stored so that replies can be sent to your email address.

Comments powered by BalfComment

Feedback 👍
Comments are sent via email to me.