[SOLVED] MySQL Version

[rarebit]

Without connecting to MySQL how do you find out if it's available and which version?

 

I'm seeing all of the following directives in php.ini:

mysql.allow_local_infile, mysql.allow_persistent, mysql.cache_size, mysql.connect_timeout, mysql.default_host, mysql.default_password, mysql.default_port, mysql.default_socket, mysql.default_user, mysql.max_links, mysql.max_persistent, mysql.trace_mode

 

But what is best way to check for version?

[n3ightjay]

<?php
phpinfo();
?>

[php-pendejo]

not really sure but try phpinfo();

[wildteen88]

phpinfo returns the mysql client version. Not the actual version of the MySQL server. To get the version of MySQL installed first connect to MySQL then use the mysql_get_server_info function.

[rarebit]

phpinfo returns the mysql client version. Not the actual version of the MySQL server. To get the version of MySQL installed first connect to MySQL then use the mysql_get_server_info function.

 

This does give what I want, but at the stage of use I wouldn't have any DB details.

 

This is now the best i've found, but still no version (unless I search the system myself?):

if (extension_loaded('mysql'))
{
print "MySQL available<br>";
}

[rarebit]

Ok, i'm struggling with preg_split (and PREG_SPLIT_DELIM_CAPTURE), but surely theres got to be an easier way than this?

ob_start();
$x = eval("phpinfo();");
$l = ob_get_contents();
ob_end_clean();

$chars = preg_split('/Client API version <\/td><td class="v">(*) <\/td>/', $l, -1, PREG_SPLIT_DELIM_CAPTURE);

 

Is there a way to get 'phpinfo' back as an array?

[premiso]

Doesnt look like it.

 

phpinfo

 

However you can extract certain parts, so you only pull the section you want. Might make it a little cleaner and less code to go through.

 

 

[PFMaBiSmAd]

You were already told, a few hours ago, that the php client API version has no direct relation to the mysql server version -

phpinfo returns the mysql client version. Not the actual version of the MySQL server. To get the version of MySQL installed first connect to MySQL then use the mysql_get_server_info function.

[rarebit]

So at install time, the best I can do (without a system search) is:

if (extension_loaded('mysql'))
{
   print "MySQL available<br>";
}

[Mchl]

Not really. An extension might be loaded, but server might not be available. You can't actually tell without trying to connect...