false, 'message' => '', 'filename' => '']; // Create target directory if it doesn't exist $targetPath = __DIR__ . '/../' . $targetDir; if (!is_dir($targetPath)) { mkdir($targetPath, 0755, true); } // Check if file was uploaded if ($file['error'] !== UPLOAD_ERR_OK) { $result['message'] = 'फ़ाइल अपलोड में त्रुटि।'; return $result; } // Validate image $imageInfo = getimagesize($file['tmp_name']); if ($imageInfo === false) { $result['message'] = 'अमान्य छवि फ़ाइल।'; return $result; } $fileName = basename($file['name']); $fileExt = strtolower(pathinfo($fileName, PATHINFO_EXTENSION)); $newFileName = uniqid() . '.' . $fileExt; $targetFile = $targetPath . '/' . $newFileName; // Validate file type if (!in_array($fileExt, $allowedTypes)) { $result['message'] = 'अनुमति नहीं है फ़ाइल प्रकार। केवल ' . implode(', ', $allowedTypes) . ' अनुमत हैं।'; return $result; } // Validate file size if ($file['size'] > $maxFileSize) { $result['message'] = 'फ़ाइल का आकार 5MB से अधिक नहीं होना चाहिए।'; return $result; } // Move uploaded file if (move_uploaded_file($file['tmp_name'], $targetFile)) { $result['success'] = true; $result['filename'] = $newFileName; logError("File uploaded successfully: $newFileName to $targetDir"); } else { $result['message'] = 'फ़ाइल अपलोड करने में विफल।'; } return $result; } // Initialize variables $action = isset($_GET['action']) ? sanitizeInput($_GET['action']) : 'list'; $id = isset($_GET['id']) ? (int)$_GET['id'] : 0; $success = isset($_GET['success']) ? sanitizeInput($_GET['success']) : ''; $error = ''; try { $db = getDbConnection(); // Verify table existence $stmt = $db->query("SHOW TABLES LIKE 'our_ideals'"); if ($stmt->rowCount() == 0) { logError("Table 'our_ideals' does not exist in database."); $error = "डेटाबेस में 'our_ideals' तालिका नहीं मिली।"; $idealItems = []; $totalPages = 0; } } catch (PDOException $e) { logError("Database connection error: " . $e->getMessage()); $error = "डेटाबेस त्रुटि: " . $e->getMessage(); $idealItems = []; $totalPages = 0; } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (!verifyCSRF($_POST['csrf_token'] ?? '')) { $error = "अमान्य CSRF टोकन।"; logError($error); } elseif (isset($_POST['action'])) { $formAction = $_POST['action']; if ($formAction === 'add' || $formAction === 'edit') { $title = isset($_POST['title']) ? sanitizeInput($_POST['title']) : ''; $description = isset($_POST['description']) ? $_POST['description'] : ''; $father_name = isset($_POST['father_name']) ? sanitizeInput($_POST['father_name']) : ''; $mother_name = isset($_POST['mother_name']) ? sanitizeInput($_POST['mother_name']) : ''; $father_birth_date = isset($_POST['father_birth_date']) ? sanitizeInput($_POST['father_birth_date']) : null; $mother_birth_date = isset($_POST['mother_birth_date']) ? sanitizeInput($_POST['mother_birth_date']) : null; $father_death_date = isset($_POST['father_death_date']) ? sanitizeInput($_POST['father_death_date']) : null; $mother_death_date = isset($_POST['mother_death_date']) ? sanitizeInput($_POST['mother_death_date']) : null; $message = isset($_POST['message']) ? $_POST['message'] : ''; $sort_order = isset($_POST['sort_order']) ? (int)$_POST['sort_order'] : 1; $status = isset($_POST['status']) ? sanitizeInput($_POST['status']) : 'active'; if (empty($title) || empty($description)) { $error = "शीर्षक और विवरण आवश्यक हैं।"; } else { try { $image = null; if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) { $uploadResult = uploadFile($_FILES['image'], 'img/ideals'); if ($uploadResult['success']) { $image = $uploadResult['filename']; } else { throw new Exception($uploadResult['message']); } } if ($formAction === 'add') { $stmt = $db->prepare("INSERT INTO our_ideals (title, description, image, father_name, mother_name, father_birth_date, mother_birth_date, father_death_date, mother_death_date, message, sort_order, status, created_at) VALUES (:title, :description, :image, :father_name, :mother_name, :father_birth_date, :mother_birth_date, :father_death_date, :mother_death_date, :message, :sort_order, :status, NOW())"); $stmt->bindParam(':title', $title); $stmt->bindParam(':description', $description); $stmt->bindParam(':image', $image); $stmt->bindParam(':father_name', $father_name); $stmt->bindParam(':mother_name', $mother_name); $stmt->bindParam(':father_birth_date', $father_birth_date); $stmt->bindParam(':mother_birth_date', $mother_birth_date); $stmt->bindParam(':father_death_date', $father_death_date); $stmt->bindParam(':mother_death_date', $mother_death_date); $stmt->bindParam(':message', $message); $stmt->bindParam(':sort_order', $sort_order); $stmt->bindParam(':status', $status); $stmt->execute(); $success = "हमारे आदर्श सफलतापूर्वक जोड़े गए।"; } else { $ideal_id = isset($_POST['ideal_id']) ? (int)$_POST['ideal_id'] : 0; $stmt = $db->prepare("SELECT image FROM our_ideals WHERE id = :id"); $stmt->bindParam(':id', $ideal_id); $stmt->execute(); $currentData = $stmt->fetch(); if (!$currentData) { throw new Exception("आदर्श नहीं मिले।"); } if (empty($image)) { $image = $currentData['image']; } else { if (!empty($currentData['image'])) { $oldImagePath = __DIR__ . '/../img/ideals/' . $currentData['image']; if (file_exists($oldImagePath)) { unlink($oldImagePath); logError("Old image deleted: " . $currentData['image']); } } } $stmt = $db->prepare("UPDATE our_ideals SET title = :title, description = :description, image = :image, father_name = :father_name, mother_name = :mother_name, father_birth_date = :father_birth_date, mother_birth_date = :mother_birth_date, father_death_date = :father_death_date, mother_death_date = :mother_death_date, message = :message, sort_order = :sort_order, status = :status, updated_at = NOW() WHERE id = :id"); $stmt->bindParam(':title', $title); $stmt->bindParam(':description', $description); $stmt->bindParam(':image', $image); $stmt->bindParam(':father_name', $father_name); $stmt->bindParam(':mother_name', $mother_name); $stmt->bindParam(':father_birth_date', $father_birth_date); $stmt->bindParam(':mother_birth_date', $mother_birth_date); $stmt->bindParam(':father_death_date', $father_death_date); $stmt->bindParam(':mother_death_date', $mother_death_date); $stmt->bindParam(':message', $message); $stmt->bindParam(':sort_order', $sort_order); $stmt->bindParam(':status', $status); $stmt->bindParam(':id', $ideal_id); $stmt->execute(); $success = "हमारे आदर्श सफलतापूर्वक अपडेट किए गए।"; } header("Location: manage-ideals.php?success=" . urlencode($success)); exit; } catch (Exception $e) { $error = "त्रुटि: " . $e->getMessage(); logError($error); } } } if ($formAction === 'delete') { $ideal_id = isset($_POST['ideal_id']) ? (int)$_POST['ideal_id'] : 0; try { $stmt = $db->prepare("SELECT image FROM our_ideals WHERE id = :id"); $stmt->bindParam(':id', $ideal_id); $stmt->execute(); $data = $stmt->fetch(); $stmt = $db->prepare("DELETE FROM our_ideals WHERE id = :id"); $stmt->bindParam(':id', $ideal_id); $stmt->execute(); if (!empty($data['image'])) { $imagePath = __DIR__ . '/../img/ideals/' . $data['image']; if (file_exists($imagePath)) { unlink($imagePath); logError("Image deleted on content deletion: " . $data['image']); } } $success = "हमारे आदर्श सफलतापूर्वक हटाए गए।"; header("Location: manage-ideals.php?success=" . urlencode($success)); exit; } catch (PDOException $e) { $error = "डेटाबेस त्रुटि: " . $e->getMessage(); logError($error); } } if ($formAction === 'toggle') { $ideal_id = isset($_POST['ideal_id']) ? (int)$_POST['ideal_id'] : 0; try { $stmt = $db->prepare("SELECT status FROM our_ideals WHERE id = :id"); $stmt->bindParam(':id', $ideal_id); $stmt->execute(); $currentData = $stmt->fetch(); if (!$currentData) { throw new Exception("आदर्श नहीं मिले।"); } $newStatus = $currentData['status'] === 'active' ? 'inactive' : 'active'; $stmt = $db->prepare("UPDATE our_ideals SET status = :status, updated_at = NOW() WHERE id = :id"); $stmt->bindParam(':status', $newStatus); $stmt->bindParam(':id', $ideal_id); $stmt->execute(); $success = "हमारे आदर्श की स्थिति सफलतापूर्वक अपडेट की गई।"; header("Location: manage-ideals.php?success=" . urlencode($success)); exit; } catch (Exception $e) { $error = "त्रुटि: " . $e->getMessage(); logError($error); } } } } // Get data for edit if ($action === 'edit' && $id > 0) { try { $stmt = $db->prepare("SELECT * FROM our_ideals WHERE id = :id"); $stmt->bindParam(':id', $id); $stmt->execute(); $ideal = $stmt->fetch(PDO::FETCH_ASSOC); if (!$ideal) { $error = "आदर्श नहीं मिले।"; $action = 'list'; } } catch (PDOException $e) { logError("Edit query error: " . $e->getMessage()); $error = "डेटाबेस त्रुटि: " . $e->getMessage(); $action = 'list'; } } // Get data for list with pagination $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; $limit = 12; $offset = ($page - 1) * $limit; try { $stmt = $db->prepare("SELECT COUNT(*) FROM our_ideals"); $stmt->execute(); $totalRecords = $stmt->fetchColumn(); $stmt = $db->prepare("SELECT * FROM our_ideals ORDER BY sort_order ASC LIMIT :limit OFFSET :offset"); $stmt->bindValue(':limit', $limit, PDO::PARAM_INT); $stmt->bindValue(':offset', $offset, PDO::PARAM_INT); $stmt->execute(); $idealItems = $stmt->fetchAll(PDO::FETCH_ASSOC); $totalPages = ceil($totalRecords / $limit); } catch (PDOException $e) { logError("Database query error for our_ideals: " . $e->getMessage()); $error = "डेटाबेस त्रुटि: " . $e->getMessage(); $idealItems = []; $totalPages = 0; } // Set page title $pageTitle = ($action === 'add') ? "नए आदर्श जोड़ें" : (($action === 'edit') ? "आदर्श संपादित करें" : "हमारे आदर्श प्रबंधन"); include 'includes/header.php'; ?>
हमारे आदर्श प्रबंधन
वापस
नए आदर्श जोड़ें
शीर्षक
*
विवरण
*
<?php echo htmlspecialchars($ideal['description'] ?? "हमारे प्रेरणास्रोत माता-पिता जिन्होंने हमें जीवन की सच्चाई सिखाई और हमेशा सत्य के मार्ग पर चलने की प्रेरणा दी।"); ?>
पिता का नाम
माता का नाम
पिता का जन्म दिनांक
माता का जन्म दिनांक
पिता का देहांत दिनांक
माता का देहांत दिनांक
प्रेरणादायक संदेश
<?php echo htmlspecialchars($ideal['message'] ?? "माता-पिता का आशीर्वाद ही जीवन की सबसे बड़ी संपत्ति है। उनके आदर्शों को अपनाकर ही हम सफलता की ऊंचाइयों तक पहुंच सकते हैं।"); ?>
छवि
*
>
नया छवि अपलोड करने पर वर्तमान छवि बदल जाएगा।
क्रम
स्थिति
>सक्रिय
>निष्क्रिय
रद्द करें
आदर्श सूची
0): ?>
छवि
शीर्षक
विवरण
पिता का नाम
माता का नाम
स्थिति
कार्य
50 ? '...' : ''); ?>
कोई आदर्श नहीं मिले।
1): ?>
पुष्टि करें
क्या आप वाकई इस आदर्श को हटाना चाहते हैं?
यह क्रिया पूर्ववत नहीं की जा सकती है।
![<?php echo htmlspecialchars($item['title']); ?>](<?php echo SITE_URL; ?>/img/ideals/<?php echo htmlspecialchars($item['image']); ?>)