halohalo

<?php $pass = "sort_by=$sort_by&status=$status&q=$q&Submit=Search"; $q = mysql_real_escape_string($_GET['q']); $tbl_name = "product_tbl"; $tbl_id = "product_id"; $adjacents = 1; $limit = 12; if($q != ""){ $cond .= " and (product_id like '%$q%' or group_proid like '%$q%' or model like '%$q%' or product_name like '%$q%' or catalogue_name like '%$q%' or barcode like '%$q%' or stock_avail like '%$q%' or cat_id like '%$q%' or subcat_id like '%$q%' or child_cat_id like '%$q%' or mrp_price like '%$q%' or offer_price like '%$q%' or our_price like '%$q%' or original_price like '%$q%' or deal_price like '%$q%' or property_name like '%$q%' or property_value like '%$q%' or `size` like '%$q%' or `max_size` like '%$q%' or `quantity` like '%$q%' or `brand` like '%$q%' or `type` like '%$q%')"; } if($status == "Active"){ $cond = "and status='$status'"; } if($status == "Disabled") { $cond = "and status='$status'"; } if($sort_by == "LL"){ $scond = "order by id asc"; } else{ $scond = "order by id desc"; } $SQL = "select * from $tbl_name where `id`>'0' $cond $scond"; $query = "SELECT COUNT(DISTINCT $tbl_id) as num FROM $tbl_name where `id`>'0' $cond $scond"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages[num]; /* Setup vars for query. */ if(isset($_GET['limit'])) $limit=$_GET['limit']; $page = $_GET['page']; if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 /* Get data. */ $sql = "select * from $tbl_name where `id`>'0' $cond $scond LIMIT $start, $limit"; // $result = mysql_query($sql); /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 $pagination = ""; if($lastpage > 1) { $pagination .= "<ul class=\"pagination\">"; //previous button if ($page > 1) $pagination.= "<li><a href=\"$targetpage?page=$prev&limit=$limit&$pass&$pass\">&laquo;</a></li>"; else $pagination.= "<li class=\"disabled\"><a href=\"#\">&laquo;</a></li>"; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "<li class=\"active\"><a href=\"#\">$counter</a></li>"; else $pagination.= "<li><a href=\"$targetpage?page=$counter&limit=$limit&$pass\">$counter</a></li>"; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "<li class=\"active\"><a href=\"#\">$counter</a></li>"; else $pagination.= "<li><a href=\"$targetpage?page=$counter&limit=$limit&$pass\">$counter</a></li>"; } $pagination.= "<li><a href=\"#\">...</a></li>"; $pagination.= "<li><a href=\"$targetpage?page=$lpm1&limit=$limit&$pass\">$lpm1</a></li>"; $pagination.= "<li><a href=\"$targetpage?page=$lastpage&limit=$limit&$pass\">$lastpage</a></li>"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "<li><a href=\"$targetpage?page=1&limit=$limit&$pass\">1</a></li>"; $pagination.= "<li><a href=\"$targetpage?page=2&limit=$limit&$pass\">2</a></li>"; //$pagination.= "<li><a href=\"#\">...</a></li>"; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "<li class=\"active\"><a href=\"#\">$counter</a></li>"; else $pagination.= "<li><a href=\"$targetpage?page=$counter&limit=$limit&$pass\">$counter</a></li>"; } $pagination.= "<li><a href=\"#\">...</a></li>"; $pagination.= "<li><a href=\"$targetpage?page=$lpm1&limit=$limit&$pass\">$lpm1</a></li>"; $pagination.= "<li><a href=\"$targetpage?page=$lastpage&limit=$limit&$pass\">$lastpage</a></li>"; } //close to end; only hide early pages else { $pagination.= "<li><a href=\"$targetpage?page=1&limit=$limit&$pass\">1</a></li>"; $pagination.= "<li><a href=\"$targetpage?page=2&limit=$limit&$pass\">2</a></li>"; $pagination.= "<li><a href=\"#\">...</a></li>"; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "<li class=\"active\"><a href=\"#\">$counter</a></li>"; else $pagination.= "<li><a href=\"$targetpage?page=$counter&limit=$limit&$pass\">$counter</a></li>"; } } } //next button if ($page < $counter - 1) $pagination.= "<li><a href=\"$targetpage?page=$next&limit=$limit&$pass\">&raquo;</a></li>"; else $pagination.= "<li class=\"disabled\"><a href=\"#\">&raquo;</a></li>"; $pagination.= "</ul>\n"; } ?>