Check All
";
}
else{
$db_list="Check All
";
}
if($db_host && $db_user){
mysql_connect("$db_host","$db_user","$db_password") or die("Error: No BD Connection");
$rs = mysql_query("show databases");
$db_names=array();
while($arr=mysql_fetch_array($rs)){
if( $arr[0] =="mysql" || $arr[0] =="information_schema"){
continue;
}
$db_names[]=$arr[0];
}
foreach($db_names as $db_name) {
$db_list.="$chk_name){
if ($db_name == $chk_name){
$db_list.=" checked";
}
}
$db_list.=">{$db_name}
";
}
}
?>
Query: ". $query . "
";
foreach( $_POST['check'] as $key=>$db_name){
$db_check = @mysql_select_db ( $db_name );
if ($execute_queries && $query != "") {
if (strncasecmp( $query, "select" , 5 ) === 0) {
$sql_select = true;
}
else{
$sql_select = false;
}
mysql_query("SET NAMES utf8");
$result = mysql_query($query);
if ($result) {
// Post Select
if ($sql_select) {
echo "DB: " . $db_name . "
";
// echo "- Query: ". $query . "
";
echo "- Execute succeed - select rows: " . mysql_affected_rows() . "
";
$title = false;
$title_html = "";
$result_html = "";
while( $row = mysql_fetch_assoc($result) ){
if(!$title){
$title_html .= "";
foreach( $row as $field_name => $field_value ){
$title_html .= "| {$field_name} | " ;
}
$title_html .= "
";
$title = true;
}
$result_html .= "";
foreach( $row as $field_name => $field_value ){
$result_html .= "| {$field_value} | " ;
}
$result_html .= "
";
}
$result_html = " " . $title_html . $result_html . "
";
echo $result_html;
}
// Post Execute
else {
echo "DB: " . $db_name . "
";
// echo "- Query: ". $query . "
";
echo "- Execute succeed - affected rows: " . mysql_affected_rows() . "
";
}
}
else{
echo "DB: " . $db_name . "
";
// echo "- Query: ". $query . "
";
echo "- Error: " . mysql_error() . "
";
}
}
}
}
?>