mysql_get_server_info

Get MySQL server info (PHP 4 >= 4.0.5, PHP 5, PECL mysql:1.0)
string mysql_get_server_info ( [resource link_identifier] )

Example 1445. mysql_get_server_info() example

copy to clipboard

<?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:

copy to clipboard

MySQL server version: 4.0.1-alpha

Related Examples ( Source code ) » mysql_get_server_info

Examples ( Source code ) » Get MySQL server information

Code Examples / Notes » mysql_get_server_info

cnooospamlmax1

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; ?>

kalle sommer nielsen

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()

Change Language

mysql_affected_rows
mysql_change_user
mysql_client_encoding
mysql_close
mysql_connect
mysql_create_db
mysql_data_seek
mysql_db_name
mysql_db_query
mysql_drop_db
mysql_errno
mysql_error
mysql_escape_string
mysql_fetch_array
mysql_fetch_assoc
mysql_fetch_field
mysql_fetch_lengths
mysql_fetch_object
mysql_fetch_row
mysql_field_flags
mysql_field_len
mysql_field_name
mysql_field_seek
mysql_field_table
mysql_field_type
mysql_free_result
mysql_get_client_info
mysql_get_host_info
mysql_get_proto_info
mysql_get_server_info
mysql_info
mysql_insert_id
mysql_list_dbs
mysql_list_fields
mysql_list_processes
mysql_list_tables
mysql_num_fields
mysql_num_rows
mysql_pconnect
mysql_ping
mysql_query
mysql_real_escape_string
mysql_result
mysql_select_db
mysql_set_charset
mysql_stat
mysql_tablename
mysql_thread_id
mysql_unbuffered_query