n3 . ')';
$search_option = 3;
break;
case 4:
$option_str = ' (' . $strSearchOption4 . ')';
$search_option = 4;
break;
} // end switch
$this_url_params = array(
'db' => $GLOBALS['db'],
'goto' => 'db_details.php',
'pos' => 0,
'is_js_confirmed' => 0,
);
// Displays search string
echo '<br />' . "\n"
.'<table class="data">' . "\n"
.'<caption class="tblHeaders">' . "\n"
.sprintf($strSearchResultsFor,
htmlspecialchars($original_search_str), $option_str) . "\n"
.'</caption>' . "\n";
$num_search_result_total = 0;
$odd_row = true;
foreach ( $_REQUEST['table_select'] as $each_table ) {
// Gets the SQL statements
$newsearchsqls = PMA_getSearchSqls($each_table,
$search_str, $search_option);
// Executes the "COUNT" statement
$res_cnt = PMA_DBI_fetch_value($newsearchsqls['select_count']);
$num_search_result_total += $res_cnt;
echo '<tr class="' . ( $odd_row ? 'odd' : 'even' ) . '">'
.'<td>' . sprintf($strNumSearchResultsInTable, $res_cnt,
htmlspecialchars($each_table)) . "</td>\n";
if ($res_cnt > 0) {
$this_url_params['sql_query'] = $newsearchsqls['select_fields'];
echo '<td>' . PMA_linkOrButton(
'sql.php' . PMA_generate_common_url($this_url_params),
$strBrowse, '') . "</td>\n";
$this_url_params['sql_query'] = $newsearchsqls['delete'];
echo '<td>' . PMA_linkOrButton(
'sql.php' . PMA_generate_common_url($this_url_params),
$strDelete, $newsearchsqls['delete']) . "</td>\n";
} else {
echo '<td> </td>' . "\n"
.'<td> </td>' . "\n";
}// end if else
$odd_row = ! $odd_row;
echo '</tr>' . "\n";
} // end for
echo '</table>' . "\n";
if ( count($_REQUEST['table_select']) > 1 ) {
echo '<p>' . sprintf($strNumSearchResultsTotal,
$num_search_result_total) . '</p>' . "\n";
}
} // end if (!empty($search_str) && !empty($search_option))
} // end 1.[