Simple Pagination Code with PHP

Hindi Alerts

10 months ago

Simple Pagination Code with PHP – MySql PDO

Problem:- Simple Pagination Code with PHP – MySql PDO

Solution:-

<?php 

$user = "root";
$pass = "";
$dbname = 'testdb';
$host = "localhost";

$mysql = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
$offset = isset($_GET['offset'])? intval($_GET['offset']) : 1;
$per_page = 5;
$total = $mysql->query('SELECT COUNT(*) FROM data')->fetchColumn(0);

$limitedSQL = "SELECT * FROM data ORDER BY id LIMIT $per_page OFFSET ". ($offset-1);
$lastRowNumber = $offset-1;

foreach ($mysql->query($limitedSQL) as $row2) {
 $lastRowNumber++;
 print "{$row2['name']} ===========> {$row2['mobile']}<br>";
}
indexed_links($total, $offset, $per_page);

print "<br>";
print "(Displaying $offset-$lastRowNumber of Total)";


 //=========function for print text and record=======//
 //=================================================//
function print_link($inactive, $text, $offset=" "){
 if ($inactive) {
  print "<span class='inactive'>$text</span>";
 }else{
  print "<span class='active'>". "<a href='".htmlentities($_SERVER['PHP_SELF'])."?offset=$offset'>$text</a></span>";
 }
}

//Indexded link funtion

function indexed_links($total, $offset, $per_page){
 //=========for print <<PREV link=======//
 //=====================================//
 $separator = " | ";
 print_link($offset == 1, "<< Prev", max(1, $offset - $per_page));

 //=========for print group Record=======//
 //==========not print Last one=========//
 //====================================//
 for ($start=1, $end = $per_page ; $end < $total;  $start += $per_page, $end += $per_page) { 
  print $separator;
  print_link($offset == $start, "$start-$end", $start);
 }
 $end = ($total > $start) ? "- $total": " ";
 //=========for print Last Group=======//
 //=====================================//
 print $separator;
 print_link($offset == $start, "$start$end", $start);
 //=========for print <<NEXT link=======//
 //=====================================//
 print $separator;
 print_link($offset == $start, 'Next>>', $offset + $per_page);
}

 ?>

Output:-

Simple Pagination Code with PHP – MySql PDO

इसे भी पढ़े – Display Inline Message in Form With Re-display Form