if ($enable_delete == "1" && $enable_delete_all_feature === 1) { echo " <a class='onlyscreen' onclick=\"if (!confirm('" . $normal_messages_ar['confirm_delete?'] . "')){ return false;}elseif (!confirm('" . $normal_messages_ar['really?'] . "')){ return false;}\" href='" . $action . "?table_name=" . urlencode($table_name) . "&function=delete_all&where_clause=" . urlencode($where_clause_to_pass) . "&page=" . $page . "&order=" . urlencode($order) . "&order_type=" . $order_type . "'>" . $normal_messages_ar['delete_all'] . "</a>"; } // end if if ($results_number > $records_per_page) { // display the navigation bar txt_out("<br><span class='page_n_of_m'>" . $normal_messages_ar["page"] . ($page + 1) . $normal_messages_ar["of"] . $pages_number . "</span>"); // "Page n of x" statement // build the navigation tool $navigation_tool = build_navigation_tool($table_name, $where_clause_to_pass, $pages_number, $page, $action, $order, $order_type); // display the navigation tool echo " " . $navigation_tool . "<br><br>"; } // end if ($results_number > $records_per_page) $change_table_form = build_change_table_form(); $records_per_page_form = build_records_per_page_form($dadabik_main_file, $records_per_page, $table_name); if ($change_table_form != "") { // if there is more than one table to manage txt_out('<table><tr><td>' . $change_table_form . '</td><td>' . $records_per_page_form . '</td></tr></table>'); } else { txt_out($records_per_page_form); } // end else $results_type = "search"; // build the HTML results table $results_table = build_results_table($fields_labels_ar, $table_name, $res_records, $results_type, $action, $where_clause_to_pass, $page, $order, $order_type); echo $results_table; if ($export_to_csv_feature == 1) { echo "<a href='" . $action . "?table_name=" . urlencode($table_name) . "&function=" . $function . "&where_clause=" . urlencode($where_clause_to_pass) . "&page=" . $page . "&order=" . urlencode($order) . "&order_type=" . $order_type . "&export_to_csv=1'>"; txt_out($normal_messages_ar["export_to_csv"], "export_to_csv"); echo "</a>";
$_SESSION['where_clause_archive__' . $table_name] = $where_clause; } $sql = "SELECT COUNT(*) FROM archive__{$table_name}"; if ($where_clause != "") { $sql .= " WHERE {$where_clause}"; } // end if $res_records_without_limit = $db->send_query($sql); while ($count_row = $db->db_fetch_row($res_records_without_limit)) { $results_number = $count_row[0]; // get the number of results } // end while $db->free_result($res_records_without_limit); $change_table_form = build_change_table_form_archiv($table_infos_ar, $table_name); $records_per_page_form = build_records_per_page_form($action, $records_per_page, $table_name); if ($results_number > 0) { // at least one record found $pages_number = get_pages_number($results_number, $records_per_page); // get the total number of pages $sql = build_select_part($fields_labels_ar, "archive__" . $table_name); if ($where_clause != "") { $sql .= " WHERE {$where_clause}"; } // end if if (!isset($order)) { // get the first field present in the results form as order $count_temp = 0; $fields_labels_ar_count = count($fields_labels_ar); while (!isset($order) && $count_temp < $fields_labels_ar_count) { if ($fields_labels_ar[$count_temp]["present_results_search_field"] === '1') {