real_escape_string($_POST['data']);
// Get total records for pagination
$countSql = "SELECT COUNT(*) as total FROM `tour_packages` WHERE category LIKE '%$data%' OR package_name LIKE '%$data%'";
$countResult = $conn->query($countSql);
$totalRecords = $countResult->fetch_assoc()['total'];
$totalPages = ceil($totalRecords / $limit);
// Get limited records
$sql = "SELECT * FROM `tour_packages` WHERE category LIKE '%$data%' OR package_name LIKE '%$data%' LIMIT $limit OFFSET $offset";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "";
echo "| Category | Package Name | Details |
|---|
";
while ($row = $result->fetch_assoc()) {
echo "";
// echo "| {$row['id']} | ";
echo "{$row['category']} | ";
echo "{$row['package_name']} | ";
echo "View | ";
echo "
";
}
echo "
";
// Pagination buttons
echo "";
} else {
echo "No data found.
";
}
}
?>