_{Official ZPE/YASS documentation}Database

Database is ZPE's driver-neutral JDBC connection structure. See Working with databases for a complete guide.

Constructor

new Database(string driver, string host, number port, string database, string username, string password) ⇒ Database

Opens a JDBC connection. An unsuccessful connection produces undefined.

Methods

is_open() ⇒ boolean

Returns whether the connection is open.

prepare(string sql) ⇒ DatabaseStatement

Creates a named prepared statement.

query(string sql, map? params) ⇒ list

Runs a query and returns each row as a map.

execute(string sql, map? params) ⇒ number

Runs an update and returns its affected-row count.

begin() ⇒ boolean

Begins a transaction.

commit() ⇒ boolean

Commits the current transaction.

rollback() ⇒ boolean

Rolls back the current transaction.

get_last_error() ⇒ string

Returns the latest JDBC error message.

close() ⇒ boolean

Closes the connection.

Example

$db = new Database("mysql", "localhost", 3306, "app", "user", "password")
$rows = $db->query("SELECT * FROM people WHERE id = :id", ["id" => 1])
$db->close()
  

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