<?php

[0] Fix | Delete

[1] Fix | Delete

namespace Yoast\WP\SEO\Helpers;

[2] Fix | Delete

[3] Fix | Delete

use wpdb;

[4] Fix | Delete

[5] Fix | Delete

/**

[6] Fix | Delete

* A helper object for the wpdb.

[7] Fix | Delete

*/

[8] Fix | Delete

class Wpdb_Helper {

[9] Fix | Delete

[10] Fix | Delete

/**

[11] Fix | Delete

* The WordPress database instance.

[12] Fix | Delete

*

[13] Fix | Delete

* @var wpdb

[14] Fix | Delete

*/

[15] Fix | Delete

private $wpdb;

[16] Fix | Delete

[17] Fix | Delete

/**

[18] Fix | Delete

* Constructs a Wpdb_Helper instance.

[19] Fix | Delete

*

[20] Fix | Delete

* @param wpdb $wpdb The WordPress database instance.

[21] Fix | Delete

*/

[22] Fix | Delete

public function __construct( wpdb $wpdb ) {

[23] Fix | Delete

$this->wpdb = $wpdb;

[24] Fix | Delete

}

[25] Fix | Delete

[26] Fix | Delete

/**

[27] Fix | Delete

* Check if table exists.

[28] Fix | Delete

*

[29] Fix | Delete

* @param string $table The table to be checked.

[30] Fix | Delete

*

[31] Fix | Delete

* @return bool Whether the table exists.

[32] Fix | Delete

*/

[33] Fix | Delete

public function table_exists( $table ) {

[34] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Reason: There is no unescaped user input.

[35] Fix | Delete

$table_exists = $this->wpdb->get_var( "SHOW TABLES LIKE '{$table}'" );

[36] Fix | Delete

if ( \is_wp_error( $table_exists ) || \is_null( $table_exists ) ) {

[37] Fix | Delete

return false;

[38] Fix | Delete

}

[39] Fix | Delete

[40] Fix | Delete

return true;

[41] Fix | Delete

}

[42] Fix | Delete

}

[43] Fix | Delete

[44] Fix | Delete