<?php // connect and table inc connect to mysql and create tables require_once 'connect.inc'; if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) { printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket); } $before = mysqli_get_connection_stats($link); if (!is_array($before) || empty($before)) { printf("[002] Expecting non-empty array, got %s.\n", gettype($before)); var_dump($before); } mysqli_close($link); if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) { printf("[003] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket); } $after = mysqli_get_connection_stats($link); if ($before !== $after) { printf("[004] Statistics differ!"); var_dump($before); var_dump($after); } foreach ($after as $k => $v) { if ($v != 0) { printf("[004] Field %s should not have any other value but 0, got %s.\n", $k, $v); } } mysqli_close($link); print "done!";
if (!is_array($info = $link->get_connection_stats()) || empty($info)) { printf("[006] Expecting array/any_non_empty, got %s/%s\n", gettype($info), $info); } foreach ($info as $k => &$v) { if (strpos($k, "mem_") === 0) { $v = 0; } } if ($info !== $info2) { printf("[007] The hashes should be identical except of the memory related fields\n"); var_dump($info); var_dump($info2); } mysqli_close($link); $test_table_name = 'test_mysqli_get_connection_stats_table_1'; require "table.inc"; if (!is_array($info = mysqli_get_connection_stats($link)) || empty($info)) { printf("[008] Expecting array/any_non_empty, got %s/%s\n", gettype($info), $info); } if (!is_array($info2 = mysqli_get_client_stats()) || empty($info2)) { printf("[009] Expecting array/any_non_empty, got %s/%s\n", gettype($info2), $info2); } // assuming the test is run in a plain-vanilla CLI environment if ($info === $info2) { printf("[010] The hashes should not be identical\n"); var_dump($info); var_dump($info2); } print "done!"; $test_table_name = 'test_mysqli_get_connection_stats_table_1'; require_once "clean_table.inc";
public function ConnnectionStat() { $this->stat = mysqli_get_connection_stats($GLOBALS['connection']); }