0){ $pg=ceil($count_row/$_REQUEST["offset"]); } ?> - Page number-
Home >> News             
$tot) { $tot=$tot+1; } $orderby = ((isset($_GET['orderby']))?$_GET['orderby']:' news_dateadded desc'); //Add Limit and Order by $sql_news.=" order by datab DESC limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; $ress_gb_list=mysql_query($sql_news);*/ $comanda="select * FROM tbl_news WHERE news_status='1' order by datab DESC"; $rezultat = mysql_query($comanda) or die(mysql_error()); $nr=mysql_num_rows($rezultat); $total_pages = $nr; $adjacents =10; /* Setup vars for query. */ $targetpage = "news.php"; //your file name (the name of this file) $limit = 20; if (isset($_GET['page']) && !empty($_GET['page'])) { $page = $_GET['page']; } else { $page=''; } //how many items to show per page if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; $comanda.=" LIMIT $start, $limit"; $rezultat = mysql_query($comanda) or die(mysql_error()); $nr=mysql_num_rows($rezultat); /* 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 /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($lastpage > 1) { $pagination .= "
"; //previous button if ($page > 1) $pagination.= "<< Previous "; else $pagination.= " << Previous "; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= " $counter | "; else $pagination.= " $counter | "; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= " $counter | "; else $pagination.= " $counter | "; } $pagination.= "..."; $pagination.= " $lpm1 | "; $pagination.= " $lastpage | "; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= " 1 | "; $pagination.= " 2 | "; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= " $counter | "; else $pagination.= " $counter | "; } $pagination.= "..."; $pagination.= " $lpm1 | "; $pagination.= " $lastpage | "; } //close to end; only hide early pages else { $pagination.= " 1 | "; $pagination.= " 2 | "; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= " $counter | "; else $pagination.= " $counter | "; } } } //next button if ($page < $counter - 1) $pagination.= " Next >> "; else $pagination.= " Next >> "; $pagination.= "
\n"; } //pagination system while($row=mysql_fetch_assoc($rezultat)) { ?>
Posted by : Administrator
...read more

 
UK Visas & Immigration Services | ICS Legal

LINKS

FOLLOW US

© 2006 - 2017 Copyrights ICS LEGAL IMMIGRATION SPECIALISTS LTD | All rights reserved | UK immigration advice | Marriage Visa | British Citizenship | Tier 1 HSMP | www.icslegal.com