Example #1
0
    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) {
Example #2
0
    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) {
Example #3
0
    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) {
Example #4
0
} 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 
Example #5
0
    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) {