Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/pennagaram.org/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: edit-update.php

<!doctype html>
<html lang="en">
<?php
include('includes/head.php');
include('includes/db.php');

// Get update ID from URL
$updateId = isset($_GET['id']) ? intval($_GET['id']) : 0;

// Fetch update details
$update = null;
if ($updateId > 0) {
    $updateQuery = "SELECT * FROM updates WHERE id = ?";
    $stmt = mysqli_prepare($conn, $updateQuery);
    mysqli_stmt_bind_param($stmt, 'i', $updateId);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $update = mysqli_fetch_assoc($result);
    mysqli_stmt_close($stmt);
}

// If update not found, redirect to manage page
if (!$update) {
    header("Location: manage-updates.php");
    exit();
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action']) && $_POST['action'] === 'edit_update') {
        $title = mysqli_real_escape_string($conn, $_POST['title']);
        $content = mysqli_real_escape_string($conn, $_POST['content']);
        $update_type = mysqli_real_escape_string($conn, $_POST['update_type']);
        $status = mysqli_real_escape_string($conn, $_POST['status']);
        $publish_date = mysqli_real_escape_string($conn, $_POST['publish_date']);
        
        $uploadDir = 'uploads/updates/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0755, true);
        }
        
        $errors = [];
        $featured_image = $update['featured_image']; // Keep existing image by default
        
        // Handle featured image upload if new one is provided
        if (isset($_FILES['featured_image']) && $_FILES['featured_image']['error'] === 0) {
            $featuredImage = $_FILES['featured_image'];
            $imageExt = strtolower(pathinfo($featuredImage['name'], PATHINFO_EXTENSION));
            $allowedExt = ['jpg', 'jpeg', 'png', 'webp', 'gif'];
            
            if (in_array($imageExt, $allowedExt)) {
                $featuredImageName = 'update_' . time() . '_' . uniqid() . '.' . $imageExt;
                $featuredImageTarget = $uploadDir . $featuredImageName;
                
                if (move_uploaded_file($featuredImage['tmp_name'], $featuredImageTarget)) {
                    // Delete old image if exists
                    if (!empty($update['featured_image']) && file_exists($update['featured_image'])) {
                        unlink($update['featured_image']);
                    }
                    $featured_image = $featuredImageTarget;
                } else {
                    $errors[] = "Failed to upload featured image.";
                }
            } else {
                $errors[] = "Invalid featured image format. Allowed formats: JPG, JPEG, PNG, WebP, GIF.";
            }
        }
        
        // Handle image removal if requested
        if (isset($_POST['remove_image']) && $_POST['remove_image'] == '1') {
            if (!empty($update['featured_image']) && file_exists($update['featured_image'])) {
                unlink($update['featured_image']);
            }
            $featured_image = NULL;
        }
        
        if (empty($errors)) {
            // Update update details
            $updateSql = "UPDATE updates SET 
                         title = ?, content = ?, update_type = ?, 
                         featured_image = ?, status = ?, publish_date = ?, 
                         updated_at = NOW() 
                         WHERE id = ?";
            
            $stmt = mysqli_prepare($conn, $updateSql);
            mysqli_stmt_bind_param(
                $stmt, 
                'ssssssi',
                $title, $content, $update_type, $featured_image, $status, $publish_date, $updateId
            );
            
            if (mysqli_stmt_execute($stmt)) {
                $successMsg = "Update updated successfully!";
                // Refresh update data
                $updateQuery = "SELECT * FROM updates WHERE id = ?";
                $stmt = mysqli_prepare($conn, $updateQuery);
                mysqli_stmt_bind_param($stmt, 'i', $updateId);
                mysqli_stmt_execute($stmt);
                $result = mysqli_stmt_get_result($stmt);
                $update = mysqli_fetch_assoc($result);
                mysqli_stmt_close($stmt);
            } else {
                $errorMsg = "Failed to update update: " . mysqli_error($conn);
            }
            mysqli_stmt_close($stmt);
        } else {
            $errorMsg = implode("<br>", $errors);
        }
    }
}

// Update types for dropdown
$update_types = [
    'announcement' => 'Announcement',
    'event' => 'Event',
    'news' => 'News',
    'maintenance' => 'Maintenance',
    'alert' => 'Alert',
    'community' => 'Community'
];

// Function to get correct image path
function getUpdateImagePath($imagePath) {
    if (empty($imagePath)) {
        return false;
    }
    
    // Remove any ../ from the path for security
    $cleanPath = str_replace('../', '', $imagePath);
    
    // Check if the file exists
    if (file_exists($cleanPath)) {
        return $cleanPath;
    }
    
    // If file doesn't exist, try with different path variations
    $pathVariations = [
        $cleanPath,
        'uploads/updates/' . basename($cleanPath),
        '../uploads/updates/' . basename($cleanPath),
        '../../uploads/updates/' . basename($cleanPath)
    ];
    
    foreach ($pathVariations as $path) {
        if (file_exists($path)) {
            return $path;
        }
    }
    
    return false;
}
?>

<body data-sidebar="dark">

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">
<?php include('includes/topbar.php')?>
    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>
    
    
    
    
    <div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Edit Update</h4>
                            <div class="page-title-right">
                                <a href="manage-updates.php" class="btn btn-secondary">
                                    <i class="fas fa-arrow-left me-2"></i>Back to Updates
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (isset($successMsg)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <?php echo $successMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                <?php if (isset($errorMsg)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <?php echo $errorMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Update Details</h4>
                                <form method="post" enctype="multipart/form-data" id="editUpdateForm">
                                    <input type="hidden" name="action" value="edit_update">
                                    <input type="hidden" name="remove_image" id="removeImage" value="0">
                                    
                                    <div class="row">
                                        <div class="col-md-8">
                                            <div class="mb-3">
                                                <label for="title" class="form-label">Update Title *</label>
                                                <input type="text" class="form-control" id="title" name="title" 
                                                       value="<?php echo htmlspecialchars($update['title']); ?>" 
                                                       required placeholder="Enter update title" maxlength="255">
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="update_type" class="form-label">Update Type *</label>
                                                <select class="form-select" id="update_type" name="update_type" required>
                                                    <option value="">Select Type</option>
                                                    <?php foreach($update_types as $key => $value): ?>
                                                        <option value="<?php echo $key; ?>" 
                                                            <?php echo ($update['update_type'] == $key) ? 'selected' : ''; ?>>
                                                            <?php echo htmlspecialchars($value); ?>
                                                        </option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="content" class="form-label">Update Content *</label>
                                        <textarea class="form-control" id="content" name="content" required rows="6" 
                                                  placeholder="Enter the full update content"><?php echo htmlspecialchars($update['content']); ?></textarea>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="publish_date" class="form-label">Publish Date *</label>
                                                <input type="datetime-local" class="form-control" id="publish_date" name="publish_date" 
                                                       value="<?php echo date('Y-m-d\TH:i', strtotime($update['publish_date'])); ?>" required>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="status" class="form-label">Status *</label>
                                                <select class="form-select" id="status" name="status" required>
                                                    <option value="published" <?php echo ($update['status'] == 'published') ? 'selected' : ''; ?>>Published</option>
                                                    <option value="draft" <?php echo ($update['status'] == 'draft') ? 'selected' : ''; ?>>Draft</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="featured_image" class="form-label">Featured Image</label>
                                        
                                        
                                        <?php 
                                        $currentImagePath = getUpdateImagePath($update['featured_image']);
                                        if ($currentImagePath): ?>
                                        <div class="mb-3" id="currentImageContainer">
                                            <label class="form-label">Current Image:</label>
                                            <div class="d-flex align-items-center">
                                                <img src="<?php echo $currentImagePath; ?>" 
                                                     alt="Current featured image" 
                                                     class="rounded me-3" 
                                                     width="120" 
                                                     height="80" 
                                                     style="object-fit: cover;">
                                                <button type="button" class="btn btn-sm btn-outline-danger" onclick="removeCurrentImage()">
                                                    <i class="fas fa-trash me-1"></i>Remove Image
                                                </button>
                                            </div>
                                        </div>
                                        <?php endif; ?>
                                        
                                        
                                        <div id="newImageUpload" <?php echo $currentImagePath ? 'class="mt-3"' : ''; ?>>
                                            <label class="form-label"><?php echo $currentImagePath ? 'Upload New Image:' : 'Upload Image:'; ?></label>
                                            <input type="file" class="form-control" id="featured_image" name="featured_image" accept=".jpg,.jpeg,.png,.webp,.gif">
                                            <div class="form-text">Upload a new featured image. Supported formats: JPG, JPEG, PNG, WebP, GIF. Max file size: 5MB.</div>
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="card bg-light mt-4">
                                        <div class="card-body">
                                            <h6 class="card-title">Update Information</h6>
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <p class="mb-1"><strong>Created:</strong> <?php echo date('M j, Y g:i A', strtotime($update['created_at'])); ?></p>
                                                </div>
                                                <div class="col-md-6">
                                                    <p class="mb-1"><strong>Last Updated:</strong> 
                                                        <?php echo $update['updated_at'] ? date('M j, Y g:i A', strtotime($update['updated_at'])) : 'Never'; ?>
                                                    </p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mt-4">
                                        <button type="submit" class="btn btn-primary">
                                            <i class="fas fa-save me-2"></i>Update Changes
                                        </button>
                                        <button type="reset" class="btn btn-secondary">
                                            <i class="fas fa-redo me-2"></i>Reset Form
                                        </button>
                                        <a href="manage-updates.php" class="btn btn-light">
                                            <i class="fas fa-times me-2"></i>Cancel
                                        </a>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>


<?php include('includes/rightbar.php')?>


<?php include('includes/scripts.php')?>
<script>
document.addEventListener('DOMContentLoaded', function() {
    // Form validation and loading state
    document.getElementById('editUpdateForm').addEventListener('submit', function(e) {
        const title = document.getElementById('title').value.trim();
        const content = document.getElementById('content').value.trim();
        const updateType = document.getElementById('update_type').value.trim();
        const publishDate = document.getElementById('publish_date').value.trim();
        const status = document.getElementById('status').value.trim();
        
        // Basic validation
        if (!title || !content || !updateType || !publishDate || !status) {
            e.preventDefault();
            alert('Please fill all required fields (marked with *).');
            return;
        }
        
        // Content length validation
        if (content.length < 10) {
            e.preventDefault();
            alert('Update content should be at least 10 characters long.');
            return;
        }
        
        // File size validation for featured image
        const featuredImage = document.getElementById('featured_image').files[0];
        if (featuredImage && featuredImage.size > 5 * 1024 * 1024) {
            e.preventDefault();
            alert('Featured image size must be less than 5MB');
            return;
        }
        
        // Show loading state
        const submitBtn = this.querySelector('button[type="submit"]');
        submitBtn.innerHTML = '<i class="fas fa-spinner fa-spin me-2"></i>Updating...';
        submitBtn.disabled = true;
    });
});

function removeCurrentImage() {
    if (confirm('Are you sure you want to remove the current featured image?')) {
        document.getElementById('removeImage').value = '1';
        document.getElementById('currentImageContainer').style.display = 'none';
        document.getElementById('newImageUpload').classList.remove('mt-3');
    }
}

// Set minimum datetime for publish date to current time
const now = new Date();
const timezoneOffset = now.getTimezoneOffset() * 60000;
const localISOTime = new Date(now - timezoneOffset).toISOString().slice(0, 16);
document.getElementById('publish_date').min = localISOTime;
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-update.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation