Database - rbertram90/core GitHub Wiki

Summary

Documentation for src/Database.php

Supply connection information and get database connection object in return

PDO connect(string $server, string $name, string $user, string $password)

Get the current database connection object - connect() must have already been called

PDO getConnection()

Get the ID of the last insert into the database. Note - has limited use as a public method as needs to be called within database transaction.

int getLastInsertID()

Run a raw sql string - recommended to use the helper functions for simple queries and this for more complicated ones

PDOStatement query(string $queryString)

Run prepared statement SQL (that is already formatted with placeholders) with $values to pass through. Returns the result of the execution

PDOStatement runPreparedStatement(string $queryString, array $values)

Select a single row from database as an associative array $columnsToSelect can be passed as an array or a string (e.g. '*')

array selectSingleRow(string $tableName, mixed $columnsToSelect, array $where[, string $strOrderBy = '' [, string $strLimit='']])

Select multiple rows from database as a multi-dimentional associative array $columnsToSelect can be passed as an array or a string (e.g. '*')

array selectMultipleRows(string $tableName, mixed $columnsToSelect, array $where, [string $strOrderBy = '' [, string $strLimit='']])

Shorthand method for selecting all rows in a table

array selectAllRows(string $tableName, mixed $columnsToSelect, [string $strOrderBy = ''])

Get a row count

int countRows(string $tableName, array $where='')

Insert a new row into a database table. Returns true if successful, false otherwise

bool insertRow(string $tableName, array $values)

Update existing row(s) in a database table. Returns true if successful, false otherwise

bool updateRow(string $tableName, array $where, array $values)

Delete row(s) in a database table

PDOStatement deleteRow(string $tableName, array $where)