• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • mysqli::$server_info()

    (PHP 5, PHP 7)

    返回MySQL服务器的版本号

    说明

    面向对象风格
    string $mysqli->server_info;
    过程化风格
    mysqli_get_server_info(mysqli$link): string

    返回一个字符串,表述MySQLi扩展连接的MySQL服务器的版本号.

    参数

    $link

    仅以过程化样式:由mysqli_connect()或mysqli_init()返回的链接标识。

    返回值

    一个特征字符串,表述服务器的版本.

    范例

    Example #1$mysqli->server_infoexample

    面向对象风格

    <?php
    $mysqli = new mysqli("localhost", "my_user", "my_password");
    /* check connection */
    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }
    /* print server version */
    printf("Server version: %s\n", $mysqli->server_info);
    /* close connection */
    $mysqli->close();
    ?>
    

    过程化风格

    <?php
    $link = mysqli_connect("localhost", "my_user", "my_password");
    /* check connection */
    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }
    /* print server version */
    printf("Server version: %s\n", mysqli_get_server_info($link));
    /* close connection */
    mysqli_close($link);
    ?>
    

    以上例程会输出:

    Server version: 4.1.2-alpha-debug
    

    参见

    • mysqli_get_client_info() 获取 MySQL 客户端信息
    • mysqli_get_client_version()作为一个整数返回MySQL客户端的版本
    • mysqli_get_server_version() 作为一个整数返回MySQL服务器的版本
    Please note that this property returns different versionstrings for MariaDB instances on LINUX and WINDOWS environments.
    For a MariaDB instance 10.0.17:
    on LINUX, this returns strings like "10.0.17-MariaDB-log"
    on WINDOWS environments, this returns strings like "5.5.5-10.0.17-MariaDB-log"
    To avoid this extra "5.5.5" on windows environments, you could use the SQL query "select version();" rather than this property of the mysqli extension