$query_input->set_attribute_str('name', 'query');
if (isset($_GET['query'])) {
$query_input->append_str_to_content(stripcslashes($_GET['query']));
}
$query_input->set_attribute_str('cols', 72);
$query_input->set_attribute_str('rows', 15);
$query_li->append_tag_to_content($query_input);
$form_ul->add_li($query_li);
/*
* The submit button.
*/
$submit_button = new HTMLTags_Input();
$submit_button->set_attribute_str('type', 'submit');
$submit_button->set_attribute_str('value', 'GO');
$submit_button->set_attribute_str('class', 'submit');
$form_ul->add_tag_in_new_li($submit_button);
$query_form->append_tag_to_content($form_ul);
$content_div->append_tag_to_content($query_form);
/*
* Get the data.
*/
if (isset($_GET['query'])) {
$query = stripcslashes($_GET['query']);
if (strlen($query) == 0) {
$p = new HTMLTags_P('Try typing a SELECT statement.');
$content_div->append_tag_to_content($p);
} elseif (preg_match('/^(?:\\s*\\()*\\s*(?:(?:EXPLAIN\\s*)?SELECT|SHOW)\\s/i', $query)) {
$muf = Database_MySQLUserFactory::get_instance();
$mu = $muf->get_for_this_project();
$dbh = $mu->get_database_handle();
$result = mysql_query($query, $dbh);
