ibase_server_info

(PHP 5, PHP 7 < 7.4.0)

ibase_server_infoRequest information about a database server

Description

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

Parameters

service_handle

A previously created connection to the database server.

action

A valid constant.

Return Values

Returns mixed types depending on context.

Examples

Example #1 ibase_service_attach() example

<?php
    
// Attach to the remote Firebird server
    
if (($service ibase_service_attach('10.1.1.254/3050''sysdba''masterkey')) != FALSE) {

        
// Successfully attached.

        // Output the info
        
echo "Server version: " ibase_server_info($serviceIBASE_SVC_SERVER_VERSION) . "\n";
        echo 
"Server implementation: " ibase_server_info($serviceIBASE_SVC_IMPLEMENTATION) . "\n";
        echo 
"Server users: " print_r(ibase_server_info($serviceIBASE_SVC_GET_USERS), true) . "\n";
        echo 
"Server directory: " ibase_server_info($serviceIBASE_SVC_GET_ENV) . "\n";
        echo 
"Server lock path: " ibase_server_info($serviceIBASE_SVC_GET_ENV_LOCK) . "\n";
        echo 
"Server lib path: " ibase_server_info($serviceIBASE_SVC_GET_ENV_MSG) . "\n";
        echo 
"Path of user db: " ibase_server_info($serviceIBASE_SVC_USER_DBPATH) . "\n";
        echo 
"Established connections: " print_r(ibase_server_info($serviceIBASE_SVC_SVR_DB_INFO),true) . "\n";

        
// Detach from server (disconnect)
        
ibase_service_detach($service);

    }
    else {
        
// Output message on error
        
$conn_error ibase_errmsg();
        die(
$conn_error);
    }
?>

The above example will output:

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
)

Here you can write a comment


Please enter at least 10 characters.
Loading... Please wait.
* Pflichtangabe
There are no comments available yet.

PHP cURL Tutorial: Using cURL to Make HTTP Requests

cURL is a powerful PHP extension that allows you to communicate with different servers using various protocols, including HTTP, HTTPS, FTP, and more. ...

TheMax

Autor : TheMax
Category: PHP-Tutorials

Midjourney Tutorial - Instructions for beginners

There is an informative video about Midjourney, the tool for creating digital images using artificial intelligence, entitled "Midjourney tutorial in German - instructions for beginners" ...

Mike94

Autor : Mike94
Category: KI Tutorials

Basics of views in MySQL

Views in a MySQL database offer the option of creating a virtual table based on the result of an SQL query. This virtual table can be queried like a normal table without changing the underlying data. ...

admin

Autor : admin
Category: mySQL-Tutorials

Publish a tutorial

Share your knowledge with other developers worldwide

Share your knowledge with other developers worldwide

You are a professional in your field and want to share your knowledge, then sign up now and share it with our PHP community

learn more

Publish a tutorial