fDatabaseclassv1.0.0b22

Configures the connection to a database - connection is not made until the first query is executed

Clears all of the schema info out of the object and, if set, the fCache object

Sets the schema info to be cached to the fCache object specified

Sets if debug messages should be shown

Sets a flag to trigger a PHP warning message whenever a query takes longer than the millisecond threshold specified

It is recommended to use the error handling features of fCore::enableErrorHandling() to log or email these warnings.

Escapes a value for insertion into SQL

The valid data types are:

• 'blob'
• 'boolean'
• 'date'
• 'float'
• 'identifier'
• 'integer'
• 'string' (also varchar, char or text)
• 'varchar'
• 'char'
• 'text'
• 'time'
• 'timestamp'

In addition to being able to specify the data type, you can also pass in an SQL statement with data type placeholders in the following form:

• %l for a blob
• %b for a boolean
• %d for a date
• %f for a float
• %r for an indentifier (table or column name)
• %i for an integer
• %s for a string
• %t for a time
• %p for a timestamp

Depending on what $sql_or_type and $value are, the output will be slightly different. If $sql_or_type is a data type or a single placeholder and $value is:

• a scalar value - an escaped SQL string is returned
• an array - an array of escaped SQL strings is returned

If $sql_or_type is a SQL string and $value is:

• a scalar value - the escaped value is inserted into the SQL string
• an array - the escaped values are inserted into the SQL string separated by commas

If $sql_or_type is a SQL string, it is also possible to pass an array of all values as a single parameter instead of one value per parameter. An example would look like the following:

$db->escape(
    "SELECT * FROM users WHERE status = %s AND authorization_level = %s",
    array('Active', 'Admin')
);

Executes one or more SQL queries without returning any results

Returns the database connection resource or object

Gets the name of the database currently connected to

Gets the host for this database

Gets the port for this database

Gets the fSQLTranslation object used for translated queries

Gets the database type

Gets the username for this database

Will indicate if a transaction is currently in progress

Prepares a single fStatement object to execute prepared statements

Identifier placeholders (%r) are not supported with prepared statements. In addition, multiple values can not be escaped by a placeholder - only a single value can be provided.

Executes one or more SQL queries and returns the result(s)

Translates one or more SQL statements using fSQLTranslation and executes them without returning any results

Translates a SQL statement and creates an fStatement object from it

Identifier placeholders (%r) are not supported with prepared statements. In addition, multiple values can not be escaped by a placeholder - only a single value can be provided.

Translates one or more SQL statements using fSQLTranslation and executes them

Executes a single SQL statement in unbuffered mode. This is optimal for

large results sets since it does not load the whole result set into memory first. The gotcha is that only one unbuffered result can exist at one time. If another unbuffered query is executed, the old result will be deleted.

Translates the SQL statement using fSQLTranslation and then executes it

in unbuffered mode. This is optimal for large results sets since it does not load the whole result set into memory first. The gotcha is that only one unbuffered result can exist at one time. If another unbuffered query is executed, the old result will be deleted.

Unescapes a value coming out of a database based on its data type

The valid data types are:

• 'blob' (or '%l')
• 'boolean' (or '%b')
• 'date' (or '%d')
• 'float' (or '%f')
• 'integer' (or '%i')
• 'string' (also '%s', 'varchar', 'char' or 'text')
• 'time' (or '%t')
• 'timestamp' (or '%p')