<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* WordPress database access abstraction class.

[2] Fix | Delete

*

[3] Fix | Delete

* Original code from {@link http://php.justinvincent.com Justin Vincent (justin@visunet.ie)}

[4] Fix | Delete

*

[5] Fix | Delete

* @package WordPress

[6] Fix | Delete

* @subpackage Database

[7] Fix | Delete

* @since 0.71

[8] Fix | Delete

*/

[9] Fix | Delete

[10] Fix | Delete

/**

[11] Fix | Delete

* @since 0.71

[12] Fix | Delete

*/

[13] Fix | Delete

define( 'EZSQL_VERSION', 'WP1.25' );

[14] Fix | Delete

[15] Fix | Delete

/**

[16] Fix | Delete

* @since 0.71

[17] Fix | Delete

*/

[18] Fix | Delete

define( 'OBJECT', 'OBJECT' );

[19] Fix | Delete

// phpcs:ignore Generic.NamingConventions.UpperCaseConstantName.ConstantNotUpperCase

[20] Fix | Delete

define( 'object', 'OBJECT' ); // Back compat.

[21] Fix | Delete

[22] Fix | Delete

/**

[23] Fix | Delete

* @since 2.5.0

[24] Fix | Delete

*/

[25] Fix | Delete

define( 'OBJECT_K', 'OBJECT_K' );

[26] Fix | Delete

[27] Fix | Delete

/**

[28] Fix | Delete

* @since 0.71

[29] Fix | Delete

*/

[30] Fix | Delete

define( 'ARRAY_A', 'ARRAY_A' );

[31] Fix | Delete

[32] Fix | Delete

/**

[33] Fix | Delete

* @since 0.71

[34] Fix | Delete

*/

[35] Fix | Delete

define( 'ARRAY_N', 'ARRAY_N' );

[36] Fix | Delete

[37] Fix | Delete

/**

[38] Fix | Delete

* WordPress database access abstraction class.

[39] Fix | Delete

*

[40] Fix | Delete

* This class is used to interact with a database without needing to use raw SQL statements.

[41] Fix | Delete

* By default, WordPress uses this class to instantiate the global $wpdb object, providing

[42] Fix | Delete

* access to the WordPress database.

[43] Fix | Delete

*

[44] Fix | Delete

* It is possible to replace the global instance with your own by setting the $wpdb global variable

[45] Fix | Delete

* in wp-content/db.php file to your class. The wpdb class will still be included, so you can

[46] Fix | Delete

* extend it or simply use your own.

[47] Fix | Delete

*

[48] Fix | Delete

* @link https://developer.wordpress.org/reference/classes/wpdb/

[49] Fix | Delete

*

[50] Fix | Delete

* @since 0.71

[51] Fix | Delete

*/

[52] Fix | Delete

#[AllowDynamicProperties]

[53] Fix | Delete

class wpdb {

[54] Fix | Delete

[55] Fix | Delete

/**

[56] Fix | Delete

* Whether to show SQL/DB errors.

[57] Fix | Delete

*

[58] Fix | Delete

* Default is to show errors if both WP_DEBUG and WP_DEBUG_DISPLAY evaluate to true.

[59] Fix | Delete

*

[60] Fix | Delete

* @since 0.71

[61] Fix | Delete

*

[62] Fix | Delete

* @var bool

[63] Fix | Delete

*/

[64] Fix | Delete

public $show_errors = false;

[65] Fix | Delete

[66] Fix | Delete

/**

[67] Fix | Delete

* Whether to suppress errors during the DB bootstrapping. Default false.

[68] Fix | Delete

*

[69] Fix | Delete

* @since 2.5.0

[70] Fix | Delete

*

[71] Fix | Delete

* @var bool

[72] Fix | Delete

*/

[73] Fix | Delete

public $suppress_errors = false;

[74] Fix | Delete

[75] Fix | Delete

/**

[76] Fix | Delete

* The error encountered during the last query.

[77] Fix | Delete

*

[78] Fix | Delete

* @since 2.5.0

[79] Fix | Delete

*

[80] Fix | Delete

* @var string

[81] Fix | Delete

*/

[82] Fix | Delete

public $last_error = '';

[83] Fix | Delete

[84] Fix | Delete

/**

[85] Fix | Delete

* The number of queries made.

[86] Fix | Delete

*

[87] Fix | Delete

* @since 1.2.0

[88] Fix | Delete

*

[89] Fix | Delete

* @var int

[90] Fix | Delete

*/

[91] Fix | Delete

public $num_queries = 0;

[92] Fix | Delete

[93] Fix | Delete

/**

[94] Fix | Delete

* Count of rows returned by the last query.

[95] Fix | Delete

*

[96] Fix | Delete

* @since 0.71

[97] Fix | Delete

*

[98] Fix | Delete

* @var int

[99] Fix | Delete

*/

[100] Fix | Delete

public $num_rows = 0;

[101] Fix | Delete

[102] Fix | Delete

/**

[103] Fix | Delete

* Count of rows affected by the last query.

[104] Fix | Delete

*

[105] Fix | Delete

* @since 0.71

[106] Fix | Delete

*

[107] Fix | Delete

* @var int

[108] Fix | Delete

*/

[109] Fix | Delete

public $rows_affected = 0;

[110] Fix | Delete

[111] Fix | Delete

/**

[112] Fix | Delete

* The ID generated for an AUTO_INCREMENT column by the last query (usually INSERT).

[113] Fix | Delete

*

[114] Fix | Delete

* @since 0.71

[115] Fix | Delete

*

[116] Fix | Delete

* @var int

[117] Fix | Delete

*/

[118] Fix | Delete

public $insert_id = 0;

[119] Fix | Delete

[120] Fix | Delete

/**

[121] Fix | Delete

* The last query made.

[122] Fix | Delete

*

[123] Fix | Delete

* @since 0.71

[124] Fix | Delete

*

[125] Fix | Delete

* @var string

[126] Fix | Delete

*/

[127] Fix | Delete

public $last_query;

[128] Fix | Delete

[129] Fix | Delete

/**

[130] Fix | Delete

* Results of the last query.

[131] Fix | Delete

*

[132] Fix | Delete

* @since 0.71

[133] Fix | Delete

*

[134] Fix | Delete

* @var stdClass[]|null

[135] Fix | Delete

*/

[136] Fix | Delete

public $last_result;

[137] Fix | Delete

[138] Fix | Delete

/**

[139] Fix | Delete

* Database query result.

[140] Fix | Delete

*

[141] Fix | Delete

* Possible values:

[142] Fix | Delete

*

[143] Fix | Delete

* - `mysqli_result` instance for successful SELECT, SHOW, DESCRIBE, or EXPLAIN queries

[144] Fix | Delete

* - `true` for other query types that were successful

[145] Fix | Delete

* - `null` if a query is yet to be made or if the result has since been flushed

[146] Fix | Delete

* - `false` if the query returned an error

[147] Fix | Delete

*

[148] Fix | Delete

* @since 0.71

[149] Fix | Delete

*

[150] Fix | Delete

* @var mysqli_result|bool|null

[151] Fix | Delete

*/

[152] Fix | Delete

protected $result;

[153] Fix | Delete

[154] Fix | Delete

/**

[155] Fix | Delete

* Cached column info, for confidence checking data before inserting.

[156] Fix | Delete

*

[157] Fix | Delete

* @since 4.2.0

[158] Fix | Delete

*

[159] Fix | Delete

* @var array

[160] Fix | Delete

*/

[161] Fix | Delete

protected $col_meta = array();

[162] Fix | Delete

[163] Fix | Delete

/**

[164] Fix | Delete

* Calculated character sets keyed by table name.

[165] Fix | Delete

*

[166] Fix | Delete

* @since 4.2.0

[167] Fix | Delete

*

[168] Fix | Delete

* @var string[]

[169] Fix | Delete

*/

[170] Fix | Delete

protected $table_charset = array();

[171] Fix | Delete

[172] Fix | Delete

/**

[173] Fix | Delete

* Whether text fields in the current query need to be confidence checked.

[174] Fix | Delete

*

[175] Fix | Delete

* @since 4.2.0

[176] Fix | Delete

*

[177] Fix | Delete

* @var bool

[178] Fix | Delete

*/

[179] Fix | Delete

protected $check_current_query = true;

[180] Fix | Delete

[181] Fix | Delete

/**

[182] Fix | Delete

* Flag to ensure we don't run into recursion problems when checking the collation.

[183] Fix | Delete

*

[184] Fix | Delete

* @since 4.2.0

[185] Fix | Delete

*

[186] Fix | Delete

* @see wpdb::check_safe_collation()

[187] Fix | Delete

* @var bool

[188] Fix | Delete

*/

[189] Fix | Delete

private $checking_collation = false;

[190] Fix | Delete

[191] Fix | Delete

/**

[192] Fix | Delete

* Saved info on the table column.

[193] Fix | Delete

*

[194] Fix | Delete

* @since 0.71

[195] Fix | Delete

*

[196] Fix | Delete

* @var array

[197] Fix | Delete

*/

[198] Fix | Delete

protected $col_info;

[199] Fix | Delete

[200] Fix | Delete

/**

[201] Fix | Delete

* Log of queries that were executed, for debugging purposes.

[202] Fix | Delete

*

[203] Fix | Delete

* @since 1.5.0

[204] Fix | Delete

* @since 2.5.0 The third element in each query log was added to record the calling functions.

[205] Fix | Delete

* @since 5.1.0 The fourth element in each query log was added to record the start time.

[206] Fix | Delete

* @since 5.3.0 The fifth element in each query log was added to record custom data.

[207] Fix | Delete

*

[208] Fix | Delete

* @var array[] {

[209] Fix | Delete

* Array of arrays containing information about queries that were executed.

[210] Fix | Delete

*

[211] Fix | Delete

* @type array ...$0 {

[212] Fix | Delete

* Data for each query.

[213] Fix | Delete

*

[214] Fix | Delete

* @type string $0 The query's SQL.

[215] Fix | Delete

* @type float $1 Total time spent on the query, in seconds.

[216] Fix | Delete

* @type string $2 Comma-separated list of the calling functions.

[217] Fix | Delete

* @type float $3 Unix timestamp of the time at the start of the query.

[218] Fix | Delete

* @type array $4 Custom query data.

[219] Fix | Delete

* }

[220] Fix | Delete

* }

[221] Fix | Delete

*/

[222] Fix | Delete

public $queries;

[223] Fix | Delete

[224] Fix | Delete

/**

[225] Fix | Delete

* The number of times to retry reconnecting before dying. Default 5.

[226] Fix | Delete

*

[227] Fix | Delete

* @since 3.9.0

[228] Fix | Delete

*

[229] Fix | Delete

* @see wpdb::check_connection()

[230] Fix | Delete

* @var int

[231] Fix | Delete

*/

[232] Fix | Delete

protected $reconnect_retries = 5;

[233] Fix | Delete

[234] Fix | Delete

/**

[235] Fix | Delete

* WordPress table prefix.

[236] Fix | Delete

*

[237] Fix | Delete

* You can set this to have multiple WordPress installations in a single database.

[238] Fix | Delete

*

[239] Fix | Delete

* @since 2.5.0

[240] Fix | Delete

*

[241] Fix | Delete

* @var string

[242] Fix | Delete

*/

[243] Fix | Delete

public $prefix = '';

[244] Fix | Delete

[245] Fix | Delete

/**

[246] Fix | Delete

* WordPress base table prefix.

[247] Fix | Delete

*

[248] Fix | Delete

* @since 3.0.0

[249] Fix | Delete

*

[250] Fix | Delete

* @var string

[251] Fix | Delete

*/

[252] Fix | Delete

public $base_prefix;

[253] Fix | Delete

[254] Fix | Delete

/**

[255] Fix | Delete

* Whether the database queries are ready to start executing.

[256] Fix | Delete

*

[257] Fix | Delete

* @since 2.3.2

[258] Fix | Delete

*

[259] Fix | Delete

* @var bool

[260] Fix | Delete

*/

[261] Fix | Delete

public $ready = false;

[262] Fix | Delete

[263] Fix | Delete

/**

[264] Fix | Delete

* Blog ID.

[265] Fix | Delete

*

[266] Fix | Delete

* @since 3.0.0

[267] Fix | Delete

*

[268] Fix | Delete

* @var int

[269] Fix | Delete

*/

[270] Fix | Delete

public $blogid = 0;

[271] Fix | Delete

[272] Fix | Delete

/**

[273] Fix | Delete

* Site ID.

[274] Fix | Delete

*

[275] Fix | Delete

* @since 3.0.0

[276] Fix | Delete

*

[277] Fix | Delete

* @var int

[278] Fix | Delete

*/

[279] Fix | Delete

public $siteid = 0;

[280] Fix | Delete

[281] Fix | Delete

/**

[282] Fix | Delete

* List of WordPress per-site tables.

[283] Fix | Delete

*

[284] Fix | Delete

* @since 2.5.0

[285] Fix | Delete

*

[286] Fix | Delete

* @see wpdb::tables()

[287] Fix | Delete

* @var string[]

[288] Fix | Delete

*/

[289] Fix | Delete

public $tables = array(

[290] Fix | Delete

'posts',

[291] Fix | Delete

'comments',

[292] Fix | Delete

'links',

[293] Fix | Delete

'options',

[294] Fix | Delete

'postmeta',

[295] Fix | Delete

'terms',

[296] Fix | Delete

'term_taxonomy',

[297] Fix | Delete

'term_relationships',

[298] Fix | Delete

'termmeta',

[299] Fix | Delete

'commentmeta',

[300] Fix | Delete

);

[301] Fix | Delete

[302] Fix | Delete

/**

[303] Fix | Delete

* List of deprecated WordPress tables.

[304] Fix | Delete

*

[305] Fix | Delete

* 'categories', 'post2cat', and 'link2cat' were deprecated in 2.3.0, db version 5539.

[306] Fix | Delete

*

[307] Fix | Delete

* @since 2.9.0

[308] Fix | Delete

*

[309] Fix | Delete

* @see wpdb::tables()

[310] Fix | Delete

* @var string[]

[311] Fix | Delete

*/

[312] Fix | Delete

public $old_tables = array( 'categories', 'post2cat', 'link2cat' );

[313] Fix | Delete

[314] Fix | Delete

/**

[315] Fix | Delete

* List of WordPress global tables.

[316] Fix | Delete

*

[317] Fix | Delete

* @since 3.0.0

[318] Fix | Delete

*

[319] Fix | Delete

* @see wpdb::tables()

[320] Fix | Delete

* @var string[]

[321] Fix | Delete

*/

[322] Fix | Delete

public $global_tables = array( 'users', 'usermeta' );

[323] Fix | Delete

[324] Fix | Delete

/**

[325] Fix | Delete

* List of Multisite global tables.

[326] Fix | Delete

*

[327] Fix | Delete

* @since 3.0.0

[328] Fix | Delete

*

[329] Fix | Delete

* @see wpdb::tables()

[330] Fix | Delete

* @var string[]

[331] Fix | Delete

*/

[332] Fix | Delete

public $ms_global_tables = array(

[333] Fix | Delete

'blogs',

[334] Fix | Delete

'blogmeta',

[335] Fix | Delete

'signups',

[336] Fix | Delete

'site',

[337] Fix | Delete

'sitemeta',

[338] Fix | Delete

'registration_log',

[339] Fix | Delete

);

[340] Fix | Delete

[341] Fix | Delete

/**

[342] Fix | Delete

* List of deprecated WordPress Multisite global tables.

[343] Fix | Delete

*

[344] Fix | Delete

* @since 6.1.0

[345] Fix | Delete

*

[346] Fix | Delete

* @see wpdb::tables()

[347] Fix | Delete

* @var string[]

[348] Fix | Delete

*/

[349] Fix | Delete

public $old_ms_global_tables = array( 'sitecategories' );

[350] Fix | Delete

[351] Fix | Delete

/**

[352] Fix | Delete

* WordPress Comments table.

[353] Fix | Delete

*

[354] Fix | Delete

* @since 1.5.0

[355] Fix | Delete

*

[356] Fix | Delete

* @var string

[357] Fix | Delete

*/

[358] Fix | Delete

public $comments;

[359] Fix | Delete

[360] Fix | Delete

/**

[361] Fix | Delete

* WordPress Comment Metadata table.

[362] Fix | Delete

*

[363] Fix | Delete

* @since 2.9.0

[364] Fix | Delete

*

[365] Fix | Delete

* @var string

[366] Fix | Delete

*/

[367] Fix | Delete

public $commentmeta;

[368] Fix | Delete

[369] Fix | Delete

/**

[370] Fix | Delete

* WordPress Links table.

[371] Fix | Delete

*

[372] Fix | Delete

* @since 1.5.0

[373] Fix | Delete

*

[374] Fix | Delete

* @var string

[375] Fix | Delete

*/

[376] Fix | Delete

public $links;

[377] Fix | Delete

[378] Fix | Delete

/**

[379] Fix | Delete

* WordPress Options table.

[380] Fix | Delete

*

[381] Fix | Delete

* @since 1.5.0

[382] Fix | Delete

*

[383] Fix | Delete

* @var string

[384] Fix | Delete

*/

[385] Fix | Delete

public $options;

[386] Fix | Delete

[387] Fix | Delete

/**

[388] Fix | Delete

* WordPress Post Metadata table.

[389] Fix | Delete

*

[390] Fix | Delete

* @since 1.5.0

[391] Fix | Delete

*

[392] Fix | Delete

* @var string

[393] Fix | Delete

*/

[394] Fix | Delete

public $postmeta;

[395] Fix | Delete

[396] Fix | Delete

/**

[397] Fix | Delete

* WordPress Posts table.

[398] Fix | Delete

*

[399] Fix | Delete

* @since 1.5.0

[400] Fix | Delete

*

[401] Fix | Delete

* @var string

[402] Fix | Delete

*/

[403] Fix | Delete

public $posts;

[404] Fix | Delete

[405] Fix | Delete

/**

[406] Fix | Delete

* WordPress Terms table.

[407] Fix | Delete

*

[408] Fix | Delete

* @since 2.3.0

[409] Fix | Delete

*

[410] Fix | Delete

* @var string

[411] Fix | Delete

*/

[412] Fix | Delete

public $terms;

[413] Fix | Delete

[414] Fix | Delete

/**

[415] Fix | Delete

* WordPress Term Relationships table.

[416] Fix | Delete

*

[417] Fix | Delete

* @since 2.3.0

[418] Fix | Delete

*

[419] Fix | Delete

* @var string

[420] Fix | Delete

*/

[421] Fix | Delete

public $term_relationships;

[422] Fix | Delete

[423] Fix | Delete

/**

[424] Fix | Delete

* WordPress Term Taxonomy table.

[425] Fix | Delete

*

[426] Fix | Delete

* @since 2.3.0

[427] Fix | Delete

*

[428] Fix | Delete

* @var string

[429] Fix | Delete

*/

[430] Fix | Delete

public $term_taxonomy;

[431] Fix | Delete

[432] Fix | Delete

/**

[433] Fix | Delete

* WordPress Term Meta table.

[434] Fix | Delete

*

[435] Fix | Delete

* @since 4.4.0

[436] Fix | Delete

*

[437] Fix | Delete

* @var string

[438] Fix | Delete

*/

[439] Fix | Delete

public $termmeta;

[440] Fix | Delete

[441] Fix | Delete

//

[442] Fix | Delete

// Global and Multisite tables

[443] Fix | Delete

//

[444] Fix | Delete

[445] Fix | Delete

/**

[446] Fix | Delete

* WordPress User Metadata table.

[447] Fix | Delete

*

[448] Fix | Delete

* @since 2.3.0

[449] Fix | Delete

*

[450] Fix | Delete

* @var string

[451] Fix | Delete

*/

[452] Fix | Delete

public $usermeta;

[453] Fix | Delete

[454] Fix | Delete

/**

[455] Fix | Delete

* WordPress Users table.

[456] Fix | Delete

*

[457] Fix | Delete

* @since 1.5.0

[458] Fix | Delete

*

[459] Fix | Delete

* @var string

[460] Fix | Delete

*/

[461] Fix | Delete

public $users;

[462] Fix | Delete

[463] Fix | Delete

/**

[464] Fix | Delete

* Multisite Blogs table.

[465] Fix | Delete

*

[466] Fix | Delete

* @since 3.0.0

[467] Fix | Delete

*

[468] Fix | Delete

* @var string|null

[469] Fix | Delete

*/

[470] Fix | Delete

public $blogs;

[471] Fix | Delete

[472] Fix | Delete

/**

[473] Fix | Delete

* Multisite Blog Metadata table.

[474] Fix | Delete

*

[475] Fix | Delete

* @since 5.1.0

[476] Fix | Delete

*

[477] Fix | Delete

* @var string|null

[478] Fix | Delete

*/

[479] Fix | Delete

public $blogmeta;

[480] Fix | Delete

[481] Fix | Delete

/**

[482] Fix | Delete

* Multisite Registration Log table.

[483] Fix | Delete

*

[484] Fix | Delete

* @since 3.0.0

[485] Fix | Delete

*

[486] Fix | Delete

* @var string|null

[487] Fix | Delete

*/

[488] Fix | Delete

public $registration_log;

[489] Fix | Delete

[490] Fix | Delete

/**

[491] Fix | Delete

* Multisite Signups table.

[492] Fix | Delete

*

[493] Fix | Delete

* @since 3.0.0

[494] Fix | Delete

*

[495] Fix | Delete

* @var string|null

[496] Fix | Delete

*/

[497] Fix | Delete

public $signups;

[498] Fix | Delete

[499] Fix | Delete