1,105,328 Community Members

pagination not displaying in PHP PDO

Member Avatar
Indians
Junior Poster in Training
71 posts since Sep 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Recently i've rewritten my code to PDO from mysql query. Insert, fetch, update, delete everything working fine. But, pagination not displaying in my page. Before i've used mysql query. In that time pagination worked perfectly. Now, i've changed my codes into prepared statements. pagination not dispalying i don't know what should i do? Below i've posted my coding (pagination only)...

<?php
    include('config.php');
    include('paginate.php');
    $per_page = 10;

        try
        {
            //some codes
        }
        catch(PDOException $e)
        {
            //some codes
        }

    $total_results = $stmt->fetchColumn();
    $total_pages = ceil($total_results / $per_page);

    if (isset($_GET['page'])) {
        $show_page = $_GET['page'];
        if ($show_page > 0 && $show_page <= $total_pages) {
            $start = ($show_page - 1) * $per_page;
            $end = $start + $per_page;
        } 
        else {
            $start = 0;              
            $end = $per_page;
        }
    } else {

        $start = 0;
        $end = $per_page;
    }
    $page = intval($_GET['page']);

    $tpages=$total_pages;
    if ($page <= 0)
        $page = 1;
    ?>
    <html>
    <head>
    <title></title>
    </head>

    <body>
    <table width="1200" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
    <tr>
      <td height="8" colspan="6" >&nbsp;</td>
    </tr>
    <tr>
    <td colspan="6">
         &nbsp;
    </td>
    </tr>
    <tr>
      <td colspan="5">&nbsp;</td>
    </tr>
      <tr>
        <td height="35" colspan="12" align="center" valign="middle">
            <div class="headdiv"> LISTS </div>
        </td>
    </tr>
    <tr>
        <td>
            <?php
                try
                {           
                                //some codes
                }
                catch(PDOException $e)
                {
                                //some codes
                }
                $reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages;
                echo '<div style="margin-left:60px;" class="pagination"><ul>';
                if ($total_pages > 1) {
                    echo paginate($reload, $show_page, $total_pages);
                }
                echo "</ul></div>"; 
            ?>
        </td>
       <td>
        <table align="center" width="310" height="40" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="270" align="right" style="background: rgba(200,200,200, .2); padding:2px 10px 2px 0px; border-top-left-radius: 5px; border-bottom-left-radius: 5px;">
                <?php
                                //some codes
                ?>
            </td>
            <td width="40" style="background: rgba(200,200,200, .2); padding:2px 0px 2px 0px; border-top-right-radius: 5px; border-bottom-right-radius: 5px;">
                <?php
                                //some codes
                ?>
            </td>
          </tr>
        </table>
        </td>
    </tr>
      <tr>
        <td colspan="12">
        <?php                       
        echo "
           //some codes
        ";
        for($i = $start; $i < $end; $i++) 
        {
            if ($i == $total_results) 
            {
                break;
            }   
        while($row = $stmt->fetch())
          {
                        //some codes
          }
        }
        echo "</table>";
        ?>
        </td>
      </tr>
     <tr>
        <td colspan="2">
            <?php
                $reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages;
                echo '<div style="margin-left:60px;" class="pagination"><ul>';
                if ($total_pages > 1) {
                    echo paginate($reload, $show_page, $total_pages);
                }
                echo "</ul></div>";
            ?>
        </td>
    </tr>
    </table>
    </body>
    </html>
Member Avatar
bops
Posting Whiz
301 posts since Aug 2005
Reputation Points: 1 [?]
Q&As Helped to Solve: 17 [?]
Skill Endorsements: 0 [?]
 
0
 

It might be worth posting your database queries etc, since that seems to be what is causing the problem.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: