$_SESSION['query_history'][md5(strtolower($queryStr))] = $queryStr; if (sizeof($_SESSION['query_history']) > $maxSavedQueries) { array_shift($_SESSION['query_history']); } } $query = explode_sql($delimiter, $queryStr); //explode the query string into individual queries based on the delimiter for ($i = 0; $i < sizeof($query); $i++) { if (str_replace(" ", "", str_replace("\n", "", str_replace("\r", "", $query[$i]))) != "") { $queryTimer = new MicroTimer(); $result = $db->selectArray($query[$i], "assoc"); $queryTimer->stop(); echo "<div class='confirm'>"; echo "<b>"; if ($result !== NULL) { if (sizeof($result) > 0 || $db->getAffectedRows() == 0) { printf($lang['show_rows'], sizeof($result)); } if ($db->getAffectedRows() > 0 || sizeof($result) == 0) { echo $db->getAffectedRows() . " " . $lang['rows_aff'] . " "; } printf($lang['query_time'], $queryTimer); echo "</b><br/>"; } else { echo $lang['err'] . ": " . $db->getError() . "</b><br/>"; } echo "<span style='font-size:11px;'>" . htmlencode($query[$i]) . "</span>"; echo "</div><br/>"; if (sizeof($result) > 0) { $headers = array_keys($result[0]); echo "<table border='0' cellpadding='2' cellspacing='1' class='viewTable'>";
if (preg_match('/^\\s*(?:select|pragma|explain)\\s/i', $query[$i]) === 1) { $isSelect = true; $result = $db->selectArray($query[$i], "assoc"); } else { $isSelect = false; $result = $db->query($query[$i]); } $queryTimer->stop(); echo "<div class='confirm'>"; echo "<b>"; if ($result !== false) { if ($isSelect) { $affected = sizeof($result); echo $lang['showing'] . " " . $affected . " " . $lang['rows'] . ". "; } else { $affected = $db->getAffectedRows(); echo $affected . " " . $lang['rows'] . " " . $lang['affected'] . ". "; } printf($lang['query_time'], $queryTimer); echo "</b><br/>"; } else { echo $lang['err'] . ": " . $db->getError() . ".</b><br/>"; } echo "<span style='font-size:11px;'>" . htmlencode($query[$i]) . "</span>"; echo "</div><br/>"; if ($isSelect) { if (sizeof($result) > 0) { $headers = array_keys($result[0]); echo "<table border='0' cellpadding='2' cellspacing='1' class='viewTable'>"; echo "<tr>"; for ($j = 0; $j < sizeof($headers); $j++) {