query($queryartikel); $limit = 5; $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; $page = max($page, 1); // Pastikan halaman minimal 1 $offset = ($page - 1) * $limit; $search = isset($_GET['q']) ? trim($_GET['q']) : ''; if (!empty($search)) { $totalQuery = "SELECT COUNT(*) AS total FROM detail_artikel WHERE judul_artikel LIKE ? OR deskripsi_artikel LIKE ?"; $stmtTotal = $conn->prepare($totalQuery); $likeSearch = "%$search%"; $stmtTotal->bind_param("ss", $likeSearch, $likeSearch); $stmtTotal->execute(); $resultTotal = $stmtTotal->get_result(); $totalRow = $resultTotal->fetch_assoc(); $totalArticles = $totalRow['total']; $stmtTotal->close(); $queryartikelall = "SELECT * FROM detail_artikel WHERE judul_artikel LIKE ? OR deskripsi_artikel LIKE ? ORDER BY tanggal DESC LIMIT ? OFFSET ?"; $stmt = $conn->prepare($queryartikelall); $stmt->bind_param("ssii", $likeSearch, $likeSearch, $limit, $offset); } else { $totalQuery = "SELECT COUNT(*) AS total FROM detail_artikel"; $totalResult = $conn->query($totalQuery); $totalRow = $totalResult->fetch_assoc(); $totalArticles = $totalRow['total']; $queryartikelall = "SELECT * FROM detail_artikel ORDER BY tanggal DESC LIMIT ? OFFSET ?"; $stmt = $conn->prepare($queryartikelall); $stmt->bind_param("ii", $limit, $offset); } $totalPages = ceil($totalArticles / $limit); $stmt->execute(); $resultall = $stmt->get_result(); $stmt->close(); $conn->close(); ?> Pencarian untuk: <?php echo htmlspecialchars($search); ?> | Portal UMKM
  1. Beranda
  2. Blog

Pencarian untuk:

num_rows > 0) { ?> fetch_assoc()) { ?>
Oops! Tidak ada artikel yang ditemukan.

Coba cari dengan kata kunci lain atau kembali ke halaman utama blog.

Cari

Artikel Terbaru

fetch_assoc()) { ?>
<?= htmlspecialchars($row['judul_artikel']); ?>