PHP MySQLi mysqli_get_proto_info()

mysqli_get_proto_info()

The mysqli_get_proto_info() function returns an integer representing the MySQL protocol version used for the currently active connection.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

if (mysqli_connect_errno()) {
    printf("Connection failed: %s<br>", mysqli_connect_error());
    exit();
}

// Display the protocol version
// NOTE: This function returns the version of the network protocol 
// used by PHP and MySQL for communication. In most cases, this will be the number 10.
echo mysqli_get_proto_info($connection);

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: Although this version rarely changes (most modern systems use protocol version 10), this information is important for more advanced connection diagnostics. Look at the output below:

It returns an integer.

It tells us which "language" version of the protocol the client and server are using.

It requires an active connection as a parameter.