wpdb::db_server_info(): string

User Contributed Notes

1. Skip to note 3 content

   Ravikumar Patel 5 years ago

   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

   You can Retrieve the MySQL server version on frontend by global declaration.

   global $wpdb;
   echo $wpdb->db_server_info();
2. Skip to note 4 content

   Liton Arefin 4 years ago

   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

   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
   }