WP_Site_Health::prepare_sql_data() │ private │ WP 5.2.0

Runs the SQL version checks.

These values are used in later tests, but the part of preparing them is more easily managed early in the class for ease of access and discovery.

Method of the class: WP_Site_Health{}

No Hooks.

Return

null. Nothing (null).

Usage

// private - for code of main (parent) class only
$result = $this->prepare_sql_data();

Notes

• Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

WP_Site_Health::prepare_sql_data() WP Site Health::prepare sql data code ^{WP 6.5.2}

private function prepare_sql_data() {
	global $wpdb;

	$mysql_server_type = $wpdb->db_server_info();

	$this->mysql_server_version = $wpdb->get_var( 'SELECT VERSION()' );

	if ( stristr( $mysql_server_type, 'mariadb' ) ) {
		$this->is_mariadb                = true;
		$this->mysql_recommended_version = $this->mariadb_recommended_version;
	}

	$this->is_acceptable_mysql_version  = version_compare( $this->mysql_required_version, $this->mysql_server_version, '<=' );
	$this->is_recommended_mysql_version = version_compare( $this->mysql_recommended_version, $this->mysql_server_version, '<=' );
}