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";