The last error during query.

• since: 1.0

PHP5 style constructor

Grabs the arguments, calls bpdb::_init() and then connects to the database

• since: 1.0

• BPDB_Multi::__construct()

PHP5 style destructor, registered as shutdown function in PHP4

• return: Always returns true
• since: 1.0

Whether or not MySQL database is at least the required minimum version.

• since: 1.0

• $dbh_or_table

Connects to the database server and selects a database

• return: void if cannot connect, false if cannot select, true if success
• since: 1.0

• array $args: args name => string DB name (required) user => string DB user (optional: false) password => string DB user password (optional: false) host => string DB hostname (optional: 'localhost') charset => string DB default charset. Used in a SET NAMES query. (optional) collate => string DB default collation. If charset supplied, optionally added to the SET NAMES query (optional)

Escapes content for insertion into the database using addslashes(), for security

• return: query safe string
• since: 1.0

• string|array $data

Escapes array recursively for insertion into the database, for security

• array $array

Retrieve the name of the function that called bpdb.

Requires PHP 4.3 and searches up the list of functions until it reaches the one that would most logically had called this method.

• return: The name of the calling function
• since: 1.0

Retrieve column metadata from the last query.

• return: Column Results
• since: 1.0

• string $info_type: one of name, table, def, max_length, not_null, primary_key, multiple_key, unique_key, numeric, blob, type, unsigned, zerofill
• int $col_offset: 0: col name. 1: which table the col's in. 2: col's max length. 3: if the col is numeric. 4: col's type

Retrieve an entire SQL result set from the database (i.e., many rows)

Executes a SQL query and returns the entire SQL result.

• return: Database query results
• since: 1.0

• string $query: SQL query.
• string $output: (optional) ane of ARRAY_A | ARRAY_N | OBJECT | OBJECT_K | ARRAY_K constants. With one of the first three, return an array of rows indexed from 0 by SQL result row number. Each row is an associative array (column => value, ...), a numerically indexed array (0 => value, ...), or an object. ( ->column = value ), respectively. With OBJECT_K and ARRAY_K, return an associative array of row objects keyed by the value of each row's first column's value. Duplicate keys are discarded.

Retrieve one variable from the database.

Executes a SQL query and returns the value from the SQL result. If the SQL result contains more than one column and/or more than one row, this function returns the value in the column and row specified. If $query is null, this function returns the value in the specified column and row from the previous SQL result.

• return: Database query result
• since: 1.0

• string|null $query: SQL query. If null, use the result from the previous query.
• int $x: (optional) Column of value to return. Indexed from 0.
• int $y: (optional) Row of value to return. Indexed from 0.

Disables showing of database errors.

• return: Whether showing of errors was active or not
• since: 1.0

Prepares a SQL query for safe execution. Uses sprintf()-like syntax.

This function only supports a small subset of the sprintf syntax; it only supports %d (decimal number), %s (string). Does not support sign, padding, alignment, width or precision specifiers. Does not support argument numbering/swapping.

May be called like sprintf() or like vsprintf().

Both %d and %s should be left unquoted in the query string.

• return: Sanitized query string
• link: Description of syntax.
• since: 1.0

• string $query: Query statement with sprintf()-like placeholders
• array|mixed $args: The array of variables to substitute into the query's placeholders if being called like vsprintf(), or the first variable to substitute into the query's placeholders if being called like sprintf().
• mixed $args,...: further variables to substitute into the query's placeholders if being called like sprintf().

Perform a MySQL database query, using current database connection.

More information can be found on the codex page.

• return: Number of rows affected/selected or false on error
• since: 1.0

• string $query
• $use_current

Sets the table prefix for the WordPress tables.

• return: the previous prefix (mostly only meaningful if all $table parameter was false)
• since: 1.0

• string $prefix: prefix
• false|array $tables: tables (optional: false) table identifiers are array keys array values empty: set prefix: array( 'posts' => false, 'users' => false, ... ) string: set to that array value: array( 'posts' => 'my_posts', 'users' => 'my_users' ) OR array values (with numeric keys): array( 'posts', 'users', ... )

• BPDB_Multi::set_prefix() : Sets the prefix of the database tables

Whether of not the database supports collation.

Called when BackPress is generating the table scheme.

• return: True if collation is supported, false if version does not
• since: 1.0

Starts the timer, for debugging purposes.

• since: 1.0

Update a row in the table

• return: The number of rows updated, or false on error.
• see: bpdb::prepare()
• since: 1.0

• string $table: table name
• array $data: Data to update (in column => value pairs). Both $data columns and $data values should be "raw" (neither should be SQL escaped).
• array $where: A named array of WHERE clauses (in column => value pairs). Multiple clauses will be joined with ANDs. Both $where columns and $where values should be "raw".
• array|string $format: (optional) An array of formats to be mapped to each of the values in $data. If string, that format will be used for all of the values in $data. A format is one of '%d', '%s' (decimal number, string). If omitted, all values in $data will be treated as strings.
• array|string $format_where: (optional) An array of formats to be mapped to each of the values in $where. If string, that format will be used for all of the items in $where. A format is one of '%d', '%s' (decimal number, string). If omitted, all values in $where will be treated as strings.
• $where_format

Initialises the class variables based on provided arguments

• return: The current connection settings after processing by init
• since: 1.0

• array $args: The provided connection settings

• $string