trying to add pagination, but it is showing all record and on going to next page not showing any data
0) {
while($row = mysqli_fetch_array($query)) {
$num_rows = mysqli_num_rows($query);
$per_page = 2; // Per Page
$page = 1;
if(isset($_GET[“Page”]))
{
$page = $_GET[“Page”];
}
$prev_page = $page-1;
$next_page = $page+1;
$row_start = (($per_page*$page)-$per_page);
if($num_rows $num_rows=$per_page)
{
$row_end = $num_rows;
}
$_query = mysqli_query($conn,”SELECT * FROM register WHERE id = ‘” . $row[“outgoing_msg_id”] . “‘ ORDER BY id DESC LIMIT $row_start ,$row_end “);
$recordExists = 0;
while($_row = mysqli_fetch_array($_query))
if ($row[‘incoming_msg_id’] === $id) {
$iv = hex2bin($row[‘iv’]);
$mess = str_openssl_dec($row[‘msg’], $iv);
$msg_id = ($row[‘msg_id’]);
{
if($recordExists == 0 )
$recordExists = 1;
echo ” “>
echo ‘
Name: ‘.$_row[‘name’].’
User Id: ‘.$_row[‘id’].’
Message: ‘.$mess.’
Reply
‘; }}}}
else
{
echo”
No Message..!!
“;
}
?>
Total Result : Page’s
◄ “;
}
for($i = max(1, $page – 3); $i $i “;
}
else
{
echo “$i”;
}
}
if($page!=$num_pages)
{
echo ” ► “;
}
$db = null;
?>