if (!empty($_GET['search'])) { $like = $db->Escape(trim($_GET['search'])); $query_string['search'] = $like; $query .= " AND comments LIKE '%{$like}%'"; $sub_header = "Search Results for: <em>{$like}</em>"; } } // Retrieve total count $query .= " ORDER BY comment_id DESC"; $result_count = $db->Query($query); $total = $db->Count($result_count); // Initialize pagination $url .= !empty($query_string) ? '?' . http_build_query($query_string) : ''; $pagination = new Pagination($url, $total, $records_per_page, false); $start_record = $pagination->GetStartRecord(); $_SESSION['list_page'] = $pagination->GetURL(); // Retrieve limited results $query .= " LIMIT {$start_record}, {$records_per_page}"; $result = $db->Query($query); // Output Header include 'header.php'; ?> <div id="comments"> <h1><?php echo $header; ?> </h1> <?php if ($sub_header) {
if (!empty($_GET['search'])) { $like = $db->Escape(trim($_GET['search'])); $query_string['search'] = $like; $query .= " AND title LIKE '%{$like}%' OR content LIKE '%{$like}%'"; $sub_header = "Search Results for: <em>{$like}</em>"; } } // Retrieve total count $query .= " ORDER BY page_id DESC"; $result_count = $db->Query($query); $total = $db->Count($result_count); // Initialize pagination $url .= !empty($query_string) ? '?' . http_build_query($query_string) : ''; $pagination = new Pagination($url, $total, $records_per_page, false); $start_record = $pagination->GetStartRecord(); $_SESSION['list_page'] = $pagination->GetURL(); // Retrieve limited results $query .= " LIMIT {$start_record}, {$records_per_page}"; $result = $db->Query($query); // Output Header include 'header.php'; ?> <div id="pages"> <h1><?php echo $header; ?> </h1> <?php if ($sub_header) {
if (!empty($_GET['search'])) { $like = $db->Escape(trim($_GET['search'])); $query_string['search'] = $like; $query .= " AND username LIKE '%{$like}%'"; $sub_header = "Search Results for: <em>{$like}</em>"; } } // Retrieve total count $query .= " ORDER BY user_id DESC"; $result_count = $db->Query($query); $total = $db->Count($result_count); // Initialize pagination $url .= !empty($query_string) ? '?' . http_build_query($query_string) : ''; $pagination = new Pagination($url, $total, $records_per_page, false); $start_record = $pagination->GetStartRecord(); $_SESSION['list_page'] = $pagination->GetURL(); // Retrieve limited results $query .= " LIMIT {$start_record}, {$records_per_page}"; $result = $db->Query($query); // Output Header include 'header.php'; ?> <div id="members"> <h1><?php echo $header; ?> </h1> <?php if ($sub_header) {
} else { if (!empty($_GET['search'])) { $like = $db->Escape(trim($_GET['search'])); $query_string['search'] = $like; $query .= " AND username LIKE '%{$like}%'"; $sub_header = "Search Results for: <em>{$like}</em>"; } } // Retrieve total count $result_count = $db->Query($query); $total = $db->Count($result_count); // Initialize pagination $url .= !empty($query_string) ? '?' . http_build_query($query_string) : ''; $pagination = new Pagination($url, $total, $records_per_page, false); $start_record = $pagination->GetStartRecord(); $_SESSION['list_page'] = $pagination->GetURL(); // Retrieve limited results $query .= " LIMIT {$start_record}, {$records_per_page}"; $result = $db->Query($query); // Output Header include 'header.php'; ?> <div id="flags"> <h1><?php echo $header; ?> </h1> <?php
if (!empty($_GET['search'])) { $like = $db->Escape(trim($_GET['search'])); $query_string['search'] = $like; $query .= " AND title LIKE '%{$like}%'"; $sub_header = "Search Results for: <em>{$like}</em>"; } } // Retrieve total count $query .= " ORDER BY video_id DESC"; $result_count = $db->Query($query); $total = $db->Count($result_count); // Initialize pagination $url .= !empty($query_string) ? '?' . http_build_query($query_string) : ''; $pagination = new Pagination($url, $total, $records_per_page, false); $start_record = $pagination->GetStartRecord(); $_SESSION['list_page'] = $pagination->GetURL(); // Retrieve limited results $query .= " LIMIT {$start_record}, {$records_per_page}"; $result = $db->Query($query); // Output Header include 'header.php'; ?> <div id="videos"> <h1><?php echo $header; ?> </h1> <?php if ($sub_header) {