File Manager / wp-content Search Upload New Item Settings File "db5.php" Full path: /home1/epichome/public_html/wp-content/db5.php File size: 60.67 B (60.67 KB bytes) MIME-type: text/x-php Charset: utf-8 Download Open Edit Advanced Editor Back
/home/pharmacy/public_html/wp-content/plugins/wp-mail-smtp/src/Helpers/DB.php
<?php

namespace WPMailSMTP\Helpers;

/**
 * Class for Database functionality.
 *
 * @since 3.6.0
 */
class DB {

	/**
	 * The function is used to check if the given index exists in the given table.
	 *
	 * @since 3.6.0
	 *
	 * @param string $table The table name.
	 * @param string $index The index name.
	 *
	 * @return bool If index exists then return true else returns false.
	 */
	public static function index_exists( $table, $index ) {

		global $wpdb;

		$query = $wpdb->prepare(
			'SELECT COUNT(1) IndexIsThere
				FROM INFORMATION_SCHEMA.STATISTICS
				WHERE table_schema = DATABASE()
				AND table_name = %s
				AND index_name = %s',
			$table,
			$index
		);

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
		$result = $wpdb->get_var( $query );

		return $result === '1';
	}
}