(PHP 5, PHP 7 < 7.4.0)
ibase_server_info — データベースサーバーについての情報を要求する
service_handleデータベースサーバーへの接続
action有効な定数
コンテクストに応じて様々な型の値を返します。
例1 ibase_service_attach() の例
<?php
// リモートの Firebird サーバーにアタッチする
if (($service = ibase_service_attach('10.1.1.254/3050', 'sysdba', 'masterkey')) != FALSE) {
// アタッチ成功
// 情報を出力
echo "Server version: " . ibase_server_info($service, IBASE_SVC_SERVER_VERSION) . "\n";
echo "Server implementation: " . ibase_server_info($service, IBASE_SVC_IMPLEMENTATION) . "\n";
echo "Server users: " . print_r(ibase_server_info($service, IBASE_SVC_GET_USERS), true) . "\n";
echo "Server directory: " . ibase_server_info($service, IBASE_SVC_GET_ENV) . "\n";
echo "Server lock path: " . ibase_server_info($service, IBASE_SVC_GET_ENV_LOCK) . "\n";
echo "Server lib path: " . ibase_server_info($service, IBASE_SVC_GET_ENV_MSG) . "\n";
echo "Path of user db: " . ibase_server_info($service, IBASE_SVC_USER_DBPATH) . "\n";
echo "Established connections: " . 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
)