prepare("SELECT * FROM posts WHERE id = ?"); $stmt->execute([$_GET['edit']]); $post = $stmt->fetch(); } // SAVE POST if (isset($_POST['save_post'])) { $title = trim($_POST['title']); $slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $title))); // Auto-slug $content = $_POST['content']; // Handle Image Upload $image_path = $post['image'] ?? ''; if (!empty($_FILES['image']['name'])) { $target = "../assets/images/blog/" . time() . "_" . $_FILES['image']['name']; // Ensure folder exists if (!is_dir("../assets/images/blog/")) mkdir("../assets/images/blog/", 0777, true); if (move_uploaded_file($_FILES['image']['tmp_name'], $target)) { $image_path = str_replace("../", "", $target); // Save relative path } } if ($post) { // UPDATE $stmt = $pdo->prepare("UPDATE posts SET title=?, content=?, image=? WHERE id=?"); $stmt->execute([$title, $content, $image_path, $post['id']]); $msg = "Post updated!"; } else { // INSERT $stmt = $pdo->prepare("INSERT INTO posts (title, slug, content, image) VALUES (?, ?, ?, ?)"); $stmt->execute([$title, $slug, $content, $image_path]); $msg = "Post published!"; // Fetch new ID to stay on edit page $post = ['id' => $pdo->lastInsertId(), 'title'=>$title, 'content'=>$content, 'image'=>$image_path]; } } ?> Write Post sidebar

Back to List
Tip: Use <h2> for headings and <p> for paragraphs.