prepare("INSERT INTO health_tips (title, image, content) VALUES (?, ?, ?)"); $stmt->bind_param("sss", $title, $db_path, $content); $stmt->execute(); $msg = "Health Tip Published!"; } else { $msg = "Image Upload Failed."; } } // Handle Delete if (isset($_GET['delete'])) { $id = $_GET['delete']; $conn->query("DELETE FROM health_tips WHERE id=$id"); header("Location: manage_tips.php"); } ?> Manage Health Tips

Write New Health Tip

$msg

"; ?>

Published Articles

query("SELECT * FROM health_tips ORDER BY id DESC"); while($row = $result->fetch_assoc()) { echo '
'; // Check if image path starts with assets (new uploads) or is default $imgSrc = (strpos($row['image'], 'assets') === 0) ? '../'.$row['image'] : 'https://via.placeholder.com/150'; echo ''; echo '
'; echo '

' . $row['title'] . '

'; echo '

' . substr($row['content'], 0, 100) . '...

'; echo 'Posted: ' . date('d M Y', strtotime($row['created_at'])) . ''; echo '
'; echo 'Delete'; echo '
'; } ?>