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.31 TB

🔧 Quick Actions

✏️ Editing: edit-sponsor.php

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

// Initialize variables
$sponsor = null;
$errorMsg = '';
$successMsg = '';

// Check if sponsor ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header('Location: manage-sponsors.php');
    exit();
}

$sponsorId = (int)$_GET['id'];

// Fetch sponsor data
$getSponsorSql = "SELECT id, name, image, target_amount, status, created_at FROM sponsors WHERE id = ?";
$stmt = mysqli_prepare($conn, $getSponsorSql);
mysqli_stmt_bind_param($stmt, 'i', $sponsorId);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt); // Get the result set
$sponsor = mysqli_fetch_assoc($result); // Fetch from result, not statement
mysqli_stmt_close($stmt);

if (!$sponsor) {
    header('Location: manage-sponsors.php');
    exit();
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action']) && $_POST['action'] === 'update_sponsor') {
        $name = mysqli_real_escape_string($conn, $_POST['name']);
        $target_amount = (float)$_POST['target_amount'];
        $status = mysqli_real_escape_string($conn, $_POST['status']);
        
        // Handle image upload if new image is provided
        $imageName = $sponsor['image']; // Keep existing image by default
        
        if (isset($_FILES['image']) && $_FILES['image']['error'] === 0) {
            $allowedTypes = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
            $fileType = $_FILES['image']['type'];
            
            if (in_array($fileType, $allowedTypes)) {
                // Delete old image if it exists
                if (!empty($sponsor['image'])) {
                    $oldFilePath = 'uploads/sponsors/' . $sponsor['image'];
                    if (file_exists($oldFilePath)) {
                        unlink($oldFilePath);
                    }
                }
                
                // Upload new image
                $extension = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
                $imageName = uniqid() . '.' . $extension;
                $uploadPath = 'uploads/sponsors/' . $imageName;
                
                if (!move_uploaded_file($_FILES['image']['tmp_name'], $uploadPath)) {
                    $errorMsg = "Failed to upload image.";
                }
            } else {
                $errorMsg = "Invalid file type. Only JPG, JPEG, PNG, and GIF are allowed.";
            }
        } elseif (isset($_POST['remove_image']) && $_POST['remove_image'] === '1') {
            // Remove existing image
            if (!empty($sponsor['image'])) {
                $filePath = 'uploads/sponsors/' . $sponsor['image'];
                if (file_exists($filePath)) {
                    unlink($filePath);
                }
            }
            $imageName = '';
        }
        
        if (!isset($errorMsg)) {
            // Update sponsor in database
            $updateSql = "UPDATE sponsors SET name = ?, image = ?, target_amount = ?, status = ? WHERE id = ?";
            $stmt = mysqli_prepare($conn, $updateSql);
            mysqli_stmt_bind_param($stmt, 'ssdsi', $name, $imageName, $target_amount, $status, $sponsorId);
            
            if (mysqli_stmt_execute($stmt)) {
                $successMsg = "Sponsor updated successfully!";
                
                // Refresh sponsor data
                $getSponsorSql = "SELECT id, name, image, target_amount, status, created_at FROM sponsors WHERE id = ?";
                $stmt = mysqli_prepare($conn, $getSponsorSql);
                mysqli_stmt_bind_param($stmt, 'i', $sponsorId);
                mysqli_stmt_execute($stmt);
                $result = mysqli_stmt_get_result($stmt); // Get result set
                $sponsor = mysqli_fetch_assoc($result); // Fetch from result
                mysqli_stmt_close($stmt);
            } else {
                $errorMsg = "Failed to update sponsor: " . mysqli_error($conn);
            }
            mysqli_stmt_close($stmt);
        }
    }
}
?>
<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 Sponsor</h4>
                            <div>
                                <a href="manage-sponsors.php" class="btn btn-secondary me-2">
                                    <i class="fas fa-arrow-left me-2"></i>Back to Sponsors
                                </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">Edit Sponsor Details</h4>
                                
                                <form method="post" enctype="multipart/form-data" id="editSponsorForm">
                                    <input type="hidden" name="action" value="update_sponsor">
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="name" class="form-label">Sponsor Name <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="name" name="name" 
                                                       value="<?php echo htmlspecialchars($sponsor['name']); ?>" required>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="target_amount" class="form-label">Target Amount <span class="text-danger">*</span></label>
                                                <input type="number" class="form-control" id="target_amount" name="target_amount" 
                                                       value="<?php echo htmlspecialchars($sponsor['target_amount']); ?>" step="0.01" min="0" required>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="status" class="form-label">Status <span class="text-danger">*</span></label>
                                                <select class="form-select" id="status" name="status" required>
                                                    <option value="active" <?php echo $sponsor['status'] === 'active' ? 'selected' : ''; ?>>Active</option>
                                                    <option value="inactive" <?php echo $sponsor['status'] === 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                                                    <option value="completed" <?php echo $sponsor['status'] === 'completed' ? 'selected' : ''; ?>>Completed</option>
                                                    <option value="canceled" <?php echo $sponsor['status'] === 'canceled' ? 'selected' : ''; ?>>Canceled</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label class="form-label">Created At</label>
                                                <input type="text" class="form-control" value="<?php echo date('M j, Y g:i A', strtotime($sponsor['created_at'])); ?>" readonly>
                                            </div>
                                        </div>
                                    </div>

<div class="mb-3">
                                        <label for="image" class="form-label">Sponsor Image</label>
                                        
                                        
                                        <?php if (!empty($sponsor['image'])): ?>
                                            <div class="mb-3">
                                                <label class="form-label">Current Image</label>
                                                <div>
                                                    <img src="uploads/sponsors/<?php echo htmlspecialchars($sponsor['image']); ?>" 
                                                         alt="<?php echo htmlspecialchars($sponsor['name']); ?>" 
                                                         class="img-thumbnail me-3" style="width: 150px; height: 150px; object-fit: cover;">
                                                    <div class="form-check mt-2">
                                                        <input class="form-check-input" type="checkbox" name="remove_image" value="1" id="removeImage">
                                                        <label class="form-check-label text-danger" for="removeImage">
                                                            Remove current image
                                                        </label>
                                                    </div>
                                                </div>
                                            </div>
                                        <?php else: ?>
                                            <div class="alert alert-info">
                                                <i class="fas fa-info-circle me-2"></i>No image currently set for this sponsor.
                                            </div>
                                        <?php endif; ?>
                                        
                                        
                                        <div class="mb-3">
                                            <label for="image" class="form-label"><?php echo empty($sponsor['image']) ? 'Upload Image' : 'Change Image'; ?> <span class="text-muted">(Optional)</span></label>
                                            <input type="file" class="form-control" id="image" name="image" accept="image/*">
                                            <div class="form-text">Allowed formats: JPG, JPEG, PNG, GIF. Leave empty to keep current image.</div>
                                            <div id="imagePreview" class="mt-2"></div>
                                        </div>
                                    </div>

<div class="row mt-4">
                                        <div class="col-12">
                                            <button type="submit" class="btn btn-primary me-2">
                                                <i class="fas fa-save me-2"></i>Update Sponsor
                                            </button>
                                            <a href="manage-sponsors.php" class="btn btn-secondary">
                                                <i class="fas fa-times me-2"></i>Cancel
                                            </a>
                                        </div>
                                    </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>
// Image preview functionality
document.getElementById('image').addEventListener('change', function(e) {
    const file = e.target.files[0];
    const preview = document.getElementById('imagePreview');
    
    if (file) {
        const reader = new FileReader();
        reader.onload = function(e) {
            preview.innerHTML = `
                <div class="alert alert-info">
                    <strong>New Image Preview:</strong>
                </div>
                <img src="${e.target.result}" class="img-thumbnail mt-2" style="max-width: 200px;" alt="Preview">
            `;
        }
        reader.readAsDataURL(file);
    } else {
        preview.innerHTML = '';
    }
});

// Form validation
document.getElementById('editSponsorForm').addEventListener('submit', function(e) {
    const fileInput = document.getElementById('image');
    const file = fileInput.files[0];
    
    if (file) {
        const allowedTypes = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
        if (!allowedTypes.includes(file.type)) {
            e.preventDefault();
            alert('Please select a valid image file (JPG, JPEG, PNG, or GIF).');
            fileInput.focus();
        }
    }
    
    const removeImageCheckbox = document.getElementById('removeImage');
    const newImage = fileInput.files[0];
    
    if (removeImageCheckbox && removeImageCheckbox.checked && !newImage) {
        if (!confirm('You are removing the current image without uploading a new one. Continue?')) {
            e.preventDefault();
        }
    }
});

// Remove image checkbox logic
const removeImageCheckbox = document.getElementById('removeImage');
const imageInput = document.getElementById('image');

if (removeImageCheckbox && imageInput) {
    removeImageCheckbox.addEventListener('change', function() {
        if (this.checked) {
            imageInput.disabled = false;
        }
    });
    
    imageInput.addEventListener('change', function() {
        if (this.files.length > 0) {
            removeImageCheckbox.checked = false;
        }
    });
}
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-sponsor.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation