wpdb::db_server_info(): string

Returns the version of the MySQL server.

Contents

Return
Source
Related
- Used By
Changelog
User Contributed Notes

Return

string Server version as a string.

Source

File: wp-includes/class-wpdb.php. View all references

public function db_server_info() {
	return mysqli_get_server_info( $this->dbh );
}

View on Trac View on GitHub

Used By

Used By
Used By	Description
WP_Site_Health::prepare_sql_data() wp-admin/includes/class-wp-site-health.php	Runs the SQL version checks.
dbDelta() wp-admin/includes/upgrade.php	Modifies the database based on specified SQL statements.
wp_version_check() wp-includes/update.php	Checks WordPress version against the newest version.
wpdb::has_cap() wp-includes/class-wpdb.php	Determines whether the database or WPDB supports a particular feature.
wpdb::db_version() wp-includes/class-wpdb.php	Retrieves the database server version.

Changelog

Changelog
Version	Description
5.5.0	Introduced.

User Contributed Notes

Skip to note 1 content

You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note

Contributed by Ravikumar Patel — 3 years ago
You can Retrieve the MySQL server version on frontend by global declaration.
```
global $wpdb;
echo $wpdb->db_server_info();
```
Log in to add feedback
Skip to note 2 content

You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note

Contributed by Liton Arefin — 2 years ago
Another way to Retrieve MySQL Server version by using $wpdb:
```
global $wpdb;
$db_version_dump = $wpdb->get_var( 'SELECT VERSION() AS version from DUAL' );
if ( preg_match( '/\d+(?:\.\d+)+/', $db_version_dump, $matches ) ) {
    echo $matches[0]; //returning the first match of Database Version
}
```
Log in to add feedback

You must log in before being able to contribute a note or feedback.