php8.5
Home/ Manual/ mysql_xdevapi / session/ Session::listClients

Session::listClients

PHP function Edit on GitHub ✎

Get client list

Description

mysql_xdevapi\Session::listClients(): array

Get a list of client connections to the session's MySQL server.

Parameters Parameters

Return Values

An array containing the currently logged clients. The array elements are "client_id", "user", "host", and "sql_session".

Examples

mysql_xdevapi\Session::listClients() example

php
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");

$ids = $session->listClients();

var_dump($ids);
?>

The above example will output something similar to:

output
array(1) {
  [0]=>
  array(4) {
    ["client_id"]=>
    int(61)
    ["user"]=>
    string(4) "root"
    ["host"]=>
    string(9) "localhost"
    ["sql_session"]=>
    int(72)
  }
}

Source: reference/mysql_xdevapi/mysql_xdevapi/session/listclients.xml · from the official PHP manual (php/doc-en)