ibase_server_info

(PHP 5, PHP 7 < 7.4.0)

ibase_server_infoSollicite des informations à propos d'un serveur de base de donnée

Description

ibase_server_info(resource $service_handle, int $action): string

Liste de paramètres

service_handle

Une connexion au serveur de base de donnée créee précédemment.

action

Une constante valide.

Valeurs de retour

Retourne des types différents en fonction du contexte.

Exemples

Exemple #1 Exemple avec ibase_service_attach()

<?php
// S'attacher au serveur Firebird distant
if (($service = ibase_service_attach('10.1.1.254/3050', 'sysdba', 'masterkey')) != FALSE) {

// Attaché avec succès.

// Afficher les informations
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";

// Se détacher du serveur (déconnexion)
ibase_service_detach($service);

}
else {
// Afficher un message en cas d'erreur
$conn_error = ibase_errmsg();
die(
$conn_error);
}
?>

L'exemple ci-dessus va afficher :

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
)

add a note add a note

User Contributed Notes 1 note

up
1
kgbfernando
15 years ago
A Little Example

<?php
   
// get server version and implementation strings
   
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