$pageResult = mysqli_query($con, $pageSql);
$count = mysqli_num_rows($pageResult);
if ($count > 0) {
$paginationCount = DhsHelper::getPagination($count);
}
// ***** Pagination Work End ******
if (isset($_GET['page_id']) && !empty($_GET['page_id'])) {
$page_id = $_GET['page_id'];
} else {
$page_id = '0';
}
$pageLimit = PAGE_PER_NO * $page_id;
$sql .= " limit {$pageLimit}," . PAGE_PER_NO;
$result = mysqli_query($con, $sql);
$n = 0;
$categories = DhsHelper::getCategories($con);
while ($row = mysqli_fetch_array($result)) {
$n++;
?>
<tr class="row<?php
echo $row['medicine_id'];
?>
">
<td><?php
echo $n;
?>
</td>
<td><?php
echo $row['medicine_name'];
?>
</td>
