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') {
