Advanced with Pagination PHP?
<p>This is my PHP code:
Basically I'm looking to use a text form to list results from the Database while using Pagination at the same time. So far the script only works for page one and I am unsure of what to do.</p>

<p>Any tips or advice is much appreciated</p>

<pre><code>&lt;?php

    $tbl_name="pixs";       //your table name
    // How many adjacent pages should be shown on each side?
    $adjacents = 3;

    /* 
       First get total number of rows in data table. 
       If you have a WHERE clause in your query, make sure you mirror it here.
    */
    $query = mysqli_query($con,"SELECT * FROM pixs");
        $total_pages = $query-&gt;num_rows;
    echo "&lt;h2&gt; We have " .$total_pages ." Books for Sale &lt;/h2&gt;" ;

    /* Setup vars for query. */

    $targetpage = "index.php";  //your file name  (the name of this file)
    $limit = 10;                                //how many                   items to show per page
         $_GET['page'] = mysqli_real_escape_string($con, $_GET['page']);
     if(isset($_GET['page']) &amp;&amp; !empty($_GET['page'])){
         $page = $_GET['page'];} else {
             $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. */


   $_GET['search'] = mysqli_real_escape_string($con, $_GET['search']);
        if(isset($_GET['search']) &amp;&amp; !empty($_GET['search'])){
    $keyword = $_GET['search'];
    $result = mysqli_query($con, "SELECT * FROM pixs WHERE title LIKE '%$keyword%' ORDER by date DESC LIMIT $start, $limit");
} else{
    $keyword ="";
    $result = mysqli_query($con, "SELECT * FROM pixs ORDER by date DESC LIMIT $start, $limit");
}

{}


    /* 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 &gt; 1)
    {   
        $pagination .= "&lt;div class=\"pagination\"&gt;";
        //previous button
        if ($page &gt; 1)
                    if(!$keyword == null){
            $pagination.= "&lt;a href=\"$targetpage?page=$prev&amp;search=$keyword\"&gt; &lt;br /&gt;  &lt;br /&gt;  &lt;br /&gt;Previous&lt;/a&gt;";
                    }
                    else {
                       $pagination.= "&lt;a href=\"$targetpage?page=$prev\"&gt; &lt;br /&gt;  &lt;br /&gt;  &lt;br /&gt;Previous&lt;/a&gt;"; 
                    }
                        else {
            $pagination.= "&lt;span class=\"disabled\"&gt;&lt;br /&gt;  &lt;br /&gt;  &lt;br /&gt;Previous&lt;/span&gt;"; 
                        }
        //pages 
        if ($lastpage &lt; 7 + ($adjacents * 2))   //not enough pages to bother breaking it up
        {   
            for ($counter = 1; $counter &lt;= $lastpage; $counter++)
            {
                if ($counter == $page){
                    $pagination.= "&lt;span class=\"current\"&gt;&lt;/span&gt;";

                                    if($keyword){
                    $pagination.= "&lt;a href=\"$targetpage?page=$counter&amp;search=$keyword\"&gt;&lt;/a&gt;";                 
                                    }
                                    else {
                                        $pagination.= "&lt;a href =\"$targetpage?page=$counter\"&gt;&lt;/a&gt;";
                                    }

                        }}
        }
        elseif($lastpage &gt; 5 + ($adjacents * 2))    //enough pages to hide some
        {
            //close to beginning; only hide later pages
            if($page &lt; 1 + ($adjacents * 2))        
            {
                for ($counter = 1; $counter &lt; 4 + ($adjacents * 2); $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "&lt;span class=\"current\"&gt;&lt;/span&gt;";

                                            if($keyword){
                        $pagination.= "&lt;a href=\"$targetpage?page=$counter&amp;search=$keyword\"&gt;&lt;/a&gt;";                 
                                            }
                                            else {
                                              $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;&lt;/a&gt;";  
                                            }    
                                            }
                $pagination.= "...";
                $pagination.= "&lt;a href=\"$targetpage? page=$lpm1\"&gt;$lpm1&lt;/a&gt;";
                $pagination.= "&lt;a href=\"$targetpage?page=$lastpage\"&gt;$lastpage&lt;/a&gt;";       
                        }}
            //in middle; hide some front and some back
            elseif($lastpage - ($adjacents * 2) &gt; $page &amp;&amp; $page &gt; ($adjacents * 2))
            {
                $pagination.= "&lt;a href=\"$targetpage?page=1\"&gt;1&lt;/a&gt;";
                $pagination.= "&lt;a href=\"$targetpage?page=2\"&gt;2&lt;/a&gt;";
                $pagination.= "...";
                for ($counter = $page - $adjacents; $counter &lt;= $page + $adjacents; $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "&lt;span class=\"current\"&gt;&lt;/span&gt;";
                    else
                        $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;&lt;/a&gt;";                 
                }
                $pagination.= "...";
                $pagination.= "&lt;a href=\"$targetpage?page=$lpm1\"&gt;$lpm1&lt;/a&gt;";
                $pagination.= "&lt;a href=\"$targetpage?page=$lastpage\"&gt;$lastpage&lt;/a&gt;";       
            }
            //close to end; only hide early pages
            else
            {
                $pagination.= "&lt;a href=\"$targetpage?page=1\"&gt;&lt;/a&gt;";
                $pagination.= "&lt;a href=\"$targetpage?page=2\"&gt;&lt;/a&gt;";
                $pagination.= "...";
                for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter &lt;= $lastpage; $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "&lt;span class=\"current\"&gt;&lt;/span&gt;";

                                            if ($keyword)
                                            {
                        $pagination.= "&lt;a href=\"$targetpage?page=$counter&amp;search=$keyword\"&gt;&lt;/a&gt;";                 
                }
                                else{
                                   $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;&lt;/a&gt;"; 
            }
        }

        //next button
        if ($page &lt; $counter - 1) 
                    if ($keyword){
            $pagination.= "&amp;nbsp;&amp;nbsp;&amp;nbsp&lt;a href=\"$targetpage?page=$next&amp;search=$keyword\"&gt;Next&lt;/a&gt;";
                    }
                    else {
                      $pagination.= "&amp;nbsp;&amp;nbsp;&amp;nbsp&lt;a href=\"$targetpage?page=$next\"&gt;Next&lt;/a&gt;";  
                    }
                        else
            $pagination.= "&amp;nbsp;&amp;nbsp;&amp;nbsp&lt;span class=\"disabled\"&gt;Next&lt;/span&gt;";
        $pagination.= "&lt;/div&gt;\n";       
    }
        } 
        ?&gt;
</code></pre>

<p>I'm looking to make fix this so I can use a search term along side pagination.</p>

<p>It works fine for one page but the second or third page links are never generated...</p>

<p>I'm not looking for a revision, but if something looks off to me let me know</p>
