<?php

[0] Fix | Delete

[1] Fix | Delete

// phpcs:disable WPForms.Comments.PHPDocHooks.RequiredHookDocumentation, WPForms.PHP.ValidateHooks.InvalidHookName

[2] Fix | Delete

// phpcs:disable Generic.Commenting.DocComment.MissingShort

[3] Fix | Delete

/** @noinspection AutoloadingIssuesInspection */

[4] Fix | Delete

/** @noinspection PhpIllegalPsrClassPathInspection */

[5] Fix | Delete

// phpcs:disable Generic.Commenting.DocComment.MissingShort

[6] Fix | Delete

[7] Fix | Delete

use WPForms\Helpers\DB;

[8] Fix | Delete

[9] Fix | Delete

/**

[10] Fix | Delete

* DB class.

[11] Fix | Delete

*

[12] Fix | Delete

* This handy class originated from Pippin's Easy Digital Downloads.

[13] Fix | Delete

* See https://github.com/easydigitaldownloads/easy-digital-downloads/blob/master/includes/class-edd-db.php

[14] Fix | Delete

*

[15] Fix | Delete

* Subclasses should define $table_name, $version, and $primary_key in __construct() method.

[16] Fix | Delete

*

[17] Fix | Delete

* @since 1.1.6

[18] Fix | Delete

*/

[19] Fix | Delete

abstract class WPForms_DB {

[20] Fix | Delete

[21] Fix | Delete

/**

[22] Fix | Delete

* Maximum length of index key.

[23] Fix | Delete

*

[24] Fix | Delete

* Indexes have a maximum size of 767 bytes. Historically, we haven't needed to be concerned about that.

[25] Fix | Delete

* As of WP 4.2, however, WP moved to utf8mb4, which uses 4 bytes per character. This means that an index, which

[26] Fix | Delete

* used to have room for floor(767/3) = 255 characters, now only has room for floor(767/4) = 191 characters.

[27] Fix | Delete

*

[28] Fix | Delete

* @since 1.8.2

[29] Fix | Delete

*/

[30] Fix | Delete

const MAX_INDEX_LENGTH = 191;

[31] Fix | Delete

[32] Fix | Delete

/**

[33] Fix | Delete

* The dedicated cache key to store the All Keys array.

[34] Fix | Delete

*

[35] Fix | Delete

* @since 1.9.0

[36] Fix | Delete

*/

[37] Fix | Delete

const ALL_KEYS = '_all_keys';

[38] Fix | Delete

[39] Fix | Delete

/**

[40] Fix | Delete

* Database table name.

[41] Fix | Delete

*

[42] Fix | Delete

* @since 1.1.6

[43] Fix | Delete

*

[44] Fix | Delete

* @var string

[45] Fix | Delete

*/

[46] Fix | Delete

public $table_name;

[47] Fix | Delete

[48] Fix | Delete

/**

[49] Fix | Delete

* Database version.

[50] Fix | Delete

*

[51] Fix | Delete

* @since 1.1.6

[52] Fix | Delete

*

[53] Fix | Delete

* @var string

[54] Fix | Delete

*/

[55] Fix | Delete

public $version;

[56] Fix | Delete

[57] Fix | Delete

/**

[58] Fix | Delete

* Primary key (unique field) for the database table.

[59] Fix | Delete

*

[60] Fix | Delete

* @since 1.1.6

[61] Fix | Delete

*

[62] Fix | Delete

* @var string

[63] Fix | Delete

*/

[64] Fix | Delete

public $primary_key;

[65] Fix | Delete

[66] Fix | Delete

/**

[67] Fix | Delete

* Database type identifier.

[68] Fix | Delete

*

[69] Fix | Delete

* @since 1.5.1

[70] Fix | Delete

*

[71] Fix | Delete

* @var string

[72] Fix | Delete

*/

[73] Fix | Delete

public $type;

[74] Fix | Delete

[75] Fix | Delete

/**

[76] Fix | Delete

* Cache group.

[77] Fix | Delete

*

[78] Fix | Delete

* @since 1.9.0

[79] Fix | Delete

*

[80] Fix | Delete

* @var string

[81] Fix | Delete

*/

[82] Fix | Delete

private $cache_group;

[83] Fix | Delete

[84] Fix | Delete

/**

[85] Fix | Delete

* Cache disabled.

[86] Fix | Delete

*

[87] Fix | Delete

* @since 1.9.0

[88] Fix | Delete

*

[89] Fix | Delete

* @var bool

[90] Fix | Delete

*/

[91] Fix | Delete

private $cache_disabled;

[92] Fix | Delete

[93] Fix | Delete

/**

[94] Fix | Delete

* WPForms_DB constructor.

[95] Fix | Delete

*

[96] Fix | Delete

* @since 1.9.0

[97] Fix | Delete

*/

[98] Fix | Delete

public function __construct() {

[99] Fix | Delete

[100] Fix | Delete

$this->cache_group = static::class . '_cache';

[101] Fix | Delete

$this->cache_disabled = defined( 'WPFORMS_DISABLE_DB_CACHE' ) && WPFORMS_DISABLE_DB_CACHE;

[102] Fix | Delete

[103] Fix | Delete

$this->hooks();

[104] Fix | Delete

}

[105] Fix | Delete

[106] Fix | Delete

/**

[107] Fix | Delete

* Query filter.

[108] Fix | Delete

*

[109] Fix | Delete

* @since 1.9.0

[110] Fix | Delete

*

[111] Fix | Delete

* @return void

[112] Fix | Delete

*/

[113] Fix | Delete

private function hooks() {

[114] Fix | Delete

[115] Fix | Delete

add_filter( 'query', [ $this, 'query_filter' ] );

[116] Fix | Delete

}

[117] Fix | Delete

[118] Fix | Delete

/**

[119] Fix | Delete

* Retrieve the list of columns for the database table.

[120] Fix | Delete

* Subclasses should define an array of columns here.

[121] Fix | Delete

*

[122] Fix | Delete

* @since 1.1.6

[123] Fix | Delete

*

[124] Fix | Delete

* @return array List of columns.

[125] Fix | Delete

*/

[126] Fix | Delete

public function get_columns() {

[127] Fix | Delete

[128] Fix | Delete

return [];

[129] Fix | Delete

}

[130] Fix | Delete

[131] Fix | Delete

/**

[132] Fix | Delete

* Retrieve column defaults.

[133] Fix | Delete

* Subclasses can define default for any/all columns defined in the get_columns() method.

[134] Fix | Delete

*

[135] Fix | Delete

* @since 1.1.6

[136] Fix | Delete

*

[137] Fix | Delete

* @return array All defined column defaults.

[138] Fix | Delete

*/

[139] Fix | Delete

public function get_column_defaults() {

[140] Fix | Delete

[141] Fix | Delete

return [];

[142] Fix | Delete

}

[143] Fix | Delete

[144] Fix | Delete

/**

[145] Fix | Delete

* Filter the query.

[146] Fix | Delete

*

[147] Fix | Delete

* @since 1.9.0

[148] Fix | Delete

*

[149] Fix | Delete

* @param string|mixed $query Query.

[150] Fix | Delete

*

[151] Fix | Delete

* @return string

[152] Fix | Delete

*/

[153] Fix | Delete

public function query_filter( $query ): string {

[154] Fix | Delete

[155] Fix | Delete

$query = (string) $query;

[156] Fix | Delete

[157] Fix | Delete

if ( strpos( $query, $this->table_name ) === false ) {

[158] Fix | Delete

// Not a query for our table, bail out.

[159] Fix | Delete

return $query;

[160] Fix | Delete

}

[161] Fix | Delete

[162] Fix | Delete

if ( ! $this->is_select( $query ) ) {

[163] Fix | Delete

// Flush cache on non-SELECT queries.

[164] Fix | Delete

$this->cache_flush_group();

[165] Fix | Delete

}

[166] Fix | Delete

[167] Fix | Delete

return $query;

[168] Fix | Delete

}

[169] Fix | Delete

[170] Fix | Delete

/**

[171] Fix | Delete

* Retrieve a row from the database based on a given row ID.

[172] Fix | Delete

*

[173] Fix | Delete

* @since 1.1.6

[174] Fix | Delete

*

[175] Fix | Delete

* @param int $row_id Row ID.

[176] Fix | Delete

*

[177] Fix | Delete

* @return null|object

[178] Fix | Delete

*/

[179] Fix | Delete

public function get( $row_id ) {

[180] Fix | Delete

[181] Fix | Delete

global $wpdb;

[182] Fix | Delete

[183] Fix | Delete

$key = md5( __METHOD__ . $row_id );

[184] Fix | Delete

$row = $this->cache_get( $key, $found );

[185] Fix | Delete

[186] Fix | Delete

if ( $found ) {

[187] Fix | Delete

return $row;

[188] Fix | Delete

}

[189] Fix | Delete

[190] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching

[191] Fix | Delete

$row = $wpdb->get_row(

[192] Fix | Delete

$wpdb->prepare(

[193] Fix | Delete

"SELECT * FROM $this->table_name WHERE $this->primary_key = %d LIMIT 1;", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[194] Fix | Delete

(int) $row_id

[195] Fix | Delete

)

[196] Fix | Delete

);

[197] Fix | Delete

[198] Fix | Delete

$this->cache_set( $key, $row );

[199] Fix | Delete

[200] Fix | Delete

return $row;

[201] Fix | Delete

}

[202] Fix | Delete

[203] Fix | Delete

/**

[204] Fix | Delete

* Retrieve a row based on column and row ID.

[205] Fix | Delete

*

[206] Fix | Delete

* @since 1.1.6

[207] Fix | Delete

*

[208] Fix | Delete

* @param string $column Column name.

[209] Fix | Delete

* @param int|string $value Column value.

[210] Fix | Delete

*

[211] Fix | Delete

* @return object|null Database query result, object or null on failure.

[212] Fix | Delete

*/

[213] Fix | Delete

public function get_by( $column, $value ) {

[214] Fix | Delete

[215] Fix | Delete

global $wpdb;

[216] Fix | Delete

[217] Fix | Delete

if (

[218] Fix | Delete

empty( $value ) ||

[219] Fix | Delete

! array_key_exists( $column, $this->get_columns() )

[220] Fix | Delete

) {

[221] Fix | Delete

return null;

[222] Fix | Delete

}

[223] Fix | Delete

[224] Fix | Delete

$key = md5( __METHOD__ . $column . $value );

[225] Fix | Delete

$row = $this->cache_get( $key, $found );

[226] Fix | Delete

[227] Fix | Delete

if ( $found ) {

[228] Fix | Delete

return $row;

[229] Fix | Delete

}

[230] Fix | Delete

[231] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching

[232] Fix | Delete

$row = $wpdb->get_row(

[233] Fix | Delete

$wpdb->prepare(

[234] Fix | Delete

"SELECT * FROM $this->table_name WHERE $column = %s LIMIT 1;", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[235] Fix | Delete

$value

[236] Fix | Delete

)

[237] Fix | Delete

);

[238] Fix | Delete

[239] Fix | Delete

$this->cache_set( $key, $row );

[240] Fix | Delete

[241] Fix | Delete

return $row;

[242] Fix | Delete

}

[243] Fix | Delete

[244] Fix | Delete

/**

[245] Fix | Delete

* Retrieve a value based on column name and row ID.

[246] Fix | Delete

*

[247] Fix | Delete

* @since 1.1.6

[248] Fix | Delete

*

[249] Fix | Delete

* @param string $column Column name.

[250] Fix | Delete

* @param int|string $row_id Row ID.

[251] Fix | Delete

*

[252] Fix | Delete

* @return string|null Database query result (as string), or null on failure.

[253] Fix | Delete

* @noinspection PhpUnused

[254] Fix | Delete

*/

[255] Fix | Delete

public function get_column( $column, $row_id ) {

[256] Fix | Delete

[257] Fix | Delete

global $wpdb;

[258] Fix | Delete

[259] Fix | Delete

if ( empty( $row_id ) || ! array_key_exists( $column, $this->get_columns() ) ) {

[260] Fix | Delete

return null;

[261] Fix | Delete

}

[262] Fix | Delete

[263] Fix | Delete

$key = md5( __METHOD__ . $column . $row_id );

[264] Fix | Delete

$var = $this->cache_get( $key, $found );

[265] Fix | Delete

[266] Fix | Delete

if ( $found ) {

[267] Fix | Delete

return $var;

[268] Fix | Delete

}

[269] Fix | Delete

[270] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching

[271] Fix | Delete

$var = $wpdb->get_var(

[272] Fix | Delete

$wpdb->prepare(

[273] Fix | Delete

"SELECT $column FROM $this->table_name WHERE $this->primary_key = %d LIMIT 1;", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[274] Fix | Delete

(int) $row_id

[275] Fix | Delete

)

[276] Fix | Delete

);

[277] Fix | Delete

[278] Fix | Delete

$this->cache_set( $key, $var );

[279] Fix | Delete

[280] Fix | Delete

return $var;

[281] Fix | Delete

}

[282] Fix | Delete

[283] Fix | Delete

/**

[284] Fix | Delete

* Retrieve one column value based on another given column and matching value.

[285] Fix | Delete

*

[286] Fix | Delete

* @since 1.1.6

[287] Fix | Delete

*

[288] Fix | Delete

* @param string $column Column name.

[289] Fix | Delete

* @param string $column_where Column to match against in the WHERE clause.

[290] Fix | Delete

* @param string $column_value Value to match to the column in the WHERE clause.

[291] Fix | Delete

*

[292] Fix | Delete

* @return string|null Database query result (as string), or null on failure.

[293] Fix | Delete

* @noinspection PhpUnused

[294] Fix | Delete

*/

[295] Fix | Delete

public function get_column_by( $column, $column_where, $column_value ) {

[296] Fix | Delete

[297] Fix | Delete

global $wpdb;

[298] Fix | Delete

[299] Fix | Delete

if (

[300] Fix | Delete

empty( $column ) ||

[301] Fix | Delete

empty( $column_where ) ||

[302] Fix | Delete

empty( $column_value ) ||

[303] Fix | Delete

! array_key_exists( $column_where, $this->get_columns() ) ||

[304] Fix | Delete

! array_key_exists( $column, $this->get_columns() )

[305] Fix | Delete

) {

[306] Fix | Delete

return null;

[307] Fix | Delete

}

[308] Fix | Delete

[309] Fix | Delete

$key = md5( __METHOD__ . $column . $column_where . $column_value );

[310] Fix | Delete

$var = $this->cache_get( $key, $found );

[311] Fix | Delete

[312] Fix | Delete

if ( $found ) {

[313] Fix | Delete

return $var;

[314] Fix | Delete

}

[315] Fix | Delete

[316] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching

[317] Fix | Delete

$var = $wpdb->get_var(

[318] Fix | Delete

$wpdb->prepare(

[319] Fix | Delete

"SELECT $column FROM $this->table_name WHERE $column_where = %s LIMIT 1;", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[320] Fix | Delete

$column_value

[321] Fix | Delete

)

[322] Fix | Delete

);

[323] Fix | Delete

[324] Fix | Delete

$this->cache_set( $key, $var );

[325] Fix | Delete

[326] Fix | Delete

return $var;

[327] Fix | Delete

}

[328] Fix | Delete

[329] Fix | Delete

/**

[330] Fix | Delete

* Clone of $wpdb->query() with caching.

[331] Fix | Delete

*

[332] Fix | Delete

* @since 1.9.0

[333] Fix | Delete

*

[334] Fix | Delete

* @param string $query Database query.

[335] Fix | Delete

*

[336] Fix | Delete

* @return int|bool Boolean true for CREATE, ALTER, TRUNCATE and DROP queries. Number of rows

[337] Fix | Delete

* affected/selected for all other queries. Boolean false on error.

[338] Fix | Delete

*

[339] Fix | Delete

* @noinspection PhpMissingParamTypeInspection

[340] Fix | Delete

*/

[341] Fix | Delete

public function query( $query ) {

[342] Fix | Delete

[343] Fix | Delete

global $wpdb;

[344] Fix | Delete

[345] Fix | Delete

if ( ! $this->is_select( $query ) ) {

[346] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[347] Fix | Delete

return $wpdb->query( $query );

[348] Fix | Delete

}

[349] Fix | Delete

[350] Fix | Delete

$key = md5( __METHOD__ . $query );

[351] Fix | Delete

$results = $this->cache_get( $key, $found );

[352] Fix | Delete

[353] Fix | Delete

if ( $found ) {

[354] Fix | Delete

return $results;

[355] Fix | Delete

}

[356] Fix | Delete

[357] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[358] Fix | Delete

$results = $wpdb->query( $query );

[359] Fix | Delete

[360] Fix | Delete

$this->cache_set( $key, $results );

[361] Fix | Delete

[362] Fix | Delete

return $results;

[363] Fix | Delete

}

[364] Fix | Delete

[365] Fix | Delete

/**

[366] Fix | Delete

* Clone of $wpdb->get_results() with caching.

[367] Fix | Delete

*

[368] Fix | Delete

* @since 1.9.0

[369] Fix | Delete

*

[370] Fix | Delete

* @param string|null $query SQL query.

[371] Fix | Delete

* @param string $output Any of ARRAY_A | ARRAY_N | OBJECT | OBJECT_K constants.

[372] Fix | Delete

*

[373] Fix | Delete

* @return array|object|null Database query results.

[374] Fix | Delete

* @noinspection PhpMissingParamTypeInspection

[375] Fix | Delete

*/

[376] Fix | Delete

public function get_results( $query = null, $output = OBJECT ) {

[377] Fix | Delete

[378] Fix | Delete

global $wpdb;

[379] Fix | Delete

[380] Fix | Delete

if ( ! $this->is_select( $query ) ) {

[381] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[382] Fix | Delete

return $wpdb->get_results( $query, $output );

[383] Fix | Delete

}

[384] Fix | Delete

[385] Fix | Delete

$key = md5( __METHOD__ . $query . $output );

[386] Fix | Delete

$results = $this->cache_get( $key, $found );

[387] Fix | Delete

[388] Fix | Delete

if ( $found ) {

[389] Fix | Delete

return $results;

[390] Fix | Delete

}

[391] Fix | Delete

[392] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[393] Fix | Delete

$results = $wpdb->get_results( $query, $output );

[394] Fix | Delete

[395] Fix | Delete

$this->cache_set( $key, $results );

[396] Fix | Delete

[397] Fix | Delete

return $results;

[398] Fix | Delete

}

[399] Fix | Delete

[400] Fix | Delete

/**

[401] Fix | Delete

* Clone of $wpdb->get_col() with caching.

[402] Fix | Delete

*

[403] Fix | Delete

* @since 1.9.4

[404] Fix | Delete

*

[405] Fix | Delete

* @param string|null $query SQL query.

[406] Fix | Delete

* @param int $x Column to return. Indexed from 0.

[407] Fix | Delete

*

[408] Fix | Delete

* @return array Database query results.

[409] Fix | Delete

* @noinspection PhpMissingParamTypeInspection

[410] Fix | Delete

*/

[411] Fix | Delete

public function get_col( $query = null, $x = 0 ) {

[412] Fix | Delete

[413] Fix | Delete

global $wpdb;

[414] Fix | Delete

[415] Fix | Delete

if ( ! $this->is_select( $query ) ) {

[416] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[417] Fix | Delete

return $wpdb->get_col( $query );

[418] Fix | Delete

}

[419] Fix | Delete

[420] Fix | Delete

$key = md5( __METHOD__ . $query . $x );

[421] Fix | Delete

$col = $this->cache_get( $key, $found );

[422] Fix | Delete

[423] Fix | Delete

if ( $found ) {

[424] Fix | Delete

return $col;

[425] Fix | Delete

}

[426] Fix | Delete

[427] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[428] Fix | Delete

$col = $wpdb->get_col( $query, $x );

[429] Fix | Delete

[430] Fix | Delete

$this->cache_set( $key, $col );

[431] Fix | Delete

[432] Fix | Delete

return $col;

[433] Fix | Delete

}

[434] Fix | Delete

[435] Fix | Delete

/**

[436] Fix | Delete

* Clone of $wpdb->get_row() with caching.

[437] Fix | Delete

*

[438] Fix | Delete

* @since 1.9.0

[439] Fix | Delete

*

[440] Fix | Delete

* @param string|null $query SQL query.

[441] Fix | Delete

* @param string $output Optional. The required return type. One of OBJECT, ARRAY_A, or ARRAY_N, which

[442] Fix | Delete

* correspond to an stdClass object, an associative array, or a numeric array,

[443] Fix | Delete

* respectively. Default OBJECT.

[444] Fix | Delete

* @param int $y Optional. Row to return. Indexed from 0. Default 0.

[445] Fix | Delete

*

[446] Fix | Delete

* @return array|int|object|stdClass|null Database query result in format specified by $output or null on failure.

[447] Fix | Delete

* @noinspection PhpMissingParamTypeInspection

[448] Fix | Delete

*/

[449] Fix | Delete

public function get_row( $query = null, $output = OBJECT, $y = 0 ) {

[450] Fix | Delete

[451] Fix | Delete

global $wpdb;

[452] Fix | Delete

[453] Fix | Delete

if ( ! $query ) {

[454] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[455] Fix | Delete

return $wpdb->get_row( $query, $output, $y );

[456] Fix | Delete

}

[457] Fix | Delete

[458] Fix | Delete

$key = md5( __METHOD__ . $query . $output . $y );

[459] Fix | Delete

$row = $this->cache_get( $key, $found );

[460] Fix | Delete

[461] Fix | Delete

if ( $found ) {

[462] Fix | Delete

return $row;

[463] Fix | Delete

}

[464] Fix | Delete

[465] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[466] Fix | Delete

$row = $wpdb->get_row( $query, $output, $y );

[467] Fix | Delete

[468] Fix | Delete

$this->cache_set( $key, $row );

[469] Fix | Delete

[470] Fix | Delete

return $row;

[471] Fix | Delete

}

[472] Fix | Delete

[473] Fix | Delete

/**

[474] Fix | Delete

* Clone of $wpdb->get_var() with caching.

[475] Fix | Delete

*

[476] Fix | Delete

* @since 1.9.0

[477] Fix | Delete

*

[478] Fix | Delete

* @param string|null $query Optional. SQL query. Defaults to null, use the result from the previous query.

[479] Fix | Delete

* @param int $x Optional. Column of value to return. Indexed from 0. Default 0.

[480] Fix | Delete

* @param int $y Optional. Row of value to return. Indexed from 0. Default 0.

[481] Fix | Delete

*

[482] Fix | Delete

* @return string|null Database query result (as string), or null on failure.

[483] Fix | Delete

*

[484] Fix | Delete

* @noinspection PhpMissingParamTypeInspection

[485] Fix | Delete

*/

[486] Fix | Delete

public function get_var( $query = null, $x = 0, $y = 0 ) {

[487] Fix | Delete

[488] Fix | Delete

global $wpdb;

[489] Fix | Delete

[490] Fix | Delete

if ( ! $query ) {

[491] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

[492] Fix | Delete

return $wpdb->get_var( $query, $x, $y );

[493] Fix | Delete

}

[494] Fix | Delete

[495] Fix | Delete

$key = md5( __METHOD__ . $query . $x . $y );

[496] Fix | Delete

$var = $this->cache_get( $key, $found );

[497] Fix | Delete

[498] Fix | Delete

if ( $found ) {

[499] Fix | Delete