echo ' <!-- Search results in table ' . $onetable . ' (' . $res_cnt . ') -->' . "\n" . ' <br />' . "\n" . ' <table><tr><td>' . sprintf($strNumSearchResultsInTable, $res_cnt, htmlspecialchars($onetable)) . "</td>\n";
if ($res_cnt > 0) {
echo '<td>' . PMA_linkOrButton('sql.php?' . $url_sql_query . '&sql_query=' . urlencode($newsearchsqls['select_fields']), $strBrowse, '') . "</td>\n";
echo '<td>' . PMA_linkOrButton('sql.php?' . $url_sql_query . '&sql_query=' . urlencode($newsearchsqls['delete']), $strDelete, $newsearchsqls['delete']) . "</td>\n";
}
// end if
echo '</tr></table>' . "\n";
} else {
if (isset($table_select)) {
// Displays search string
echo ' ' . sprintf($strSearchResultsFor, htmlspecialchars($original_search_str), $option_str) . "\n";
echo ' <ul>' . "\n";
$num_search_result_total = 0;
for ($i = 0; $i < $num_selectedtables; $i++) {
// Gets the SQL statements
$newsearchsqls = PMA_getSearchSqls($table_select[$i], $search_str, $search_option);
// Executes the "COUNT" statement
$res = PMA_DBI_query($newsearchsqls['select_count']);
$res_cnt = PMA_DBI_fetch_assoc($res);
$res_cnt = $res_cnt['count'];
PMA_DBI_free_result($res);
unset($res);
$num_search_result_total += $res_cnt;
echo ' <!-- Search results in table ' . $table_select[$i] . ' (' . $res_cnt . ') -->' . "\n" . ' <li>' . "\n" . ' <table><tr><td>' . sprintf($strNumSearchResultsInTable, $res_cnt, htmlspecialchars($table_select[$i])) . "</td>\n";
if ($res_cnt > 0) {
echo '<td>' . PMA_linkOrButton('sql.php?' . $url_sql_query . '&sql_query=' . urlencode($newsearchsqls['select_fields']), $strBrowse, '') . "</td>\n";
echo '<td>' . PMA_linkOrButton('sql.php?' . $url_sql_query . '&sql_query=' . urlencode($newsearchsqls['delete']), $strDelete, $newsearchsqls['delete']) . "</td>\n";
}
// end if
echo ' </tr></table></li>' . "\n";
}
$sql['select_count'] = $sqlstr_select . ' COUNT(*) AS `count`' . $sqlstr_from . $sqlstr_where;
$sql['delete'] = $sqlstr_delete . $sqlstr_from . $sqlstr_where;
return $sql;
}
// end of the "PMA_getSearchSqls()" function
/**
* Displays the results
*/
$this_url_params = array('db' => $GLOBALS['db'], 'goto' => 'db_sql.php', 'pos' => 0, 'is_js_confirmed' => 0);
// Displays search string
echo '<br />' . "\n" . '<table class="data">' . "\n" . '<caption class="tblHeaders">' . "\n" . sprintf(__('Search results for "<i>%s</i>" %s:'), $searched, $option_str) . "\n" . '</caption>' . "\n";
$num_search_result_total = 0;
$odd_row = true;
foreach ($tables_selected as $each_table) {
// Gets the SQL statements
$newsearchsqls = PMA_getSearchSqls($each_table, !empty($field_str) ? $field_str : '', $search_str, $search_option);
// Executes the "COUNT" statement
$res_cnt = PMA_DBI_fetch_value($newsearchsqls['select_count']);
$num_search_result_total += $res_cnt;
$sql_query .= $newsearchsqls['select_count'];
echo '<tr class="noclick ' . ($odd_row ? 'odd' : 'even') . '">' . '<td>' . sprintf(_ngettext('%1$s match inside table <i>%2$s</i>', '%1$s matches inside table <i>%2$s</i>', $res_cnt), $res_cnt, htmlspecialchars($each_table)) . "</td>\n";
if ($res_cnt > 0) {
$this_url_params['sql_query'] = $newsearchsqls['select_fields'];
$browse_result_path = 'sql.php' . PMA_generate_common_url($this_url_params);
?>
<td> <a name="browse_search" href="<?php
echo $browse_result_path;
?>
" onclick="loadResult('<?php
echo $browse_result_path;
?>
$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";
