function pagination($per_page, $case, $cat = 0)
{
// case 1 for subjects
// case 2 for pages
// case 3 for products
// case 4 for users
if ($per_page == 0) {
$per_page = 5;
}
$subject_index = '';
$subj = isset($_GET['pg']) ? (int) $_GET['pg'] : 1;
$start = ($subj - 1) * $per_page;
// this will return $query !
switch ($case) {
case "subjects":
$subject_set = get_subjects_for_admin(true);
$query = mysql_query("SELECT * FROM page_subjects ORDER BY id DESC LIMIT {$start},{$per_page}");
break;
case "users":
$subject_set = get_users_for_admin(true);
$query = mysql_query("SELECT * FROM users ORDER BY id DESC LIMIT {$start},{$per_page}");
break;
case "orders":
$subject_set = get_orders_for_admin(true);
$query = mysql_query("SELECT * FROM orders ORDER BY id DESC LIMIT {$start},{$per_page}");
break;
case "pages":
$subject_set = get_pages_for_admin(true);
$query = mysql_query("SELECT * FROM page_data ORDER BY id DESC LIMIT {$start},{$per_page}");
break;
case "products":
$subject_set = get_products_for_admin(true);
$query = mysql_query("SELECT * FROM products ORDER BY id DESC LIMIT {$start},{$per_page}");
break;
case "cat_products":
$subject_set = get_products_for_cat($cat);
$query = mysql_query("SELECT * FROM products WHERE subject_id = {$cat} ORDER BY id DESC LIMIT {$start},{$per_page}");
break;
default:
echo "No case selected for pagination !";
break;
}
$subject_total = ceil(mysql_result($subject_set, 0) / $per_page);
$category_link = '';
if ($cat > 0) {
$category_link = 'subject=' . $cat . '&';
}
// return pagination !
if ($subject_total >= 2 && $subj <= $subject_total) {
$subject_index .= '<ul class="pagination pagination-sm">';
if (isset($_GET['pg']) && $_GET['pg'] > 1) {
$subject_index .= '<li><a href="?' . $category_link . 'pg=' . ($_GET['pg'] - 1) . '">«</a></li>';
} else {
$subject_index .= '<li class="disabled"><a href="#">«</a></li>';
}
for ($x = 1; $x <= $subject_total; $x++) {
$subject_index .= $x == $subj ? '<li class="active"><a href="?' . $category_link . 'pg=' . $x . '">' . $x . '</a></li> ' : '<li><a href="?' . $category_link . 'pg=' . $x . '">' . $x . '</a></li> ';
}
if (isset($_GET['pg']) && $_GET['pg'] < $subject_total) {
$subject_index .= '<li><a href="?' . $category_link . 'pg=' . ($_GET['pg'] + 1) . '">»</a></li>';
} else {
$subject_index .= '<li class="disabled"><a href="#">»</a></li>';
}
$subject_index .= '</ul>';
}
$value = array('query' => $query, 'index' => $subject_index);
return $value;
}
while ($subject_id = mysql_fetch_array($subject_set)) {
echo "<option value=\"{$subject_id['id']}\"";
if ($sel_page['subject_id'] == $subject_id['id']) {
echo " selected=\"selected\"";
}
echo ">{$subject_id['name']}</option>";
}
?>
</select>
</div>
<label for="page_position" class="col-sm-2 control-label">Page Position</label>
<div class="col-sm-3">
<select class="form-control" name="page_position" id="page_position">
<?php
$page_set = get_pages_for_admin();
$page_count = mysql_num_rows($page_set);
// $subject_count + 1 b/c we are adding a subject
echo "<option></option>";
for ($count = 1; $count <= $page_count + 1; $count++) {
echo "<option value=\"{$count}\"";
if ($sel_page['position'] == $count) {
echo " selected=\"selected\"";
}
echo ">{$count}</option>";
}
?>
</select>
</div>
</div>
