<< Back to PHP

Contents

• Simple PHP pagination script

PHP

Simple PHP pagination script

Simple php script that does pagination

Simple PHP pagination script

This is a simple php script which I used in a custom frame work basen on a old version of cakephp. I thought it might be good to keep as it is so simple but works so well.

In controller

// do a count query on mysql database
// example: SELECT count(*) as Count FROM users WHERE is_active = 1 GROUP BY id
// for example purposes I have simplified the queries, they might be in a model in a php frame work if you use one

        $offset = 0;
        $currentpage = $_GET['page'];
        if(!empty($currentpage)) {
            if($currentpage > 1) {
                $offset = ($currentpage - 1) * 10;
            }
        }

        $pages = $count / 10;
        $pages = ceil($pages);

        if($currentpage > 3) { $startpage = $currentpage - 3; } else {  $startpage = 1; }
        if($currentpage < ($pages - 3)) { $endpage = $currentpage + 2; } else { $endpage = $pages; }

// if you are in a framework like cakephp, laravel etc you want to pass the values to your view
// like so:

        $this->set('startpage', $startpage);
        $this->set('endpage', $endpage);
        $this->set('currentpage', $currentpage);
        $this->set('count', $count);


// query mysql insert '$offset' into the query.
// example: $query = 'SELECT * FROM users WHERE is_active = 1 GROUP BY id ORDER BY id LIMIT '.$offset.',10;

In view

<style>
    .pagination {
        display: inline-block;
        padding-left: 0;
        margin-top: 10px;
        border-radius: 4px;
        margin-bottom: 1px;
    }
    .pagination > li {
        display: inline;
    }
    .pagination > li > a, .pagination > li > span {
        position: relative;
        float: left;
        padding: 6px 12px;
        margin-left: -1px;
        line-height: 1.42857143;
        color: #428bca;
        text-decoration: none;
        background-color: #fff;
        border: 1px solid #ddd;
    }
    .pagination > .active > a {
        z-index: 2;
        color: #fff;
        cursor: default;
        background-color: #00214E;
        border-color: #00214E;
    }
</style>

<div class='pull-left'>
<?php if($count > 10){ ?>
<ul class="pagination">
<li><a href="/cwsinsurance/imagemanager/'">First</a></li>
<?php
    for ($i = $startpage; $i <= $endpage; $i++) {

        echo '<li class=';
        if( $currentpage == $i){ echo ' "active" '; }
        echo '><a href="/cwsinsurance/imagemanager/?page='.$i.'">'.$i.'</a></li>';
    }
?>
<li><a href="/cwsinsurance/imagemanager/?page=<?= $pages ?>">Last</a></li>
</ul>
<?php } ?>
</div>
  <div class='pull-right'>
Total gadgets:  <?= $count ?>
</div>

 

Published: 17th March 2017 by