Pagination in PHP

Pagination in PHP

Step 1:

Create a File with name db.php

and then here is code

<?php
$host="localhost";
$user="root";
$pass="";
$dbase="DatabaseName";
$prefix = "";
$bd = mysql_connect($host, $user, $pass) or die("Opps some thing went wrong");
mysql_select_db($dbase, $bd) or die("Opps some thing went wrong");

?>

Step 2:

Then crate a File with name load_data.php
Here we fetch data from database and control it with the help of queries.

<?php
include("db.php");
if(isset($_POST['page']) && isset($_POST['groupid'])){
$page = $_POST['page'];
$groupid=$_POST['groupid'];
$cur_page = $page;
$page -= 1;
$per_page = 5;
$previous_btn = true;
$next_btn = true;
$first_btn = true;
$last_btn = true;
$start = $page * $per_page;


////////////////////////////////////////////////////////////////
/* --------------------count record in table------------------------- */
$query_pag_num = "SELECT COUNT(*) AS count FROM donnor WHERE donnor.blood_id=$groupid";//JOIN bloodgroup ON donnor.blood_id=bloodgroup.blood_id";
$result_pag_num = mysql_query($query_pag_num);
$row = mysql_fetch_array($result_pag_num);
$count = $row['count'];
$no_of_paginations = ceil($count / $per_page);
  if($count<=0){die("Record Not Found");}

/////////////////////////////////////////////


$query_pag_data = "SELECT d_name,blood_group,d_age,d_gender,d_add,d_contact,d_email FROM donnor JOIN bloodgroup ON donnor.blood_id=bloodgroup.blood_id WHERE bloodgroup.blood_id=$groupid LIMIT $start, $per_page";

$result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());
$msg = "";
echo("<h3>Donor's List</h3>");
echo("<table class='tftable' border='1'>");
echo("<th>Donor Name</th><th>Group</th><th>Age</th><th>Gender</th><th>Address</th><th>Contact</th><th>Email</th>");

while ($row = mysql_fetch_array($result_pag_data)) {
//$htmlmsg=htmlentities($row['d_name']);
    echo("<tr>
<td>$row[0]</td><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td><td height='28'>$row[4]</td><td>$row[5]</td><td>$row[6]</td>
</tr>");

}
echo("</table>");
$msg = "<div class='data'><ul>" . $msg . "</ul></div>"; // Content for Data




/* ---------------Calculating the starting and endign values for the loop----------------------------------- */
if ($cur_page >= 7){
    $start_loop = $cur_page - 3;
    if ($no_of_paginations > $cur_page + 3){
        $end_loop = $cur_page + 3;
}
    else if ($cur_page <= $no_of_paginations && $cur_page > $no_of_paginations - 6) {
        $start_loop = $no_of_paginations - 6;
        $end_loop = $no_of_paginations;
    }

else{
        $end_loop = $no_of_paginations;
    }
}
else {
    $start_loop = 1;
    if ($no_of_paginations > 7){
        $end_loop = 7;
}
    else{
        $end_loop = $no_of_paginations;
}
}
/* ----------------------------------------------------------------------------------------------------------- */
$msg .= "<div class='pagination'><ul>";

// FOR ENABLING THE FIRST BUTTON
if ($first_btn && $cur_page > 1) {
    $msg .= "<li p='1' class='active'>First</li>";
}
else if ($first_btn) {
    $msg .= "<li p='1' class='inactive'>First</li>";
}

// FOR ENABLING THE PREVIOUS BUTTON
if ($previous_btn && $cur_page > 1) {
    $pre = $cur_page - 1;
    $msg .= "<li p='$pre' class='active'>Previous</li>";
}
else if ($previous_btn) {
    $msg .= "<li class='inactive'>Previous</li>";
}
for ($i = $start_loop; $i <= $end_loop; $i++) {

    if ($cur_page == $i){
        $msg .= "<li p='$i' style='color:#fff;background-color:#006699;' class='active'>{$i}</li>";
}//if end
    else{
        $msg .= "<li p='$i' class='active'>{$i}</li>";
}//else end

}//for end

// TO ENABLE THE NEXT BUTTON
if ($next_btn && $cur_page < $no_of_paginations) {
    $nex = $cur_page + 1;
    $msg .= "<li p='$nex' class='active'>Next</li>";
}
else if ($next_btn) {
    $msg .= "<li class='inactive'>Next</li>";
}

// TO ENABLE THE END BUTTON
if ($last_btn && $cur_page < $no_of_paginations) {
    $msg .= "<li p='$no_of_paginations' class='active'>Last</li>";
}
else if ($last_btn) {
    $msg .= "<li p='$no_of_paginations' class='inactive'>Last</li>";
}
$goto = "<input type='text' class='goto' size='1' style='margin-top:-1px;margin-left:60px;'/><input type='button' id='go_btn' class='go_button' value='Go'/>";
$total_string = "<span class='total' a='$no_of_paginations'>Page <b>" . $cur_page . "</b> of <b>$no_of_paginations</b></span>";
$msg = $msg . "</ul>" . $goto . $total_string . "</div>";  // Content for pagination
echo $msg;
}

mysql_close();


/*


*/
?>

Step 3:

Now create a file with name pagination.php
This is a pagination script using Jquery, Ajax and PHP
The enhancements done in this script pagination with first,last, previous, next buttons

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
        <title>Pagination with Jquery, Ajax, PHP</title>
        <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
        <script type="text/javascript">
            $(document).ready(function(){
                function loading_show(){
                    $('#loading').html("<img src='images/loading.gif'/>").fadeIn('fast');
                }
                function loading_hide(){
                    $('#loading').fadeOut('fast');
                }              
                function loadData(page){
                    loading_show();                  
                    $.ajax
                    ({
                        type: "POST",
                        url: "load_data.php",
                        data: "page="+page,
                        success: function(msg)
                        {
                            $("#container").ajaxComplete(function(event, request, settings)
                            {
                                loading_hide();
                                $("#container").html(msg);
                            });
                        }
                    });
                }
                loadData(1);  // For first time page load default results
                $('#container .pagination li.active').live('click',function(){
                    var page = $(this).attr('p');
                    loadData(page);
                 
                });        
                $('#go_btn').live('click',function(){
                    var page = parseInt($('.goto').val());
                    var no_of_pages = parseInt($('.total').attr('a'));
                    if(page != 0 && page <= no_of_pages){
                        loadData(page);
                    }else{
                        alert('Enter a PAGE between 1 and '+no_of_pages);
                        $('.goto').val("").focus();
                        return false;
                    }
                 
                });
            });
        </script>

        <style type="text/css">
         
            #loading{
                width: 100%;
                position: absolute;
                top: 100px;
                left: 100px;
margin-top:200px;
            }
            #container .pagination ul li.inactive,
            #container .pagination ul li.inactive:hover{
                background-color:#ededed;
                color:#bababa;
                border:1px solid #bababa;
                cursor: default;
            }
            #container .data ul li{
                list-style: none;
                font-family: verdana;
                margin: 5px 0 5px 0;
                color: #000;
                font-size: 13px;
            }

            #container .pagination{
                width: 800px;
                height: 25px;
            }
            #container .pagination ul li{
                list-style: none;
                float: left;
                border: 1px solid #006699;
                padding: 2px 6px 2px 6px;
                margin: 0 3px 0 3px;
                font-family: arial;
                font-size: 14px;
                color: #006699;
                font-weight: bold;
                background-color: #f2f2f2;
            }
            #container .pagination ul li:hover{
                color: #fff;
                background-color: #006699;
                cursor: pointer;
            }
.go_button
{
background-color:#f2f2f2;border:1px solid #006699;color:#cc0000;padding:2px 6px 2px 6px;cursor:pointer;position:absolute;margin-top:-1px;
}
.total
{
float:right;font-family:arial;color:#999;
}

        </style>

    </head>
    <body>


        <div id="loading"></div>
        <div id="container">
            <div class="data"></div>
            <div class="pagination"></div>
        </div>

    </body>
</html>