Getting MYSQL Version using PHP PDO

If you are using PhpMyAdmin then go to the home page and at the top you will get the version of PhpMyAdmin along with MySQL version number.

We can easily get the version of MySQL running by using php code. This script assumes that you already established MySQL connection and it is working fine.

We will use one select query command to get the data from running mysql database. Here is the code.

<?Php
////////////////
require "config.php"; // Database Connection
////////////////
include "menu.php";
$result = $dbo->query("SHOW VARIABLES LIKE '%version%'");
$i=1;
echo "<table class='t1'><tr>";
while ($row = $result->fetch(PDO::FETCH_NUM)) {
$m=$i%2;
echo "<tr class='r$m'><td>$row[0]</td><td>$row[1]</td></tr>";
$i=$i+1;
}
echo "</table>";
?>

This script is used in our MySQL admin script.

How to get PHP Version ?

PHP MySQL functions mysql_fetch_length() : Length of Data MySQL Error

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

tommi	16-03-2009
thanks, it works...

Displaying MySQL Version running

Subhendu Mohapatra