9951 explained code solutions for 126 technologies


php-mysqlHow to get the version of MySQL using PHP?


You can get the version of MySQL using PHP by using the mysqli_get_server_info() function. This function returns a string containing the version of the MySQL server.

Example code

<?php
$conn = mysqli_connect("localhost", "username", "password", "database");
echo mysqli_get_server_info($conn);
?>

Output example

5.7.25

Code explanation

  • mysqli_get_server_info(): This is the function used to get the version of MySQL.
  • $conn: This is the connection variable used to connect to the MySQL server.
  • mysqli_connect(): This is the function used to connect to the MySQL server.

Helpful links

Edit this code on GitHub