✏ 编辑: AddFestival.php

<?php
require_once '../../config.php';

$success = '';
$error = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $title = trim($_POST['festival_title']);
    $description = $_POST['festival_description']; 
    $start_date = $_POST['start_date'];
    $end_date = $_POST['end_date'];
    $status = $_POST['festival_status'] ?? 'active';

// Handle image upload
    $imageName = null;
    if (isset($_FILES['festival_image']) && $_FILES['festival_image']['error'] === 0) {
        $allowed = ['jpg', 'jpeg', 'png', 'gif'];
        $filename = $_FILES['festival_image']['name'];
        $ext = strtolower(pathinfo($filename, PATHINFO_EXTENSION));

if (in_array($ext, $allowed)) {
            $imageName = 'festival_' . time() . '.' . $ext;
            $uploadPath = '../../images/' . $imageName;

if (!move_uploaded_file($_FILES['festival_image']['tmp_name'], $uploadPath)) {
                $error = 'Failed to upload image';
            }
        } else {
            $error = 'Invalid image format. Only JPG, JPEG, PNG, and GIF allowed.';
        }
    }

if (empty($error)) {
        $conn = getDBConnection();
        $stmt = $conn->prepare("INSERT INTO festivals (title, description, image, start_date, end_date, status) VALUES (?, ?, ?, ?, ?, ?)");
        $stmt->bind_param("ssssss", $title, $description, $imageName, $start_date, $end_date, $status);

if ($stmt->execute()) {
            header("Location: festivalManagement.php");
            exit;
        } else {
            $error = 'Failed to add festival';
        }

$stmt->close();
        $conn->close();
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Add Festival</title>

* { margin: 0; padding: 0; box-sizing: border-box; }
        body { font-family: 'Libre Baskerville', serif; background: #fff; padding: 20px; color: #333; }
        .container { max-width: 1200px; margin: auto; background: #fff; border-radius: 8px; box-shadow: 0 1px 4px rgba(0,0,0,0.1); }
        .header { padding: 24px 32px; border-bottom: 2px solid #7da0ff; }
        .header h1 { font-size: 28px; color: #222; font-family: 'El Messiri'; font-weight: 300; }
        .header p { color: #666; }
        .back-btn { color: #7da0ff; text-decoration: none; font-size: 14px; margin-top: 10px; display: inline-block; }
        .back-btn:hover { color: #5c7ecb; }
        .content { padding: 32px; }
        .alert { padding: 12px; border-radius: 6px; margin-bottom: 16px; font-size: 14px; }
        .alert-success { background: #d4edda; color: #155724; }
        .alert-error { background: #f8d7da; color: #721c24; }
        .form-group { margin-bottom: 24px; }
        .form-group label { font-weight: bold; margin-bottom: 6px; display: block; }
        .form-group input, .form-group select { width: 100%; padding: 10px; border: 1.5px solid #d6dbff; border-radius: 6px; }
        .form-group input:focus, select:focus { border-color: #7da0ff; outline: none; }
        .form-group input[type="file"] { border: 2px dashed #d6dbff; padding: 8px; cursor: pointer; }
        .image-preview { max-width: 300px; display: none; margin-top: 12px; }
        .image-preview img { width: 100%; border-radius: 6px; border: 1.5px solid #d6dbff; }
        .btn-area { margin-top: 30px; display: flex; gap: 12px; }
        .submit-btn { background: transparent; border: 2px solid #7da0ff; padding: 12px 32px; color: #7da0ff; border-radius: 6px; cursor: pointer; font-size: 16px; font-weight: 600; }
        .submit-btn:hover { background: #7da0ff; color: #fff; }
        .cancel-btn { background: #f5f7ff; border: 2px solid #d6dbff; padding: 12px 32px; border-radius: 6px; font-weight: 600; text-decoration: none; }
        .cancel-btn:hover { background: #d6dbff; }

.helper-text { font-size: 12px; color: #666; margin-top: 4px; }
        .tox-tinymce { border: 1.5px solid #d6dbff !important; border-radius: 6px !important; }

</style>
</head>
<body>

<div class="container">
    <div class="header">
        <h1>Add New Festival</h1>
        <p>Create a new festival popup</p>
        <a href="festivalManagement.php" class="back-btn">← Back to Festivals</a>
    </div>

<form method="POST" enctype="multipart/form-data">
            
            <div class="form-group">
                <label>Festival Title *</label>
                <input type="text" name="festival_title" required placeholder="Enter festival title">
            </div>

<div class="form-group">
                <label>Description *</label>
                <textarea id="festival_description" name="festival_description"></textarea>

</div>

<div class="form-group">
                <label>Start Date *</label>
                <input type="date" name="start_date" required>
            </div>

<div class="form-group">
                <label>Festival Image</label>
                <input type="file" name="festival_image" accept="image/*" onchange="previewImage(event)">
                <div class="helper-text">Recommended: JPG, PNG, GIF</div>
                <div class="image-preview" id="imagePreview">
                    <img id="preview" />
                </div>
            </div>

<div class="form-group">
                <label>Status *</label>
                <select name="festival_status">
                    <option value="active">Active</option>
                    <option value="inactive">Inactive</option>
                </select>
            </div>

<div class="btn-area">
                <button type="submit" class="submit-btn">Add Festival</button>
                <a href="festivalManagement.php" class="cancel-btn">Cancel</a>
            </div>

</form>
    </div>
</div>

function previewImage(event) {
    let preview = document.getElementById("preview");
    let container = document.getElementById("imagePreview");

preview.src = URL.createObjectURL(event.target.files[0]);
    container.style.display = "block";
}

document.querySelector("form").addEventListener("submit", function(e) {
    tinymce.triggerSave(); // Sync TinyMCE content back to textarea
});

</script>

</body>
</html>

[X] 取消