Product Receiving Detail
$page = (int)(!isset($_GET["page"]) ? 1 : $_GET["page"]); if ($page <= 0) $page = 1; $per_page = 20; // Set how many records do you want to display per page. $startpoint = ($page * $per_page) - $per_page; $statement = "`receivings` ORDER BY `receiving_date` ASC"; // Change `records` according to your table name. $results = mysqli_query($conDB,"SELECT * FROM {$statement} LIMIT {$startpoint} , {$per_page}"); echo "
| Date | Item Code | Name | Detail | Price | Quantity | Total | "; echo "
|---|---|---|---|---|---|---|
| ".$row['receiving_date']." | ".$row['product_code']. " | " .$row['product_name']. " | " .$row['product_detail']. " | ".$row['price']. " | ".$row['qty']. " | ".$row['total']. " | "; echo "
";// displaying paginaiton. echo pagination($statement,$per_page,$page,$url='?'); ?>