ibase_server_info

(PHP 5, PHP 7 < 7.4.0)

ibase_server_info请求有关数据库服务器的信息

描述

ibase_server_info(资源 $service_handle, 整数 $action): 字符串

参数

service_handle

先前创建的与数据库服务器的连接。

action

有效的常量。

返回值

根据上下文返回混合类型。

示例

示例 #1 ibase_service_attach() 示例

<?php
// 连接到远程 Firebird 服务器
if (($service = ibase_service_attach('10.1.1.254/3050', 'sysdba', 'masterkey')) != FALSE) {

// 连接成功。

// 输出信息
echo "服务器版本: " . ibase_server_info($service, IBASE_SVC_SERVER_VERSION) . "\n";
echo
"服务器实现: " . ibase_server_info($service, IBASE_SVC_IMPLEMENTATION) . "\n";
echo
"服务器用户: " . print_r(ibase_server_info($service, IBASE_SVC_GET_USERS), true) . "\n";
echo
"服务器目录: " . ibase_server_info($service, IBASE_SVC_GET_ENV) . "\n";
echo
"服务器锁路径: " . ibase_server_info($service, IBASE_SVC_GET_ENV_LOCK) . "\n";
echo
"服务器 lib 路径: " . ibase_server_info($service, IBASE_SVC_GET_ENV_MSG) . "\n";
echo
"用户 db 路径: " . ibase_server_info($service, IBASE_SVC_USER_DBPATH) . "\n";
echo
"已建立的连接: " . print_r(ibase_server_info($service, IBASE_SVC_SVR_DB_INFO),true) . "\n";

// 从服务器断开连接
ibase_service_detach($service);

}
else {
// 输出错误消息
$conn_error = ibase_errmsg();
die(
$conn_error);
}
?>

上面的例子将输出

Server version: LI-V3.0.4.33054 Firebird 3.0
Server implementation: Firebird/Linux/AMD/Intel/x64
Server users: Array
(
    [0] => Array
        (
            [user_name] => SYSDBA
            [first_name] => Sql
            [middle_name] => Server
            [last_name] => Administrator
            [user_id] => 0
            [group_id] => 0
        )

)

Server directory: /etc/firebird/
Server lock path: /tmp/firebird/
Server lib path: /usr/lib64/firebird/lib/
Path of user db: /var/lib/firebird/secdb/security3.fdb
Established connections: Array
(
    [attachments] => 3
    [databases] => 2
    [0] => /srv/firebird/poss.fdb
    [1] => /srv/firebird/employees.fdb
)

添加备注

用户贡献的备注 1 则备注

1
kgbfernando
15 年前
一个小例子

<?php
// 获取服务器版本和实现字符串
if (($service = ibase_service_attach('localhost', 'sysdba', 'masterkey')) != FALSE) {
$server_info = ibase_server_info($service, IBASE_SVC_SERVER_VERSION)
.
' / '
. ibase_server_info($service, IBASE_SVC_IMPLEMENTATION);
ibase_service_detach($service);
}
else {
$ib_error = ibase_errmsg();
}
echo
$server_info;
?>
To Top