[RESOLVED] php5 - mysqli_get_server_version not work ?

[phpsj06]

Hello everyone:

I am trying to use mysqli_get_server_version() function to display the server version .

I got an error says, Fatal error: Call to undefined function mysqli_get_server_version()

my code are as follows

<?php

  $db_connection = mysql_connect("localhost", "root", "password")
     or
   die("Could not connect: " . mysql_error());

  if ($db_connection)
  {
   echo "you connect to the local host. <br />";
  }

  $client_infor = mysql_get_client_info();
  echo "mysql client version is: " .$client_infor . "<br />";


  $host_infor = mysql_get_host_info( $db_connection);
  echo "mysql db server information is: " .$host_infor . "<br />";

  $host_infor = mysql_get_server_info($db_connection);
  echo "mysql db server version is: " .$host_infor . "<br />";


 // ?? does not work
 $host_infor = mysqli_get_server_version($db_connection);
 echo "mysql db server version is: " .$host_infor . "<br />";

?>

Please give me some suggestion on what I am doing wrong here, how can I fix it? Thanks!

Jeff
11-26-06

[rincewind456]

And the reason it does not work is that you haven't opened a link with [man]mysqli_connect/man, your connection is done with [man]mysql_connect/man

[Installer]

If that was the only poblem the error message wouldn't be for an undefined function, but for an invalid resource instead. If the server is Windows, try putting "extension=php_mysqli.dll" in php.ini. Otherwise see the manual for installation instructions. And, as rincewind456 suggests, use one interface or the other consistently.

[phpsj06]

Hello rincewind456 and installer:

Thanks for replying my post, I add extension = php_mysqli.dll lin to my php.ini file and the code worked. 🙂

Jeff
11-27-06

[rincewind456]

If you have the mysqli extension working then you would want to only use it, or the mysql extension not both together.

You can shorten your script to this

<?php
$mysqli = new mysqli("localhost", "root", "rincewind");

/* check connection */
if (!mysqli_connect_errno()) {
	echo "you've connected to the local host. <br />";
}

printf("Client library version: %s\n<br />", mysqli_get_client_info());

printf("Host info: %s\n<br />", $mysqli->host_info);

printf("Server version: %s\n<br />", $mysqli->server_info);

printf("Server version: %d", $mysqli->server_version);

$mysqli->close();
?>

Don't forget to mark the thread as resolved.