phpmo Posted August 1, 2007 Share Posted August 1, 2007 I have a working page number script but the only problem is that when I get some many fields to display the pages go way off the screen and it gets messy. Anyone have any good ideas to edit this script to maybe only display 10 pages at a time but go up as you go up in pages? I've found a solution in a drop down box but some don't like it. Here is the code I have. // If current page number, use it // if not, set one! if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } // Define the number of results per page $max_results = 50; // Figure out the limit for the query based // on the current page number. $from = (($page * $max_results) - $max_results); // Figure out the total number of results in DB: $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM table"),0); // Figure out the total number of pages. Always round up using ceil() $total_pages = ceil($total_results / $max_results); // Build Page Number Hyperlinks echo "<center><font style=\"color: orange;\">Select a Page</font><br />"; // Build Previous Link if($page > 1){ $prev = ($page - 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\">Previous</a> "; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; } } // Build Next Link if($page < $total_pages){ $next = ($page + 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next</a>"; } Quote Link to comment https://forums.phpfreaks.com/topic/62856-page-number-creation/ Share on other sites More sharing options...
soycharliente Posted August 1, 2007 Share Posted August 1, 2007 This might help. It limits the number of pages to show on each side of the current page. http://www.htmlforums.com/php-programming/t-useful-pagination-class-php5-71987.html Quote Link to comment https://forums.phpfreaks.com/topic/62856-page-number-creation/#findComment-312963 Share on other sites More sharing options...
phpmo Posted August 1, 2007 Author Share Posted August 1, 2007 Thx for the link. I'll see what I can get from it. I'd like to keep using the same code if possible since I've got it installed all over my site. Quote Link to comment https://forums.phpfreaks.com/topic/62856-page-number-creation/#findComment-313066 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.