query($sql); if ($result->num_rows > 0) { // Loop through each row while ($row = $result->fetch_assoc()) { $blog_id = $row['blog_id']; $title = $row['title']; $date = $row['date']; $category = $row['category']; $image = $row['image']; $description = $row['description']; $author = $row['author']; $blog_author = $row['author']; $members_only = $row['members_only']; if ($members_only) { if (!isset($_SESSION['user_id'])) { $blog_link = "login.php"; $button_hover = "Members Only"; $icon = "fa-lock"; } else { if (getUserMemberStatus($_SESSION['user_id'])) { $blog_link = "blog_read.php?token=".encryptData($blog_id, $salt); $button_hover = "Read More"; $icon = "fa-arrow-right"; } else { $blog_link = "#"; $button_hover = "Members Only"; $icon = "fa-lock"; } } } else { $blog_link = "blog_read.php?token=".encryptData($blog_id, $salt); $button_hover = "Read More"; $icon = "fa-arrow-right"; } // Output the HTML structure with dynamic data echo ' '; } } ?>