Property | Type | Description | |
---|---|---|---|
$check_tcp_responsiveness | boolean | Whether to check with fsockopen prior to mysql_connect. | |
$db_connections | array | The log of db connections made and the time each one took | |
$dbh | resource | The current mysql link resource | |
$dbh2host | array | Lookup array (dbhname => host:port) | |
$dbhs | array | Associative array (dbhname => dbh) for established mysql connections | |
$default_lag_threshold | integer | Maximum lag in seconds. Set null to disable. Requires callbacks. | |
$hyper_callbacks | array | Optional directory of callbacks to determine datasets from queries | |
$hyper_servers | array | The multi-dimensional array of datasets and servers | |
$hyper_tables | array | Optional directory of tables and their datasets | |
$last_found_rows_result | resource | After any SQL_CALC_FOUND_ROWS query, the query "SELECT FOUND_ROWS()" is sent and the mysql result resource stored here. The next query for FOUND_ROWS() will retrieve this. We do this to prevent any intervening queries from making FOUND_ROWS() inaccessible. You may prevent this by adding "NO_SELECT_FOUND_ROWS" in a comment. | |
$last_table | string | The last table that was queried | |
$last_used_server | array | The last server used and the database name selected | |
$max_connections | integer | The maximum number of db links to keep open. The least-recently used link will be closed when the number of links exceeds this. | |
$min_tries | integer | Minimum number of connections to try before bailing | |
$open_connections | The list of unclosed connections sorted by LRU | ||
$persistent | boolean | Whether to use mysql_pconnect instead of mysql_connect | |
$save_backtrace | Whether to save debug_backtrace in save_query_callback. You may wish to disable this, e.g. when tracing out-of-memory problems. | ||
$save_queries | boolean | Whether to store queries in an array. Useful for debugging and profiling. | |
$save_query_callback | callable | Custom callback to save debug info in $this->queries | |
$srtm | array | Otherwise it is an array of written tables. | |
$used_servers | array | Lookup array (dbhname => (server, db name) ) for re-selecting the db when a link is re-used. |
Method | Description | |
---|---|---|
__construct ( $args = null ) | Gets ready to make database connections | |
_real_escape ( $string ) | * Force addslashes() for the escapes. | |
add_callback ( $callback, $group = 'dataset' ) | Add a callback to a group of callbacks. | |
add_database ( $db ) | Add the connection parameters for a database | |
add_table ( $dataset, $table ) | Specify the dateset where a table is found | |
check_database_version ( $dbh_or_table = false ) : WP_Error | Whether or not MySQL database is at least the required minimum version. | |
check_lag ( ) | ||
check_tcp_responsiveness ( $host, $port, $float_timeout ) : (bool) | Check the responsiveness of a tcp/ip daemon | |
db_connect ( $query = '' ) : resource | Figure out which database server should handle the query, and connect to it. | |
db_version ( false | string | resource $dbh_or_table = false ) : false | string | The database version number | |
disconnect ( $dbhname ) | Disconnect and remove connection from open connections list | |
flush ( ) | Kill cached query results | |
get_caller ( ) : string | Get the name of the function that called wpdb. | |
get_lag ( ) | ||
get_lag_cache ( ) | ||
get_table_from_query ( $q ) : string | Find the first table name referenced in a query | |
has_cap ( string $db_cap, false | string | resource $dbh_or_table = false ) : boolean | Generic function to determine if a database supports a particular feature The additional argument allows the caller to check a specific database. | |
hyperdb ( $args = null ) | Triggers __construct() for backwards compatibility with PHP4 | |
init_charset ( ) | Sets $this->charset and $this->collate | |
is_write_query ( $q ) : boolean | Determine the likelihood that this query could alter anything | |
query ( string $query ) : integer | Basic query. See docs for more details. | |
run_callbacks ( $group, $args = null ) | Callbacks are executed in the order in which they are registered until one of them returns something other than null. | |
send_reads_to_masters ( ) | Set a flag to prevent reading from slaves which might be lagging after a write | |
set_charset ( resource $dbh, string $charset = null, string $collate = null ) | Sets the connection's character set. | |
supports_collation ( $dbh_or_table = false ) : boolean | This function is called when WordPress is generating the table schema to determine wether or not the current database supports or needs the collation statements. |
public __construct ( $args = null ) |
public _real_escape ( $string ) |
public add_callback ( $callback, $group = 'dataset' ) |
public add_database ( $db ) |
public add_table ( $dataset, $table ) |
public check_database_version ( $dbh_or_table = false ) : WP_Error | ||
return | WP_Error |
public check_tcp_responsiveness ( $host, $port, $float_timeout ) : (bool) | ||
return | (bool) |
public db_connect ( $query = '' ) : resource | ||
return | resource | mysql database connection |
public db_version ( false | string | resource $dbh_or_table = false ) : false | string | ||
$dbh_or_table | false | string | resource | the databaese (the current database, the database housing the specified table, or the database of the mysql resource) |
return | false | string | false on failure, version number on success |
public disconnect ( $dbhname ) |
public get_caller ( ) : string | ||
return | string | the name of the calling function |
public get_table_from_query ( $q ) : string | ||
return | string | table |
public hyperdb ( $args = null ) |
public is_write_query ( $q ) : boolean | ||
return | boolean |
public run_callbacks ( $group, $args = null ) |
public send_reads_to_masters ( ) |
public set_charset ( resource $dbh, string $charset = null, string $collate = null ) | ||
$dbh | resource | The resource given by mysql_connect |
$charset | string | The character set (optional) |
$collate | string | The collation (optional) |
public supports_collation ( $dbh_or_table = false ) : boolean | ||
return | boolean |
public bool $check_tcp_responsiveness | ||
return | boolean |
public array $db_connections | ||
return | array |
public array $dbhs | ||
return | array |
public int $default_lag_threshold | ||
return | integer |
public array $hyper_callbacks | ||
return | array |
public array $hyper_servers | ||
return | array |
public array $hyper_tables | ||
return | array |
public resource $last_found_rows_result | ||
return | resource |
public array $last_used_server | ||
return | array |
public int $max_connections | ||
return | integer |
public int $min_tries | ||
return | integer |
public $open_connections |
public bool $persistent | ||
return | boolean |
public $save_backtrace |
public bool $save_queries | ||
return | boolean |
public callable $save_query_callback | ||
return | callable |
public array $used_servers | ||
return | array |