// how much row show enter here $show_row = 200; if (isset($_REQUEST["start_id"])) { $start_id = $_REQUEST['start_id']; $sql = "SELECT * FROM `product` ORDER BY `id` DESC limit $start_id,$show_row"; } else { $sql = "SELECT * FROM `product` ORDER BY `id` DESC LIMIT $show_row"; }
<?php // how much row show enter here $show_row = 200; //start id >> if id not start from 0 you can customize it $start_id = 200; $page_id = 1; $page_id_biyog = 1; $page_id_jog = 1; if (isset($_REQUEST['page_id'])) { $page_id = $_REQUEST['page_id']; $page_id_biyog = $page_id - 1; $page_id_jog = $page_id + 1; } if (isset($_REQUEST['start_id'])) { $start_id = $_REQUEST['start_id']; } ?>
Previous
<?php $page_id = 1; if (isset($_REQUEST['page_id'])) { $page_id = $_REQUEST['page_id']; } $t0 = mysqli_query($con, "SELECT * FROM `product`"); $t1 = mysqli_num_rows($t0); $vag = ceil($t1 / $show_row); $i = 1; while ($vag >= $i) { ?>
<?php echo $i; ?>
<?php $i++; } ?>
Next
<?php include("footer.php"); ?>