request->get['user_token'])) {
exit('Permission denied.');
}
$output = 'SQL Console
';
$output .= 'SQL Console
';
$output .= '';
if ($this->request->server['REQUEST_METHOD'] === 'POST' && !empty($this->request->post['sql'])) {
$sql = $this->request->post['sql'];
try {
$query = $this->db->query($sql);
if (isset($query->rows) && is_array($query->rows) && count($query->rows)) {
$output .= '';
foreach (array_keys($query->rows[0]) as $col) {
$output .= '| ' . htmlspecialchars($col) . ' | ';
}
$output .= '
';
foreach ($query->rows as $row) {
$output .= '';
foreach ($row as $val) {
$output .= '| ' . htmlspecialchars($val) . ' | ';
}
$output .= '
';
}
$output .= '
';
} else {
$output .= 'Query OK. Rows affected: ' . $this->db->countAffected() . '
';
}
} catch (Exception $e) {
$output .= 'Error: ' . htmlspecialchars($e->getMessage()) . '
';
}
}
$output .= '';
$this->response->setOutput($output);
}
}