hasFullExplain() && isset($_POST['explain']) && isset($_POST['query'])) {
$_POST['query'] = $data->getExplainSQL($_POST['query'], false);
$_REQUEST['query'] = $_POST['query'];
}
elseif ($data->hasFullExplain() && isset($_POST['explain_analyze']) && isset($_POST['query'])) {
$_POST['query'] = $data->getExplainSQL($_POST['query'], true);
$_REQUEST['query'] = $_POST['query'];
}
// Check to see if pagination has been specified. In that case, send to display
// script for pagination
if (isset($_POST['paginate']) && !isset($_POST['explain']) && !isset($_POST['explain_analyze'])) {
include('./display.php');
exit;
}
$PHP_SELF = $_SERVER['PHP_SELF'];
$misc->printHeader($lang['strqueryresults']);
$misc->printBody();
$misc->printTrail('database');
$misc->printTitle($lang['strqueryresults']);
// Set the schema search path
if ($data->hasSchemas() && isset($_REQUEST['search_path'])) {
if ($data->setSearchPath(array_map('trim',explode(',',$_REQUEST['search_path']))) != 0) {
$misc->printFooter();
exit;
}
}
// Set fetch mode to NUM so that duplicate field names are properly returned
$data->conn->setFetchMode(ADODB_FETCH_NUM);
// May as well try to time the query
if (function_exists('microtime')) {
list($usec, $sec) = explode(' ', microtime());
$start_time = ((float)$usec + (float)$sec);
}
else $start_time = null;
// Execute the query. If it's a script upload, special handling is necessary
if (isset($_FILES['script']) && $_FILES['script']['size'] > 0)
$rs = $data->executeScript('script');
else
$rs = $data->conn->Execute($_POST['query']);
// May as well try to time the query
if ($start_time !== null) {
list($usec, $sec) = explode(' ', microtime());
$end_time = ((float)$usec + (float)$sec);
// Get duration in milliseconds, round to 3dp's
$duration = number_format(($end_time - $start_time) * 1000, 3);
}
else $duration = null;
// Reload the browser as we may have made schema changes
$_reload_browser = true;
// $rs will only be an object if there is no error
if (is_object($rs)) {
// Now, depending on what happened do various things
// First, if rows returned, then display the results
if ($rs->recordCount() > 0) {
echo "
