• Home
• wpdb

PHP Class wpdb, versionpress

ファイルを表示 Open project: versionpress/versionpress Class Usage Examples

Public Properties

Property	Type	Description
$base_prefix	string	WordPress base table prefix.
$blog_versions	string	Multisite Blog Versions table
$blogid	integer	{@internal Missing Description}}
$blogs	string	Multisite Blogs table
$charset	string	Database table columns charset
$collate	string	Database table columns collate
$commentmeta	string	WordPress Comment Metadata table
$comments	string	WordPress Comments table
$field_types	array	Keys are column names, values are format types: 'ID' => '%d'
$func_call	string	A textual description of the last query/get_row/get_var call
$global_tables	array	List of WordPress global tables
$insert_id	integer	The ID generated for an AUTO_INCREMENT column by the previous query (usually INSERT).
$is_mysql	boolean	Set in WPDB::db_connect() to true, by default. This is used when checking against the required MySQL version for WordPress. Normally, a replacement database drop-in (db.php) will skip these checks, but setting this to true will force the checks to occur.
$last_error	string	The last error during query.
$last_query	array	Last query made
$last_result	array | null	Results of the last query made
$links	string	WordPress Links table
$ms_global_tables	array	List of Multisite global tables
$num_queries	integer	Amount of queries made
$num_rows	integer	Count of rows returned by previous query
$old_tables	array	categories, post2cat, and link2cat were deprecated in 2.3.0, db version 5539
$options	string	WordPress Options table
$postmeta	string	WordPress Post Metadata table
$posts	string	WordPress Posts table
$prefix	string	You can set this to have multiple WordPress installations in a single database. The second reason is for possible security precautions.
$queries	array	Saved queries that were executed
$ready	boolean	Whether the database queries are ready to start executing.
$registration_log	string	Multisite Registration Log table
$rows_affected	integer	Count of affected rows by previous query
$show_errors	boolean	Default behavior is to show errors if both WP_DEBUG and WP_DEBUG_DISPLAY evaluated to true.
$signups	string	Multisite Signups table
$site	string	Multisite Sites table
$sitecategories	string	Multisite Sitewide Terms table
$siteid	integer	{@internal Missing Description}}
$sitemeta	string	Multisite Site Metadata table
$suppress_errors	boolean	Whether to suppress errors during the DB bootstrapping.
$tables	array	List of WordPress per-blog tables
$term_relationships	string	WordPress Term Relationships table
$term_taxonomy	string	WordPress Term Taxonomy table
$terms	string	WordPress Terms table
$usermeta	string	WordPress User Metadata table
$users	string	WordPress Users table

Protected Properties

Property	Type	Description
$col_info	array	Saved info on the table column
$dbh	string | mysqli | resource	Database Handle
$dbhost	string	Database Host
$dbname	string	Database Name
$dbpassword	string	Database Password
$dbuser	string	Database Username
$incompatible_modes	array	A list of incompatible SQL modes.
$reconnect_retries	integer	The number of times to retry reconnecting before dying.
$result	mixed	MySQL result, which is either a resource or boolean.

Public Methods

Method	Description
__construct ( string $dbuser, string $dbpassword, string $dbname, string $dbhost )	Connects to the database server and selects a database
__destruct ( ) : boolean	PHP5 style destructor and will run when database object is destroyed.
__get ( string $name ) : mixed	PHP5 style magic getter, used to lazy-load expensive data.
__isset ( string $name ) : boolean	Magic function, for backwards compatibility.
__set ( string $name, mixed $value )	Magic function, for backwards compatibility.
__unset ( string $name )	Magic function, for backwards compatibility.
_escape ( string | array $data ) : string | array	Escape data. Works on arrays.
_insert_replace_helper ( string $table, array $data, array | string $format = null, string $type = 'INSERT' ) : integer | false	Helper function for insert and replace.
_real_escape ( string $string ) : string	Real escape, using mysqli_real_escape_string() or mysql_real_escape_string()
_weak_escape ( string $string ) : string	Do not use, deprecated.
bail ( string $message, string $error_code = '500' ) : false | void	Wraps errors in a nice header and footer and dies.
check_connection ( boolean $allow_bail = true ) : boolean	Check that the connection to the database is still up. If not, try to reconnect.
check_database_version ( ) : WP_Error	Whether MySQL database is at least the required minimum version.
db_connect ( boolean $allow_bail = true ) : boolean	Connect to and select database.
db_version ( ) : false | string	The database version number.
delete ( string $table, array $where, array | string $where_format = null ) : integer | false	Delete a row in the table
esc_like ( string $text ) : string	First half of escaping for LIKE special characters % and _ before preparing for MySQL.
escape ( mixed $data ) : mixed	Do not use, deprecated.
escape_by_ref ( string &$string ) : void	Escapes content by reference for insertion into the database, for security
flush ( ) : void	Kill cached query results.
get_blog_prefix ( integer $blog_id = null ) : string	Gets blog prefix.
get_caller ( ) : string	Retrieve the name of the function that called wpdb.
get_charset_collate ( ) : string	The database character collate.
get_col ( string | null $query = null, integer $x ) : array	Retrieve one column from the database.
get_col_info ( string $info_type = 'name', integer $col_offset ) : mixed	Retrieve column metadata from the last query.
get_results ( string $query = null, string $output = OBJECT ) : mixed	Retrieve an entire SQL result set from the database (i.e., many rows)
get_row ( string | null $query = null, string $output = OBJECT, integer $y ) : mixed	Retrieve one row from the database.
get_var ( string | null $query = null, integer $x, integer $y ) : string | null	Retrieve one variable from the database.
has_cap ( string $db_cap ) : boolean	Determine if a database supports a particular feature.
hide_errors ( ) : boolean	Disables showing of database errors.
init_charset ( )	Set $this->charset and $this->collate
insert ( string $table, array $data, array | string $format = null ) : integer | false	Insert a row into a table.
prepare ( string $query, array | mixed $args ) : null | false | string	Prepares a SQL query for safe execution. Uses sprintf()-like syntax.
print_error ( string $str = '' ) : boolean	Print SQL/DB error.
query ( string $query ) : integer | false	Perform a MySQL database query, using current database connection.
replace ( string $table, array $data, array | string $format = null ) : integer | false	Replace a row into a table.
select ( string $db, resource $dbh = null ) : null	Selects a database using the current database connection.
set_blog_id ( integer $blog_id, integer $site_id ) : string	Sets blog id.
set_charset ( resource $dbh, string $charset = null, string $collate = null )	Sets the connection's character set.
set_prefix ( string $prefix, boolean $set_table_names = true ) : string | WP_Error	Sets the table prefix for the WordPress tables.
set_sql_mode ( array $modes = [] )	Change the current SQL mode, and ensure its WordPress compatibility.
show_errors ( boolean $show = true ) : boolean	Enables showing of database errors.
supports_collation ( ) : boolean	Whether the database supports collation.
suppress_errors ( boolean $suppress = true ) : boolean	Whether to suppress database errors.
tables ( string $scope = 'all', boolean $prefix = true, integer $blog_id ) : array	Returns an array of WordPress tables.
timer_start ( ) : true	Starts the timer, for debugging purposes.
timer_stop ( ) : float	Stops the debugging timer.
update ( string $table, array $data, array $where, array | string $format = null, array | string $where_format = null ) : integer | false	Update a row in the table

Protected Methods

Method	Description
load_col_info ( )	Load the column metadata from the last query.

Private Methods

Method	Description
_do_query ( string $query )	Internal function to perform the mysql_query() call.

Method Details

Property Details