prepare(" INSERT INTO news (title, content, excerpt, image, author, status, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, NOW(), NOW()) "); $stmt->execute([$title, $content, $excerpt, $image, $author, $status]); $message = 'News added successfully!'; } else { // Keep existing image if no new image uploaded if (empty($image)) { $stmt = $db->prepare("SELECT image FROM news WHERE id = ?"); $stmt->execute([$id]); $existing = $stmt->fetch(); $image = $existing['image'] ?? ''; } $stmt = $db->prepare(" UPDATE news SET title = ?, content = ?, excerpt = ?, image = ?, author = ?, status = ?, updated_at = NOW() WHERE id = ? "); $stmt->execute([$title, $content, $excerpt, $image, $author, $status, $id]); $message = 'News updated successfully!'; } $action = 'list'; } catch (Exception $e) { $error = 'Error: ' . $e->getMessage(); } break; case 'delete': try { $delete_id = $_POST['id']; // Get image filename before deleting $stmt = $db->prepare("SELECT image FROM news WHERE id = ?"); $stmt->execute([$delete_id]); $news = $stmt->fetch(); // Delete news $stmt = $db->prepare("DELETE FROM news WHERE id = ?"); $stmt->execute([$delete_id]); // Delete image if it exists if (!empty($news['image']) && file_exists('../img/' . $news['image'])) { unlink('../img/' . $news['image']); } $message = 'News deleted successfully!'; } catch (Exception $e) { $error = 'Error deleting news: ' . $e->getMessage(); } break; } } } // Get news data for editing $news_data = null; if ($action === 'edit' && $id > 0) { $stmt = $db->prepare("SELECT * FROM news WHERE id = ?"); $stmt->execute([$id]); $news_data = $stmt->fetch(); if (!$news_data) { $error = 'News not found!'; $action = 'list'; } } // Get news list - using only columns that exist in your table $news_list = []; if ($action === 'list') { $stmt = $db->prepare("SELECT * FROM news ORDER BY created_at DESC"); $stmt->execute(); $news_list = $stmt->fetchAll(); } include 'includes/header.php'; ?>

News List

Image	Title	Status	Author	Created	Actions

Title *

Excerpt

Content *

Author

Status *

Image

Cancel

News Management

News List