File: /var/www/html/tmpr/../tmpr/..//tmpr/../tmpr/../tmpr/../newdatasets/paginateApp2.php
<?php /* --------------------------------------------- */
$query_pag_num = "SELECT COUNT(*) AS count FROM `reporta` where yanani = $channel and type != 'flv' and type != 'mov' and type != 'mp4' ";
$result_pag_num = mysqli_query($query_pag_num);
$row_Latest = mysql_fetch_array($result_pag_num);
$count = $row_Latest['count'];
$no_of_paginations = ceil($count / $per_page);
/* ---------------Calculating the starting and endign values for the loop----------------------------------- */
if ($cur_page >= 7) {
$startRow_Latest_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) {
$startRow_Latest_loop = $no_of_paginations - 6;
$end_loop = $no_of_paginations;
} else {
$end_loop = $no_of_paginations;
}
} else {
$startRow_Latest_loop = 1;
if ($no_of_paginations > 7)
$end_loop = 7;
else
$end_loop = $no_of_paginations;
}
/* ----------------------------------------------------------------------------------------------------------- */
$cur_pageX =$cur_page+1;
$msg .= " <div class='paginationReportaM' ><ul>";
$total_string = " ";
$msg .= $total_string;
// FOR ENABLING THE PREVIOUS BUTTON
if ($previous_btn && $cur_page > 0) {
$pre = $cur_page - 1;
$msg .= "<li p='$pre' class='active' style=' background-color:#09F;' >Prev</li>";
} else if ($previous_btn) {
$msg .= "<li class='inactive'>Prev</li>";
}
/*for ($i = $startRow_Latest_loop; $i <= $end_loop; $i++) {
if ($cur_page == $i)
$msg .= "<li p='$i' style='color:#fff;background-color:#006699;' class='active'>{$i}</li>";
else
$msg .= "<li p='$i' class='active'>{$i}</li>";
}*/
// TO ENABLE THE NEXT BUTTON
if ($next_btn && $cur_page < $no_of_paginations) {
$nex = $cur_page + 1;
$msg .= "<li p='$nex' class='active' style=' background-color:#09F;'>Next</li>";
} else if ($next_btn) {
$msg .= "<li class='inactive'>Next</li>";
}
$goto = "<input type='text' class='gotoReportaM' size='1' style=''/><input type='button' id='go_btnM' class='go_buttonM' value='Go'/>";
$msg = $msg . "</ul> </div>"; // Content for pagination
echo "";
echo $msg;?>