PHP Pagination Code Example

<?php
error_reporting(E_ALL ^ E_DEPRECATED);
$con=mysql_connect("localhost","root",'');
mysql_select_db('test');
$page=5;
 ?>
<div class="content-wrapper"><?php 
 $url="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
   ?>
      <?php
$tableName="student";

$limit = 4;

$targetpage = "index.php";
$query = "SELECT COUNT(*) as num FROM $tableName";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];

$stages = 3;
@$page = mysql_escape_string($_GET['page']);
if($page){
$start = ($page - 1) * $limit;
}else{
$start = 0;
}
    $sql_blog = mysql_query("SELECT * FROM $tableName order by id desc LIMIT $start, $limit");

while($row_blog = mysql_fetch_array($sql_blog)){
                       ?>
                   
               <div class="blog-item">
                                     
                <div class="blog-content">
 
                    <ul class="blog-meta">
                        <li>by <a href="#"><?php echo $aid=$row_blog['name'];
?></a></li>
                <?php echo $row_blog['name'];?> Views</li>
             </ul>
           
       
            </div>
        <?php } ?>
     
       
        <div class="review-pager pager-wrappper mt-40">
                   
            <div class="row">
           
                <div class="col-xs-12 col-sm-12">
                    <?php
  if ($page == 0){$page = 1;}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage - 1;

$paginate = '';
if($lastpage > 1)
{

$paginate .= "<ul class='pagination'>";
// Previous
if ($page > 1){
$paginate.= "<li><a href='$targetpage?page=$prev'>previous</a></li>";
}else{
$paginate.= "<span class='disabled'>previous</span>"; }

// Pages
if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<li><a href='$targetpage?page=$counter'>$counter</a></li>";}
}
}
elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?
{
// Beginning only hide later pages
if($page < 1 + ($stages * 2))
{
for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'> Current Page: $counter</span>";
}else{
$paginate.= "<li><a href='$targetpage?page=$counter'>$counter</a></li>";}
}
$paginate.= "...";
$paginate.= "<li><a href='$targetpage?page=$LastPagem1'>$LastPagem1</a></li>";
$paginate.= "<li><a href='$targetpage?page=$lastpage'>$lastpage</a></li>";
}
// Middle hide some front and some back
elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
{
$paginate.= "<li><a href='$targetpage?page=1'>1</a></li>";
$paginate.= "<li><a href='$targetpage?page=2'>2</a></li>";
$paginate.= "...";
for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<li><a href='$targetpage?page=$counter'>$counter</a></li>";}
}
$paginate.= "...";
$paginate.= "<li><a href='$targetpage?page=$LastPagem1'>$LastPagem1</a></li>";
$paginate.= "<li><a href='$targetpage?page=$lastpage'>$lastpage</a></li>";
}
// End only hide early pages
else
{
$paginate.= "<li><a href='$targetpage?page=1'>1</a></li>";
$paginate.= "<li><a href='$targetpage?page=2'>2</a></li>";
$paginate.= "...";
for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<li><a href='$targetpage?page=$counter'>$counter</a></li>";}
}
}
}

// Next
if ($page < $counter - 1){
$paginate.= "<li><a href='$targetpage?page=$next'>next</a></li>";
}else{
$paginate.= "<span class='disabled'>next</span>";
}

$paginate.= "</ul>";

}
echo $total_pages.' Results';
// pagination
echo $paginate;
                ?>

                   
                   
                </div>
   
            </div>
       
        </div>
   
    </div>