ratatoeskr/sys/db.php

Helper functions for dealing with MySQL.

This file is part of Ratatöskr. Ratatöskr is licensed unter the MIT / X11 License. See “ratatoeskr/licenses/ratatoeskr” for more information.

Summary

ratatoeskr/sys/db.php	Helper functions for dealing with MySQL.
Functions
db_connect	Establish a connection to the MySQL database.
sub_prefix	Substitutes “PREFIX_” in the input string with the prefix from the config.
prep_stmt	Prepares a SQL statement using the global DB connection.
qdb	Prepares statement (1st argument) with prep_stmt and executes it with the remaining arguments.
Transaction	Makes using transactions easier.
Functions
__construct	Start a new transaction.
commit	Commit the transaction.
rollback	Toll the transaction back.

function db_connect()

Establish a connection to the MySQL database.

function sub_prefix( $q )

Substitutes “PREFIX_” in the input string with the prefix from the config.

function prep_stmt( $q )

Prepares a SQL statement using the global DB connection. This will also replace “PREFIX_” with the prefix defined in ‘config.php’.

$q	The query / statement to prepare.

A PDOStatement object.

function qdb()

Prepares statement (1st argument) with prep_stmt and executes it with the remaining arguments.

A PDOStatement object.

Transaction

Makes using transactions easier.

Summary

public function __construct()

Start a new transaction.

public function commit()

Commit the transaction.

public function rollback()

Toll the transaction back.