PHP - Moving Page Numbers Pagination

Hello everyone, i am working on a page that displays news topic and would like to have the page numbers at the bottom of the page as links. You know the usual prev (link) then list couple of pages and then next (link).

prev - 1 2 3 4 5... next

below is the code i have to count my records on my db and display them. but the problem with this is that it displays all of them. page 1 through 50.

Code: [Select]
$query2 = "SELECT COUNT(title) FROM news";
$result2 = mysql_query($query2);
$row = mysql_fetch_row($result2);
$total_records=$row[0];
$total_pages = ceil($total_records / 5);


for ($i=1; $i<=$total_pages; $i++)
{
if ($i!=1 and $i !=10) { print "<a href='newsevents.php?page={$i}'> " .$i. " </a>"; }
if ($i==$total_pages)
{
print"<p><a href='newsevents.php?page={$i}'> Last Page </a>";
}
if ($i==1)
{
print "<p class='floatleft'><a href='newsevents.php?page={$i}'> First Page </a>";
}


}



Can someone help?

Hi, I have pagination system with FIRST LETTER separated and everything is OK.

$page = (int)(!isset($_GET["page"]) ? 1 : $_GET["page"]);
if ($page <= 0) $page = 1;
 
$per_page = 5; 
 
$startpoint = ($page * $per_page) - $per_page;
 
$statement = "restaurants ORDER BY `name`"; 

// make foo the current db '" . addslashes($_GET['id']) . "'


$result = mysqli_query($mysqli,"SELECT name FROM restaurants WHERE cuisine_ID_obsolete=5 ORDER BY name LIMIT {$startpoint} , {$per_page}");

if (mysqli_num_rows($result) == 0) {
     
    echo "No records are found.";
 
} else {
     $lastFoundLetter = '';
    // displaying records.
    while ($row = mysqli_fetch_array($result)) {
      
      
      
      $firstLetter = substr($row['name'], 0, 1);
    if ($firstLetter != $lastFoundLetter) {
      
        if ($lastFoundLetter != '') {
          
            echo "</br>";
        }

echo strtoupper($firstLetter) . "<br/>"; 



        $lastFoundLetter = $firstLetter;
    }



echo $row['name'] . "<br/>"; 

  }
      }


echo pagination($statement,$per_page,$page);
?>

Function for pagination:

<?php

function pagination($query,$per_page=10,$page=1,$url='?'){  
    global $mysqli;
    $query = "SELECT COUNT(*) as `num` FROM restaurants  WHERE cuisine_id_OBSOLETE = '12'";
    $row = mysqli_fetch_array(mysqli_query($mysqli,$query));
    $total = $row['num'];
    $adjacents = "1";
     
    $prevlabel = "<img src='files/prev.png'>";
    $nextlabel = "<img src='files/next.png'>";
     
    $page = ($page == 0 ? 1 : $page); 
    $start = ($page - 1) * $per_page;                              
     
    $prev = $page - 1;                         
    $next = $page + 1;
     
    $lastpage = ceil($total/$per_page);
     
    $lpm1 = $lastpage - 1; // //last page minus 1
     
    $pagination = "";
    if($lastpage > 1){  
        $pagination .= "<ul class='pagination'>";
       
             
            if ($page > 1) $pagination.= "<li><a href='{$url}page={$prev}'>{$prevlabel}</a></li>";
             
        if ($lastpage < 7 + ($adjacents * 2)){  
            for ($counter = 1; $counter <= $lastpage; $counter++){
                if ($counter == $page)
                    $pagination.= "<li><a class='current'>{$counter}</a></li>";
                else
                    $pagination.= "<li><a href='{$url}page={$counter}'>{$counter}</a></li>";                   
            }
         
        } elseif($lastpage > 1 + ($adjacents * 2)){
             
            if($page < 1 + ($adjacents * 2)) {
                 
                for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++){
                    if ($counter == $page)
                        $pagination.= "<li><a class='current'>{$counter}</a></li>";
                    else
                        $pagination.= "<li><a href='{$url}page={$counter}'>{$counter}</a></li>";                   
                }
                $pagination.= "<li class='dot'>...</li>";
                $pagination.= "<li><a href='{$url}page={$lpm1}'>{$lpm1}</a></li>";
                $pagination.= "<li><a href='{$url}page={$lastpage}'>{$lastpage}</a></li>"; 
                     
            } elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) {
                 
                $pagination.= "<li><a href='{$url}page=1'>1</a></li>";
                $pagination.= "<li><a href='{$url}page=2'>2</a></li>";
                $pagination.= "<li class='dot'>...</li>";
                for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) {
                    if ($counter == $page)
                        $pagination.= "<li><a class='current'>{$counter}</a></li>";
                    else
                        $pagination.= "<li><a href='{$url}page={$counter}'>{$counter}</a></li>";                   
                }
                $pagination.= "<li class='dot'>..</li>";
                $pagination.= "<li><a href='{$url}page={$lpm1}'>{$lpm1}</a></li>";
                $pagination.= "<li><a href='{$url}page={$lastpage}'>{$lastpage}</a></li>";     
                 
            } else {
                 
                $pagination.= "<li><a href='{$url}page=1'>1</a></li>";
                $pagination.= "<li><a href='{$url}page=2'>2</a></li>";
                $pagination.= "<li class='dot'>..</li>";
                for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) {
                    if ($counter == $page)
                        $pagination.= "<li><a class='current'>{$counter}</a></li>";
                    else
                        $pagination.= "<li><a href='{$url}page={$counter}'>{$counter}</a></li>";                   
                }
            }
        }
         
            if ($page < $counter - 1) $pagination.= "<li><a href='{$url}page={$next}'>{$nextlabel}</a></li>";
         
        $pagination.= "</ul>";       
    }
     
    return $pagination;
}


?>

Problem is, since I have FIRST LETTER separated, with $per_page. How to exclude FIRST LETTER and "<br/>" from $per_page variable?  

So, here goes...   On my website, http://jamaica2go.com, I have destinations laid out in thumbnails on the main destination page. The page is using three columns. The page works fine as it is, however, I know that as I add more locations scrolling will become an issue. The author did a great job on this theme and he also gave an option to select maximum number of items to be shown but no paging occurs once you hit that max (weird, right?).   I have tried, I really have. Reading up on the WP codex, hunting down scripts and tutorials, all with a view to adding this simple feature. I know if someone figures this out it's going to be easy as cheese but the drawback for me is that I'm not a PHP programmer, just pretty decent at editing and changing the code.   Anyway, I'm posting the entire page code below (realised at end that I can attach, so did that instead). The important stuff happens in the "uxbarn_custom_port_load_portfolio_shortcode" function and onward. I noticed that although he starts a while loop to write the thumbnails to the page, he doesn't seem to end it. He also has a pagination template for the blog page which I'll add below but I couldn't make heads or tails of it. Hope someone can assist.     PORTFOLIO PAGE ------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------           The template below is used for blog and search and is called with:         <?php get_template_part( 'template-pagination' ); ?>     PAGINATION TEMPLATE ------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------   <?php

    $big = 999999999;
    
    global $wp_query;
    $total_pages = $wp_query->max_num_pages;
    
    if( is_search() ) {
        // Only for search page, there are 10 posts per page
        // And always round up the result
        $total_pages = ceil( $wp_query->found_posts / 10 );
    }
    
    if ( $total_pages > 1 ) {
        
        echo '<div class="row no-margin-bottom">
                <div id="blog-pagination" class="uxb-col large-12 columns pagination-centered">
                    ';
        
        $current_page = max( 1, get_query_var( 'paged' ) );
        echo paginate_links( array(  
          'base'         => str_replace( $big, '%#%', esc_url( get_pagenum_link( $big ) ) ),
          'format'         => '&page=%#%',  
          'current'     => $current_page,  
          'total'         => $total_pages,  
          'prev_text'     => '<i class="icon ion-ios7-arrow-left"></i>',  
          'next_text'     => '<i class="icon ion-ios7-arrow-right"></i>',
          'type'         => 'list'
        ));
        
        echo '</div>
            </div>';
        
    }
    
?> ------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------   Attached Files  custom-uxbarn-portfolio.php   33.24KB   2 downloads  template-pagination.php   1022bytes   0 downloads

Hello-

I have a social network that has a blogs and questions section. There are community pages for each one ( blogs/questions ) On each of those pages. the first ten blogs/questions are displayed. To the right of those are a list of clickable categories that sort the pages according to their category.

I have pagination implemented after each ten. I am doing a mod_rewrite for pretty urls on my dev and have everything working correctly. The problem is, after hitting next the first time 'page=' is blank and just reloads the first (defaulted page) but after a second click it becomes 'page=10' as it should and then the third click 'page=20" as it should.

So basically I am trying to get it to go to 'page=10" after one click, not two. Here is the code for the pagination:

Code: [Select]
<div id="all_page_turn">
                         <ul>

                            <?php if($totalBlogs > 10 && $_GET['page'] >= 10) { ?>
                             <li class="PreviousPageBlog round_10px">
                                 <a href="/blogs/?cat=<?php if(isset($_GET['cat'])) { echo $_GET['cat'];} ?>&sort=<?php if(isset($_GET['sort'])) { echo $_GET['sort'];} ?>&page=<?php if(isset($_GET['page'])) { echo ($_GET['page'] - 10);} ?>">Previous Page</a>
                             </li>
                             <?php } ?>

                               <?php if($totalBlogs > 10 && $_GET['page'] < ($totalBlogs-10)) { ?>
                             <li class="NextPageBlog round_10px">
                                 <a href="/blogs/?cat=<?php if(isset($_GET['cat'])) { echo $_GET['cat'];} ?>&sort=<?php if(isset($_GET['sort'])) { echo $_GET['sort'];} ?>&page=<?php if(isset($_GET['page'])) { echo ($_GET['page'] + 10);} ?>">Next Page</a>
                             </li>
                             <?php } ?>



                         </ul>
        </div>

</div>and here is the defaulted category link:

Code: [Select]
<div id="RightBlogs">
        <div id="search_blogs_future" class="round_10px">
        <form name="searchBlogs" action="/blogs" method="get">
            <input type="text" name="BlogSearch" class="text" value="<?php if(empty($_GET['BlogSearch'])) { echo "Search Blogs"; }else{ echo $_GET['BlogSearch'];} ?>" onclick="clearify(this);" />
             <input type="submit" name="subBlogSearch" value="Search" />
         </form>
     </div>
     <div class='<?php if(empty($_GET['cat']) || $_GET['cat'] == "All") { echo "all_blog_cats_Highlighted"; }else{ echo "all_blog_cats_unHighlighted"; } ?> round_10px'>
         <a href='/blogs/?cat=All'>
                 All
                 </a>
          </div>Here is a screen shot of the page, as I'm on my dev so I can't provide a link. you can't see the "next" button, but it's there on the bottom, and then the categories are on the right.

[attachment deleted by admin]

I've looked at loads of other scripts that highlight the page but none of them work on mine . Here's part of my code:


$i =1; 
for ($x=0;$x<$foundnum;$x=$x+$e)
{

 echo " <a href='search.php?search=$search&s=$x'>$i</a> ";


$i++;