mysql_get_proto_info
An alternative to mysql_get_client_info() is to use the VERSION() function in MySQL language like:
<?php
$query = mysql_query("SELECT VERSION() as mysql_version");
?>
The output is the same as mysql_get_client_info()
mysql_get_server_info
(PHP 4 >= 4.0.5, PHP 5, PECL mysql:1.0)
mysql_get_server_info — Get MySQL server info
Description
string mysql_get_server_info
([ resource $link_identifier
] )
Retrieves the MySQL server version.
Parameters
- link_identifier
-
The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() was called with no arguments. If by chance no connection is found or established, an E_WARNING level error is generated.
Return Values
Returns the MySQL server version on success, or FALSE on failure.
Examples
Example #1 mysql_get_server_info() example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL server version: %s\n", mysql_get_server_info());
?>
The above example will output something similar to:
MySQL server version: 4.0.1-alpha
add a note
User Contributed Notesmysql_get_server_info
Kalle Sommer Nielsen
29-May-2007 04:54
29-May-2007 04:54
cNOooSPAMlmax1 at o2 dot pl
08-Jul-2006 04:27
08-Jul-2006 04:27
That's better:
<?php
mysql_connect('localhost', 'user', 'password') or
die('Could not connect: ' . mysql_error());
$a = mysql_get_server_info();
$b = substr($a, 0, strpos($a, "-"));
echo $b;
?>