real_escape_string($category) . "'"; } if ($tag) { $where[] = "tags LIKE '%" . $conn->real_escape_string($tag) . "%'"; } $where_sql = count($where) ? "WHERE " . implode(" AND ", $where) : ""; $result = $conn->query("SELECT * FROM articles $where_sql ORDER BY created_at DESC LIMIT $offset, $limit"); $total_result = $conn->query("SELECT COUNT(*) as total FROM articles $where_sql")->fetch_assoc(); $total_pages = ceil($total_result['total'] / $limit); // Fetch distinct categories for filter list $category_list = $conn->query("SELECT DISTINCT category FROM articles"); ?> Mari Mari Dive & Lodge, Sepanggar | Blog
fetch_assoc()): ?>
<?= htmlspecialchars($row['title']) ?>

Read More

See it to believe it

Mari Mari Dive & Lodge
Sepanggar

RAINBOW ISLAND, SEPANGGARCounter 13, Jesselton Point Ferry Terminal, Kota Kinabalu, 88000 Sabah, Malaysia.
[email protected] (Reservation)
Office - 6088-381 621 or Hotline - 6013-883 4921