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 = 'समाचार सफलतापूर्वक जोड़ा गया!'; } 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 = 'समाचार अपडेट किया गया!'; } $action = 'list'; } catch (Exception $e) { $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 = 'समाचार सफलतापूर्वक हटाया गया!'; } catch (Exception $e) { $error = 'हटाने में त्रुटि: ' . $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 = 'समाचार नहीं मिला!'; $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'; ?>

समाचार सूची

छवि	शीर्षक	स्थिति	लेखक	बनाया गया	कार्य

शीर्षक *

संक्षिप्त विवरण

सामग्री *

लेखक

स्थिति *

छवि

रद्द करें

समाचार प्रबंधन

समाचार सूची