PHP Doku:: Gets the current system status - mysqli.stat.html

Verlauf / Chronik / History: (1) anzeigen

Sie sind hier:
Doku-StartseitePHP-HandbuchFunktionsreferenzDatenbankerweiterungenAnbieterspezifische DatenbankerweiterungenMySQL Improved ExtensionThe MySQLi classmysqli::stat -- mysqli_stat

Ein Service von Reinhard Neidl - Webprogrammierung.

The MySQLi class

<<mysqli::ssl_set -- mysqli_ssl_set

mysqli::stmt_init -- mysqli_stmt_init>>

mysqli::stat

mysqli_stat

(PHP 5)

mysqli::stat -- mysqli_statGets the current system status

Beschreibung

Objektorientierter Stil

string mysqli::stat ( void )

Prozeduraler Stil

string mysqli_stat ( mysqli $link )

mysqli_stat() returns a string containing information similar to that provided by the 'mysqladmin status' command. This includes uptime in seconds and the number of running threads, questions, reloads, and open tables.

Parameter-Liste

link

Nur bei prozeduralem Aufruf: Ein von mysqli_connect() oder mysqli_init() zurückgegebenes Verbindungsobjekt.

Rückgabewerte

A string describing the server status. FALSE if an error occurred.

Beispiele

Beispiel #1 mysqli::stat() example

Objektorientierter Stil

<?php
$mysqli 
= new mysqli("localhost""my_user""my_password""world");

/* check connection */
if (mysqli_connect_errno()) {
    
printf("Connect failed: %s\n"mysqli_connect_error());
    exit();
}

printf ("System status: %s\n"$mysqli->stat());

$mysqli->close();
?>

Prozeduraler Stil

<?php
$link 
mysqli_connect("localhost""my_user""my_password""world");

/* check connection */
if (mysqli_connect_errno()) {
    
printf("Connect failed: %s\n"mysqli_connect_error());
    exit();
}

printf("System status: %s\n"mysqli_stat($link));

mysqli_close($link);
?>

The above examples will output:

System status: Uptime: 272  Threads: 1  Questions: 5340  Slow queries: 0
Opens: 13  Flush tables: 1  Open tables: 0  Queries per second avg: 19.632
Memory in use: 8496K  Max memory used: 8560K

Siehe auch


Ein BenutzerBeitrag:
- Beiträge aktualisieren...
nycdiesl at gmail dot com
1.05.2009 15:10
PHP 5.2.9
A small example

<?php
$dbh
= new mysqli('host', 'user', 'password', 'database');
if (
$dbh->connect_error) {
   die(
"Connection Error ({$dbh->connect_errno}) {$dbh->connect_error}");
}

if ((
$stats = $dbh->stat()) !== FALSE) {
   echo
"Dumping output method stat() ...\n";
   echo
"$stats\n";

  
$statsArray = explode("  ", $stats);
  
print_r($stats);
}
?>

Dumping stats:
Uptime: 1095822  Threads: 5  Questions: 5326101  Slow queries: 0  Opens: 7352  Flush tables: 1  Open tables: 60  Queries per second avg: 4.860
Array
(
    [0] => Uptime: 1095822
    [1] => Threads: 5
    [2] => Questions: 5326101
    [3] => Slow queries: 0
    [4] => Opens: 7352
    [5] => Flush tables: 1
    [6] => Open tables: 60
    [7] => Queries per second avg: 4.860
)

The above code will print out a string and then attempt to create an array by exploding the string using a delimiter of two spaces (eg: "  "). This should give you an array to work with, however, I'm just beginning to use this extension, so feel free to correct any errors discovered :)



PHP Powered Diese Seite bei php.net
The PHP manual text and comments are covered by the Creative Commons Attribution 3.0 License © the PHP Documentation Group - Impressum - mail("TO:Reinhard Neidl",...)