<?php require_once 'connect.inc'; $conn = mysql_connect($host, $user, $passwd); $res = mysql_list_processes(); $process = mysql_fetch_assoc($res); var_dump(!empty($process['Id']));
/** * Test mysql_list_processes * * @return boolean */ public function MySQL_List_Processes_Test() { $dbs1 = mysql_list_processes(); $dbs2 = $this->_object->mysql_list_processes(); $list1 = array(); $list2 = array(); while ($row = mysql_fetch_assoc($dbs1)) { $list1[] = $row; } while ($row = $this->_object->mysql_fetch_assoc($dbs2)) { $list2[] = $row; } $count = count($list1); for ($x = 0; $x < $count; $x++) { if ($list1[$x]['Id'] != $list1[$x]['Id']) { return false; } } return true; }
function db_list_processes() { return mysql_list_processes(); }
/** * Test mysql_list_processes * * @return boolean */ public function MySQL_List_Processes_Test() { $dbs1 = mysql_list_processes(); while ($row = mysql_fetch_assoc($dbs1)) { if (!is_numeric($row['Id'])) { return false; } } return true; }
$link = NULL; if (NULL !== ($tmp = @mysql_list_processes($link, $link))) { printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); } require 'table.inc'; if (!($res = mysql_list_processes($link))) { printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link)); } if (!($num = mysql_num_rows($res))) { printf("[003] Empty process list? [%d] %s\n", mysql_errno($link), mysql_error($link)); } $row = mysql_fetch_array($res, MYSQL_NUM); if (version_compare(PHP_VERSION, '5.9.9', '>') == 1 && !is_unicode($row[0])) { printf("[004] Check for unicode support\n"); var_inspect($row); } mysql_free_result($res); if (!($res = mysql_list_processes())) { printf("[005] [%d] %s\n", mysql_errno(), mysql_error()); } if (!($num = mysql_num_rows($res))) { printf("[006] Empty process list? [%d] %s\n", mysql_errno(), mysql_error()); } $row = mysql_fetch_array($res, MYSQL_NUM); if (version_compare(PHP_VERSION, '5.9.9', '>') == 1 && !is_unicode($row[0])) { printf("[007] Check for unicode support\n"); var_inspect($row); } mysql_free_result($res); mysql_close($link); print "done!\n";
function SQLEditor() { extract($_SESSION); $conn = @mysql_connect($mhost . ":" . $mport, $muser, $mpass); if ($conn) { echo "Logged in as {$muser}@{$mhost} <a href='{$self}?act=logout'>[Logout]</a><center>"; echo "<form method='POST' action='{$self}?'>\n Quick SQL query: <input type='text' style='width: 300px' value='select * from users' name='sqlquery'>\n <input type='hidden' name='db' value='{$_GET['db']}'>\n <input type='submit' value='Go' name='sql'>\n </form>"; echo "<form action='{$self}?act=sqledit' method='post'>\n <input type='submit' style='border: none;' value='[ List Processes ]' name='sql_list_proc'>\n </form></center></br></br>"; if (isset($_POST['sql_list_proc'])) { $res = mysql_list_processes(); echo "<table style='margin: auto; text-align: center;'><tr>\n <td>Proc ID</td><td>Host</td><td>DB</td><td>Command</td><td>Time</td>\n </tr>"; while ($r = mysql_fetch_assoc($res)) { echo "<tr><td>{$r['Id']}</td><td>{$r['Host']}</td><td>{$r['db']}</td><td>{$r['Command']}</td><td>{$r['Time']}</td></tr>"; } mysql_free_result($res); echo "</table></br>"; } if (!isset($_GET['db'])) { if (isset($_POST['dbc'])) { db_create(); } if (isset($_GET['dropdb'])) { SQLDrop(); } echo "<table style='margin: auto; text-align: center;'>\n <tr><td>Database</td><td>Table count</td><td>Download</td><td>Drop</td></tr>"; $all_your_base = mysql_list_dbs($conn); while ($your_base = mysql_fetch_assoc($all_your_base)) { $tbl = mysql_query("SHOW TABLES FROM {$your_base['Database']}"); $tbl_count = mysql_num_rows($tbl); echo "<tr><td><a href='{$self}?act=sqledit&db={$your_base['Database']}'>{$your_base['Database']}</td><td>{$tbl_count}</td><td><a href='{$self}?act=download&db={$your_base['Database']}'>Download</a></td><td><a href='{$self}?act=sqledit&dropdb={$your_base['Database']}'>Drop</a></td></tr>"; } echo "</table></br><center><form action='{$self}?act=sqledit' method='post'>New database name: <input type='text' value='new_database' name='db_name'><input type='submit' style='border: none;' value='[ Create Database ]' name='dbc'></form></center></br>"; } elseif (isset($_GET['db']) && !isset($_GET['tbl'])) { if (isset($_POST['tblc'])) { table_create(); } if (isset($_GET['droptbl'])) { SQLDrop(); } echo "<table style='margin: auto; text-align: center;'>\n <tr><td>Table</td><td>Column count</td><td>Dump</td><td>Drop</td></tr>"; $tables = mysql_query("SHOW TABLES FROM {$_GET['db']}"); while ($tblc = mysql_fetch_array($tables)) { $fCount = mysql_query("SHOW COLUMNS FROM {$_GET['db']}.{$tblc['0']}"); $fc = mysql_num_rows($fCount); echo "<tr><td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$tblc['0']}'>{$tblc['0']}</a></td><td>{$fc}</td><td><a href='{$self}?act=download&db={$_GET['db']}&tbl={$tblc['0']}'>Dump</td><td><a href='{$self}?act=sqledit&db={$_GET['db']}&droptbl={$tblc['0']}'>Drop</a></td></tr>"; } echo "</table></br><center><form action='{$self}?act=sqledit&db={$_GET['db']}' method='post'>Create new table: <input type='text' value='new_table' name='table_name'><input type='hidden' value='{$_GET['db']}' name='db_current'> <input type='submit' style='border: none;' value='[ Create Table ]' name='tblc'></form></center>"; } elseif (isset($_GET['field']) && isset($_POST['sqlsave'])) { $discard_values = mysql_query("SELECT * FROM {$_GET['db']}.{$_GET['tbl']} WHERE {$_GET['field']}='{$_GET['v']}'"); $values = mysql_fetch_assoc($discard_values); $keys = array_keys($values); $values = array(); foreach ($_POST as $k => $v) { if (in_array($k, $keys)) { $values[] = $v; } } $query = "UPDATE {$_GET['db']}.{$_GET['tbl']} SET "; for ($y = 0; $y < count($values); $y++) { if ($y == count($values) - 1) { $query .= "{$keys[$y]}='{$values[$y]}' "; } else { $query .= "{$keys[$y]}='{$values[$y]}', "; } } $query .= "WHERE {$_GET['field']} = '{$_GET['v']}'"; $try = mysql_query($query) or die(mysql_error()); echo "<center>Table updated!<br>"; echo "<a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}'>Go back</a><br><br>"; } elseif (isset($_GET['field']) && isset($_GET['v']) && !isset($_GET['del'])) { echo "<center><form action='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&field={$_GET['field']}&v={$_GET['v']}' method='post'>"; $sql_fields = array(); $fields = mysql_query("SHOW COLUMNS FROM {$_GET['db']}.{$_GET['tbl']}"); while ($field = mysql_fetch_assoc($fields)) { $sql_fields[] = $field['Field']; } $data = mysql_query("SELECT * FROM {$_GET['db']}.{$_GET['tbl']} WHERE {$_GET['field']}='{$_GET['v']}'"); $d_piece = mysql_fetch_assoc($data); for ($m = 0; $m < count($sql_fields); $m++) { $point = $sql_fields[$m]; echo "{$point}: <input type='text' value='{$d_piece[$point]}' name='{$sql_fields[$m]}'></br>"; } echo "<input type='submit' value='Save' name='sqlsave'></form></center>"; } elseif (isset($_GET['db']) && isset($_GET['tbl'])) { if (isset($_GET['insert'])) { SQLInsert(); } if (isset($_GET['field']) && isset($_GET['v']) && isset($_GET['del'])) { echo "<center>"; if (@mysql_query("DELETE FROM {$_GET['db']}.{$_GET['tbl']} WHERE {$_GET['field']}={$_GET['v']}")) { echo "Row deleted</br>"; } else { echo "Failed to delete row</br>"; } echo "</center>"; } echo "<center><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&insert=1'>[Insert new row]</a></center>"; echo "<table style='margin: auto; text-align: center;'><tr>"; $cols = mysql_query("SHOW COLUMNS FROM {$_GET['db']}.{$_GET['tbl']}"); $fields = array(); while ($col = mysql_fetch_assoc($cols)) { array_push($fields, $col['Field']); echo "<td>{$col['Field']}</td>"; } echo "</tr>"; if (isset($_GET['s']) && is_numeric($_GET['s'])) { $selector = mysql_query("SELECT * FROM {$_GET['db']}.{$_GET['tbl']} LIMIT {$_GET['s']}, 250"); } else { $selector = mysql_query("SELECT * FROM {$_GET['db']}.{$_GET['tbl']} LIMIT 0, 250"); } while ($select = mysql_fetch_row($selector)) { echo "<tr>"; for ($i = 0; $i < count($fields); $i++) { echo "<td>" . htmlspecialchars($select[$i]) . "</td>"; } echo "<td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&field={$fields['0']}&v={$select['0']}'>Edit</a></td><td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&field={$fields['0']}&v={$select['0']}&del=true'>Delete</a></td>"; echo "</tr>"; } echo "</table>"; echo "<table style='margin: auto;'>"; if (isset($_GET['s'])) { $prev = intval($_GET['s']) - 250; $next = intval($_GET['s']) + 250; if ($_GET['s'] > 0) { echo "<tr><td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&s={$prev}'>Previous</a></td>"; } if (mysql_num_rows($selector) > 249) { echo "<td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&s={$next}'>Next</a></td></tr>"; } } else { echo "<center><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&s=250'>Next</a></center>"; } echo "</table>"; } else { $_SESSION = array(); session_destroy(); header("Location: {$self}?act=sql"); } } }
function MySQLProcesses() { return MySQLFetchAssociativeArray(mysql_list_processes()); }
/** * list processes. * show a list of running (connected) processes and what they are doing * * @access public * @return array */ public function listProcesses() { $out = array(); if ($this->connect()) { $process_list = mysql_list_processes($this->_connection); while ($row = mysql_fetch_assoc($process_list)) { array_push($out, $row); } mysql_free_result($process_list); } return $out; }
function listProcesses() { /* 列出 MySQL 进程 */ $this->Result = mysql_list_processes($this->LinkId); return $this->Result ? true : false; }
public function GetProcesses($mode = 0, $time_limit = 0) { if ($this->DB_conn == NULL) { return ""; } $result = array(); $rs = mysql_list_processes($this->DB_conn); while ($row = mysql_fetch_assoc($rs)) { if ($row["Time"] < $time_limit) { continue; } if ($mode == 1) { $result[] = $row; } elseif ($mode == 2) { $result[] = $row['Id']; } else { $result[] = sprintf("%s - %s (%s)", $row["Id"], empty($row["Info"]) ? $row["Command"] : $row["Info"], $row["Time"]); } } return $result; }
echo '<b>POST:</b>'; print_r($_POST); echo '<b>SESSION:</b>'; print_r($_SESSION); echo '<b>COOKIES:</b>'; print_r($HTTP_COOKIE_VARS); echo '<b>$_SERVER:</b>'; print_r($_SERVER); $mt_end = getMicroTime(); echo "<b>Time elapsed</b>: " . round(($mt_end - $mt_start) * 1000) . " ms \n"; // echo "<b>Query number</b>: $query_number\n"; echo "<b>mysql stats:</b>\n"; $status = explode(' ', mysql_stat()); print_r($status); echo "<b>mysql processes</b>:\n"; $result = mysql_list_processes(); while ($row = mysql_fetch_assoc($result)) { printf("%s %s %s %s %s\n", $row["Id"], $row["Host"], $row["db"], $row["Command"], $row["Time"]); } mysql_free_result($result); echo "<b>Locales:</b>\n"; system("locale"); echo '</pre></div>'; } ?> <div id="revision"><?php echo $Revision; ?> </div> <script type="text/javascript" language=javascript src=/js/wz_tooltip.js></script> <script type="text/javascript" src="/js/inpage_popup.js"></script>
function updatelist() { global $runinit; if ($runinit['astream']) { $ids = array(); $res = mysql_list_processes(); while ($row = mysql_fetch_assoc($res)) { $ids[$row['Id']] = true; } db_free($res); $res = db_execquery('SELECT h_id, mid FROM ' . TBL_MHISTORY . ' WHERE active = 1'); if ($res) { while ($row = mysql_fetch_row($res)) { if (!isset($ids[$row[1]])) { db_execquery('UPDATE ' . TBL_MHISTORY . ' SET active = 0 WHERE h_id = ' . $row[0]); } } } } }
if (!($res = mysql_list_processes())) { printf("FAILURE: cannot run mysql_list_fields() on default connection, [%d] %s\n", mysql_errno($con), mysql_error($con)); } $row = mysql_fetch_array($res); if (!is_array($row)) { printf("FAILURE: expecting array, got %s value, [%d] %s\n", gettype($row), mysql_errno($con), mysql_error($con)); } if (!array_key_exists("Id", $row) || !array_key_exists("User", $row) || !array_key_exists("Host", $row) || !array_key_exists("db", $row) || !array_key_exists("Command", $row) || !array_key_exists("Time", $row) || !array_key_exists("State", $row) || !array_key_exists("Info", $row) || !array_key_exists(0, $row) || !array_key_exists(1, $row) || !array_key_exists(2, $row) || !array_key_exists(3, $row) || !array_key_exists(4, $row) || !array_key_exists(5, $row) || !array_key_exists(6, $row) || !array_key_exists(7, $row) || $row[0] != $row["Id"]) { printf("FAILURE: result hash does not have the expected entries, [%d] %s\n", mysql_errno($con), mysql_error($con)); } mysql_free_result($res); if (!($res = mysql_list_processes($con))) { printf("FAILURE: cannot run mysql_list_fields(), [%d] %s\n", mysql_errno(), mysql_error()); } mysql_free_result($res); $res = mysql_list_processes($illegal_link_identifier); if (!is_null($res)) { printf("FAILURE: expecting null value, got %s value, [%d] %s\n", gettype($res), mysql_errno($con), mysql_error($con)); } if ($res) { printf("FAILURE: expecting false, [%d] %s\n", mysql_errno($con), mysql_error($con)); } mysql_close($con); ?> --EXPECT-EXT/MYSQL-OUTPUT-- SUCCESS: connect --EXPECT-EXT/MYSQL-PHP-ERRORS-- --EXPECT-EXT/MYSQLI-OUTPUT-- SUCCESS: connect