public function getAttribute($attribute, &$source = null, $func = 'PDO::getAttribute', &$last_error = null)
{
if ($source == null) {
$source =& $this->driver_options;
}
switch ($attribute) {
case EhrlichAndreas_Pdo_Abstract::ATTR_AUTOCOMMIT:
$result = mysqli_query($this->link, 'SELECT @@AUTOCOMMIT', MYSQLI_USE_RESULT);
if (!$result) {
$this->set_driver_error(null, EhrlichAndreas_Pdo_Abstract::ERRMODE_EXCEPTION, $func);
}
$row = mysqli_fetch_row($result);
mysqli_free_result($result);
return intval($row[0]);
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_CLIENT_VERSION:
return mysqli_get_client_info();
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_CONNECTION_STATUS:
return mysqli_get_host_info($this->link);
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_SERVER_INFO:
return mysqli_stat($this->link);
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_SERVER_VERSION:
return mysqli_get_server_info($this->link);
break;
default:
return parent::getAttribute($attribute, $source, $func, $last_error);
break;
}
}
public function returnData()
{
$status = explode(' ', mysqli_stat($this->mysqlHandler));
foreach ($status as $k => $v) {
$v = explode(':', $v, 2);
$status[$k] = (double) $v[1];
}
return array('mysql_slow_query' => $status[3], 'mysql_query_avg' => $status[7]);
}
function get_mysql_stats()
{
$stats = mysqli_stat($this->db_login->conn_id);
$mySQLstats = array();
foreach (explode(" ", $stats) as $k) {
$ret = explode(': ', $k);
$mySQLstats[$ret[0]] = $ret[1];
}
return $mySQLstats;
}
/**
* Show general table stats
*
* @access public
*/
public function index()
{
// -------------------------------------
// Get basic info
// -------------------------------------
$CI =& get_instance();
//$CI->load->database();
$connection = $CI->db->conn_id;
$raw_stats = explode(' ', mysqli_stat($connection));
$data = array();
$data['stats'] = array();
foreach ($raw_stats as $stat) {
$break = explode(':', $stat);
$data['stats'][trim($break[0])] = trim($break[1]);
}
// -------------------------------------
// Get Processes
// -------------------------------------
$this->load->helper('number');
$data['processes'] = $this->db->query('SHOW PROCESSLIST')->result();
// -------------------------------------
$this->template->connection = $connection;
$this->template->build('admin/overview', $data);
}
* @version 0.4.1
* @lastmodified August 23, 2016
*
*/
// Must include code to stop this file being access directly
if (defined('WB_PATH') == false) {
die("Cannot access this file directly");
}
if (is_object($database->DbHandle)) {
$title = "MySQLi Info";
$server_info = mysqli_get_server_info($database->DbHandle);
$host_info = mysqli_get_host_info($database->DbHandle);
$proto_info = mysqli_get_proto_info($database->DbHandle);
$client_info = mysqli_get_client_info($database->DbHandle);
$client_encoding = mysqli_character_set_name($database->DbHandle);
$status = explode(' ', mysqli_stat($database->DbHandle));
} else {
$title = "MySQL Info";
$server_info = mysql_get_server_info();
$host_info = mysql_get_host_info();
$proto_info = mysql_get_proto_info();
$client_info = mysql_get_client_info();
$client_encoding = mysql_client_encoding();
$status = explode(' ', mysql_stat());
}
$strictMode = $database->get_one('SELECT @@sql_mode');
$strict_info = (strpos($strictMode, 'STRICT_TRANS_TABLES') !== false or strpos($strictMode, 'STRICT_ALL_TABLES') !== false) ? "MySQL strict mode active" : "MySQL strict mode not active\n";
?>
<table cellpadding="3" border="0">
<tbody>
<tr class="h">
<?php require_once "connect.inc"; /*** test mysqli_connect 127.0.0.1 ***/ $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); $status = mysqli_stat($link); var_dump(strlen($status) > 0); mysqli_close($link); print "done!";
public function Stat()
{
return mysqli_stat($GLOBALS['___mysqli_ston']);
}
$your_version.="<tr><td align=\"right\">Current version:</td><td align=\"left\">".implode(" ",$last_version)."</td></tr>\n";
$your_version.="<tr><td colspan=\"2\" align=\"center\">Get Last Version <a href=\"http://www.btiteam.org\" target=\"_blank\">here</a>!</td></tr>\n</table>";
}
else
{
$your_version.="You have the latest xBtit version installed.($tracker_version Rev.$tracker_revision)";
}
if (!empty($your_version))
$admin["xbtit_version"]=$your_version."<br />\n";
*/
$admin["infos"] .= "<br />\n<table border=\"0\">\n";
$admin["infos"] .= "<tr><td class=\"header\" align=\"center\">Server's OS</td></tr><tr><td align=\"left\">" . php_uname() . "</td></tr>";
$admin["infos"] .= "<tr><td class=\"header\" align=\"center\">PHP version</td></tr><tr><td align=\"left\">" . phpversion() . "</td></tr>";
$sqlver = mysqli_fetch_row(do_sqlquery("SELECT VERSION()"));
$admin["infos"] .= "\n<tr><td class=\"header\" align=\"center\">MYSQL version</td></tr><tr><td align=\"left\">{$sqlver['0']}</td></tr>";
$sqlver = mysqli_stat($GLOBALS["___mysqli_ston"]);
$sqlver = explode(' ', $sqlver);
$admin["infos"] .= "\n<tr><td valign=\"top\" class=\"header\" align=\"center\">MYSQL stats</td></tr>\n";
for ($i = 0; $i < count($sqlver); $i++) {
$admin["infos"] .= "<tr><td align=\"left\">{$sqlver[$i]}</td></tr>\n";
}
$admin["infos"] .= "\n</table><br />\n";
unset($sqlver);
// check for news on btiteam site (read rss from comunication forum)
/*
if($btit_url_rss!="")
{
include("$THIS_BASEPATH/include/class.rssreader.php");
$btit_news=get_cached_version($btit_url_rss);
function mysql_stat()
{
return mysqli_stat($this->link);
}
<?php
require_once "connect.inc";
$tmp = NULL;
$link = NULL;
$test_table_name = 'test_mysqli_stat_table_1';
require 'table.inc';
if (!is_string($tmp = mysqli_stat($link)) || '' === $tmp) {
printf("[004] Expecting non empty string, got %s/'%s', [%d] %s\n", gettype($tmp), $tmp, mysqli_errno($link), mysql_error($link));
}
mysqli_close($link);
if (!is_null($tmp = mysqli_stat($link))) {
printf("[005] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
}
print "done!";
<?php
require_once "connect.inc";
if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) {
printf("[001] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
}
var_dump(soundex(mysqli_stat($link)) === soundex($link->stat));
echo "done!";
function mysql_stat($link = NULL)
{
$link = mysql_resolve_link($link);
return mysqli_stat($link);
}
function mysql_stat($link_identifier = null)
{
return mysqli_stat(mysql_ensure_link($link_identifier));
}
/**
* Get stats about the Mysql Server
*
* @return string
* @throws Exception
*/
public function stat()
{
if ($this->checkConnection()) {
return mysqli_stat($this->connection);
} else {
throw new \Exception("Mysql Connection failed");
}
}
} else {
if (isset($_GET['envi'])) {
echo '<table width="500">' . get_phpinfo(INFO_ENVIRONMENT) . '</table>';
} else {
if (isset($_GET['vars'])) {
echo '<table width="500">' . get_phpinfo(INFO_VARIABLES) . '</table>';
} else {
if (isset($_GET['database'])) {
switch (DB_TYPE) {
case 'mysql':
case 'mysqli':
$details = $db->get_details();
if (DB_TYPE == 'mysql') {
$stat = mysql_stat($db->connect_id);
} else {
$stat = mysqli_stat($db->connect_id);
}
$stat = preg_split('/:\\s+([0-9]*\\.?[0-9]*)/', $stat, -1, PREG_SPLIT_DELIM_CAPTURE ^ PREG_SPLIT_NO_EMPTY);
// stat[0] had better always be uptime...
$days = intval($stat[1] / 86400);
$stat[1] -= $days * 86400;
$hrs = intval($stat[1] / 3600);
$stat[1] -= $hrs * 3600;
$mins = intval($stat[1] / 60);
$stat[1] -= $mins * 60;
$secs = $stat[1];
$stat[1] = $days . "D " . $hrs . "H " . $mins . "M " . $secs . "S";
echo '<table border="0" width="100%">
<tr><td valign="top">
<table border="0">
<tr><td valign="top"><div class="genmed"><strong>Quick Stats:</strong></div></td></tr>
function mysql_stat(\mysqli $link = null)
{
return mysqli_stat(\Dshafik\MySQL::getConnection($link));
}
function mysql_stat($c = null)
{
if (($c = mysql_global_resource($c, 1 - func_num_args())) == null) {
return;
}
return mysqli_stat($c);
}
function mysql_compat_stat($link = NULL)
{
if (!isset($link)) {
$link = $GLOBALS['mysql_compat_last_link'];
}
return mysqli_stat($link);
}
/**
* Checks if current mysql connection is alive
* @return bool Returns TRUE if connection is alive, else returns FALSE
*/
public function isConnected()
{
return isset($this->dbLink) && $this->dbLink !== NULL && mysqli_stat($this->dbLink) !== NULL;
}
assert(mysqli_errno($link) === $mysqli->errno);
printf("mysqli->errno = '%s'/%s ('%s'/%s)\n", $mysqli->errno, gettype($mysqli->errno), mysqli_errno($link), gettype(mysqli_errno($link)));
assert(mysqli_error($link) === $mysqli->error);
printf("mysqli->error = '%s'/%s ('%s'/%s)\n", $mysqli->error, gettype($mysqli->error), mysqli_error($link), gettype(mysqli_error($link)));
if (version_compare(PHP_VERSION, '5.3.99', '>')) {
assert(mysqli_error_list($link) === $mysqli->error_list);
assert(is_array($mysqli->error_list));
}
assert(mysqli_field_count($link) === $mysqli->field_count);
printf("mysqli->field_count = '%s'/%s ('%s'/%s)\n", $mysqli->field_count, gettype($mysqli->field_count), mysqli_field_count($link), gettype(mysqli_field_count($link)));
assert(mysqli_insert_id($link) === $mysqli->insert_id);
printf("mysqli->insert_id = '%s'/%s ('%s'/%s)\n", $mysqli->insert_id, gettype($mysqli->insert_id), mysqli_insert_id($link), gettype(mysqli_insert_id($link)));
assert(mysqli_sqlstate($link) === $mysqli->sqlstate);
printf("mysqli->sqlstate = '%s'/%s ('%s'/%s)\n", $mysqli->sqlstate, gettype($mysqli->sqlstate), mysqli_sqlstate($link), gettype(mysqli_sqlstate($link)));
assert(soundex(mysqli_stat($link)) == soundex($mysqli->stat));
printf("mysqli->stat = '%s'/%s ('%s'/%s)\n", $mysqli->stat, gettype($mysqli->stat), mysqli_stat($link), gettype(mysqli_stat($link)));
assert(mysqli_get_host_info($link) === $mysqli->host_info);
printf("mysqli->host_info = '%s'/%s ('%s'/%s)\n", $mysqli->host_info, gettype($mysqli->host_info), mysqli_get_host_info($link), gettype(mysqli_get_host_info($link)));
/* note that the data types are different */
assert(mysqli_info($link) == $mysqli->info);
printf("mysqli->info = '%s'/%s ('%s'/%s)\n", $mysqli->info, gettype($mysqli->info), mysqli_info($link), gettype(mysqli_info($link)));
assert(mysqli_thread_id($link) > $mysqli->thread_id);
assert(gettype($mysqli->thread_id) == gettype(mysqli_thread_id($link)));
printf("mysqli->thread_id = '%s'/%s ('%s'/%s)\n", $mysqli->thread_id, gettype($mysqli->thread_id), mysqli_thread_id($link), gettype(mysqli_thread_id($link)));
assert(mysqli_get_proto_info($link) === $mysqli->protocol_version);
printf("mysqli->protocol_version = '%s'/%s ('%s'/%s)\n", $mysqli->protocol_version, gettype($mysqli->protocol_version), mysqli_get_proto_info($link), gettype(mysqli_get_proto_info($link)));
assert(mysqli_get_server_info($link) === $mysqli->server_info);
printf("mysqli->server_info = '%s'/%s ('%s'/%s)\n", $mysqli->server_info, gettype($mysqli->server_info), mysqli_get_server_info($link), gettype(mysqli_get_server_info($link)));
assert(mysqli_get_server_version($link) === $mysqli->server_version);
printf("mysqli->server_version = '%s'/%s ('%s'/%s)\n", $mysqli->server_version, gettype($mysqli->server_version), mysqli_get_server_version($link), gettype(mysqli_get_server_version($link)));
assert(mysqli_warning_count($link) === $mysqli->warning_count);
