Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1

Thread: Pagination

  1. #1
    Regular Coder
    Join Date
    Jun 2008
    Posts
    682
    Thanks
    114
    Thanked 2 Times in 2 Posts

    Pagination

    Lets say I have 4 templates stored in my database. If I assign the display variable any number above the amount of templates in the database it will properly display that correct number where it says "You have <?php if($rows == 0){echo '0';}else{echo $rows;} ?> templates." however with my pagination if say to test it, I put 2 for the display variable, which means it would have 2 pages with 2 templates displayed on each page. The issue is when I do that it then displays how many the "You have how many templates like above it puts the amount of the display variable and not sure why.

    PHP Code:
    <?php
        
    // Include the database page
        
    include ('../inc/dbconfig.php');
        
        
    // Number of records to show per page
        
    $display 10;
        
        if (isset(
    $_GET['p']) && is_numeric($_GET['p'])) {
            
    $pages $_GET['p'];
        } else { 
    // Need to determine
            
            // Count the number of records
            
    $q "SELECT COUNT(id) FROM templates";
            
    $r mysqli_query($dbc$q);
            
    $row mysqli_fetch_array($rMYSQLI_NUM);
            
    $records $row[0];
            
            
    // Calculate the number of pages...
            
    if ($records $display) { // More than 1 page.
                
    $pages ceil($records/$display);
            } else {
                
    $pages 1;
            }
        } 
    // End of p IF.
        
        // Determine where in the database to start returning results...
        
    if (isset($_GET['s']) && is_numeric($_GET['s'])) {
            
    $start $_GET['s'];
        } else {
            
    $start 0;
        } 
    // End of s IF.
        
        
    $query "SELECT CONCAT_WS(' ', firstname, lastname) AS name, DATE_FORMAT(templates.datecreated, '%M %d, %Y') AS datecreated, templatename FROM templates, handlers WHERE handlers.id = templates.creator_id LIMIT $start, $display";
        
    $result mysqli_query $dbc$query ); // Run The Query
        
    $rows mysqli_num_rows($result);

    ?>
    <!-- Title -->
                <div id="title" class="b2">
                    <h2>Templates</h2>
                    <!-- TitleActions -->
                    <div id="titleActions">
                        <!-- ListSearch -->
                        <div class="listSearch actionBlock">
                            <div class="search">
                                <label for="search">Recherche</label>
                                <input type="text" name="search" id="search" class="text" />
                            </div>
                            <div class="submit">
                                <button type="submit" id="search-button" class="button"><strong><img src="img/icons/search_48.png" alt="comments" class="icon "/></strong></button>
                            </div>
                        </div>
                        <!-- /ListSearch -->
                        <!-- newPost -->
                            <div class="newPost actionBlock">
                                <a href="#" class="button"><strong>New post<img src="img/icons/add_48.png" alt="new post" class="icon "/></strong></a>
                            </div>
                        <!-- /newPost -->
                    </div>
                    <!-- /TitleActions -->
                </div>
                <!-- Title -->

                <!-- Inner Content -->
                <div id="innerContent">

                    <!-- ListHeader -->
                    <div id="listHeader">
                        <p class="listInfos">
                            You have <?php if($rows == 0){echo '0';}else{echo $rows;} ?> templates.
                        </p>
                        <div class="listActions">
                            <form action="" method="post">
                                <label for="actionSelect">With selected items: </label>
                                <select class="select" name="actionSelect" id="actionSelect">
                                    <option>Edit</option>
                                    <option>Delete</option>
                                </select>
                                <button class="button small-button"><strong>Apply</strong></button>
                            </form>
                        </div>
                    </div>
                    <!-- /ListHeader -->
                    <?php
                        
    if ($rows 0) {
                    
    ?>
                    <!-- ListTable -->
                    <table cellspacing="0" class="listTable" id="postList">
                        <!-- Thead -->
                        <thead>
                            <tr>
                                <th class="first"><div></div></th>
                                <th><a href="#" title="Template Name">Template Name</a></th>
                                <th><a href="#" title="Creator">Creator</a></th>
                                <th class="last"><a href="#" title="Date Created">Date Created</a></th>
                            </tr>
                        </thead>
                        <!-- /Thead -->
                        <!-- Tfoot -->
                        <tfoot>
                            <tr>
                                <td colspan="5">
                                    <div class="inner">
                                        <div class="paginate">
                                            <?php 
                                            
                                                
    if ($pages 1) {
                                                    
                                                    
    // Determine what page the script is on:
                                                    
    $current_page = ($start/$display) + 1;
                                                    
                                                    
    // If its not the first page, make a Previous button
                                                    
    if ($current_page != 1) {
                                                        echo 
    '<span class="prev disabled"><a href="templates.php?s=' . ($start $display) . '$p=' $pages '">&lt;&lt;</a></span>';
                                                    } 
                                                    
                                                    
    // Make all the numbered pages:
                                                    
    for ($i 1$i <= $pages$i++) {
                                                        if (
    $i != $current_page) {
                                                            echo 
    '<span class="current roundedBordersLite"><a href="templates.php?s=' . (($display * ($i 1))). '$p=' $pages '">' $i '</a></span>';
                                                        } else {
                                                            echo 
    $i ' ';
                                                        }
                                                    } 
    // End of FOR Loop.
                                                    
                                                    // If its not the last page, make a Next button:
                                                    
    if ($current_page != $pages) {
                                                        echo 
    '<span class="next"><a href="#">&gt;&gt;</a></span>';
                                                    }
                                                } 
    // End of links pages.
                                            
                                            
    ?>
                                        </div>
                                    </div>
                                </td>
                            </tr>
                        </tfoot>
                        <!-- /Tfoot -->
                        <!-- Tbody -->
                        
                        <tbody>
                        <?php 
                            
    while ( $row mysqli_fetch_array $resultMYSQL_ASSOC ) ) {
                              echo 
    '
                              <tr>
                              <td><input type=checkbox class=checkbox /></td>
                              <td>' 
    $row['templatename'] . '</td>
                              <td>' 
    $row['name'] . '</td>
                              <td class=last>' 
    $row['datecreated'] . '</td>
                              </tr>'
    ;
                            }
                        
    ?>
                        </tbody>
                        <!-- /Tbody -->
                    </table>
                        <?php
                            
    }
                        
    ?>
                    <!-- /ListTable -->

                </div>
                <!-- /Inner Content -->
    Last edited by CoolAsCarlito; 11-24-2010 at 04:35 AM.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •