Member Functions
__construct
Visibility:public
Database object constructor.
__destruct
public
Database object destructor.
addQuoted
public
Adds a field or array of field names to the list that are to be quoted.
connected
public
Determines if the connection to the server is active.
debug
public
Sets the debug level on or off.
explain
public
Diagnostic function.
getAffectedRows
public
Get the affected rows by the most recent query.
getCollation
public
Get the database collation.
getConnection
public
Get the connection.
getConnectors
public
Get the database connectors.
getErrorMsg
public
Get the error message.
getErrorNum
public
Get the error number.
getEscaped
public
Get a database escaped string.
getLog
public
Get a database error log.
getNullDate
public
Get the database null date.
getNumRows
public
Get the number of rows returned by the most recent query.
getPrefix
public
Get the database table prefix.
getQuery
public
Get the current or query, or new object.
getTableCreate
public
Shows the CREATE TABLE statement that creates the given tables.
getTableFields
public
Retrieves information about the given tables.
getTableList
public
List tables in a database.
getTicker
public
Get the total number of queries made.
getUTFSupport
public
Get the database UTF-8 support.
getVersion
public
Get the version of the database connector.
hasUTF
public
Determines UTF support.
insertid
public
Get the ID generated from the previous INSERT operation.
insertObject
public
Inserts a row into a table based on an objects properties.
isQuoted
public
Checks if field name needs to be quoted.
loadAssoc
public
Fetch a result row as an associative array.
loadAssocList
public
Load a associactive list of database rows.
loadNextObject
public
Load the next row returned by the query.
loadNextRow
public
Load the next row returned by the query.
loadObject
public
This global function loads the first row of a query into an object.
loadObjectList
public
Load a list of database objects.
loadResult
public
This method loads the first field of the first row returned by the query.
loadResultArray
public
Load an array of single field results into an array.
loadRow
public
Load the first row returned by the query.
loadRowList
public
Load a list of database rows (numeric column indexing).
nameQuote
public
Quote an identifier name (field, table, etc).
query
public
Execute the query.
queryBatch
public
Execute a batch query.
quote
public
Get a quoted database escaped string.
replacePrefix
public
This function replaces a string identifier with the string held is the class variable.
setQuery
public
Sets the SQL query string for later execution.
setUTF
public
Custom settings for UTF support.
splitSql
public
Splits a string of queries into an array of individual queries.
stderr
public
Print out an error statement.
test
public
Test to see if the MySQLi connector is available.
updateObject
public
Update an object in the database.
getInstance
public static
Returns the global Database object, only creating it if it doesn't already exist.
- 6 views