Beispiel #1
0
require_once 'init.php';
$return = array();
$label = $_REQUEST['label'];
$database = $_REQUEST['db'];
$table = $_REQUEST['table'];
$return['label'] = $label;
$return['database'] = $database;
$return['table'] = $table;
$return['column'] = $col;
$return['title'] = "{$database}.{$table}";
$host = $explainhosts[$label];
Database::connect(null, $host['user'], $host['password'], null, null, 'pdo', array('dsn' => $host['dsn']), $label);
Database::find($label)->query('USE ' . Database::escapeField($database));
list($tmp, $return['create']) = Database::find($label)->query_row('SHOW CREATE TABLE ' . Database::escapeField($table));
$return['create'] = SqlParser::html($return['create']);
$desc = Database::find($label)->query_list_assoc('DESC ' . Database::escapeField($table));
$return['desc'] = '<table><thead><tr>';
foreach (array_keys($desc[0]) as $key) {
    $return['desc'] .= '<th>' . $key . '</th>';
}
$return['desc'] .= '</tr></thead><tbody>';
foreach ($desc as $row) {
    $return['desc'] .= '<tr>';
    foreach ($row as $key => $val) {
        $return['desc'] .= '<td>' . ifnull($val, 'NULL') . '</td>';
    }
    $return['desc'] .= '</tr>';
}
$return['desc'] .= '</tbody></table>';
unset($desc);
Beispiel #2
0
            $primaryKey .= ", {$field} ";
        }
    }
    $offset = 0;
    if (isset($_REQUEST['offset']) && $_REQUEST['offset'] > 0) {
        $offset = intval($_REQUEST['offset']);
    }
    $res = Database::find('review')->query('SELECT review.sample ' . $primaryKey . '
								  FROM ' . Database::escapeField($reviewhost['history_table']) . ' AS review
								 WHERE review.checksum = ?
							  ORDER BY review.ts_max DESC
							     LIMIT 1
								OFFSET ' . $offset, $_REQUEST['checksum']);
    $row = $res->fetch_assoc();
    $return['sample'] = $row['sample'];
    foreach ($reviewhost['history_table_primary'] as $field) {
        $return['primary'][$field] = $row[$field];
    }
    $return['offset'] = $offset;
} else {
    $return['sample'] = Database::find('review')->query_col('SELECT review.sample
									FROM ' . Database::escapeField($reviewhost['review_table']) . ' AS review
								   WHERE review.checksum = ?', $_REQUEST['checksum']);
}
if (strlen($return['sample'])) {
    $return['sample'] = SqlParser::html($return['sample']);
}
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
echo json_encode($return);