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: manage-sponsors.php

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

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        if ($_POST['action'] === 'delete_sponsor') {
            $sponsorId = (int)$_POST['sponsor_id'];
           
            // Get image before deletion
            $getSponsorSql = "SELECT image FROM sponsors WHERE id = ?";
            $stmt = mysqli_prepare($conn, $getSponsorSql);
            mysqli_stmt_bind_param($stmt, 'i', $sponsorId);
            mysqli_stmt_execute($stmt);
            mysqli_stmt_bind_result($stmt, $image);
            mysqli_stmt_fetch($stmt);
            mysqli_stmt_close($stmt);
           
            // Delete image file
            if (!empty($image)) {
                $filePath = 'uploads/sponsors/' . $image;
                if (file_exists($filePath)) {
                    unlink($filePath);
                }
            }
           
            // Delete sponsor from database
            $deleteSql = "DELETE FROM sponsors WHERE id = ?";
            $stmt = mysqli_prepare($conn, $deleteSql);
            mysqli_stmt_bind_param($stmt, 'i', $sponsorId);
            mysqli_stmt_execute($stmt);
            mysqli_stmt_close($stmt);
           
            $successMsg = "Sponsor deleted successfully!";
        } elseif ($_POST['action'] === 'add_sponsor') {
            // Handle adding new sponsor via modal
            $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
            $imageName = '';
            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)) {
                    $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.";
                }
            }
            
            if (!isset($errorMsg)) {
                // Insert new sponsor into database
                $insertSql = "INSERT INTO sponsors (name, image, target_amount, status, created_at) VALUES (?, ?, ?, ?, NOW())";
                $stmt = mysqli_prepare($conn, $insertSql);
                mysqli_stmt_bind_param($stmt, 'ssds', $name, $imageName, $target_amount, $status);
                
                if (mysqli_stmt_execute($stmt)) {
                    $successMsg = "Sponsor added successfully!";
                } else {
                    $errorMsg = "Failed to add sponsor: " . mysqli_error($conn);
                }
                mysqli_stmt_close($stmt);
            }
        }
    }
}

// Fetch sponsors
$sponsorsSql = "SELECT id, name, image, target_amount, status, created_at FROM sponsors ORDER BY created_at DESC";
$sponsorsResult = mysqli_query($conn, $sponsorsSql);
$sponsors = [];
if ($sponsorsResult && mysqli_num_rows($sponsorsResult) > 0) {
    while ($row = mysqli_fetch_assoc($sponsorsResult)) {
        $sponsors[] = $row;
    }
}

// Count statistics
$totalSponsors = count($sponsors);
?>
<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">Manage Sponsors</h4>
                            <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#addSponsorModal">
                                <i class="fas fa-plus me-2"></i>Add New Sponsor
                            </button>
                        </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-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-info mt-2"><?php echo $totalSponsors; ?></h3> Total Sponsors
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-purple mt-2"><?php echo date('M Y'); ?></h3> Current Month
                            </div>
                        </div>
                    </div>
                </div>
                
                
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Sponsors List</h4>
                                <?php if (empty($sponsors)): ?>
                                    <div class="text-center py-5">
                                        <i class="fas fa-wallet fa-3x text-muted mb-3"></i>
                                        <h5>No Sponsors</h5>
                                        <p class="text-muted">Add your first sponsor.</p>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered table-nowrap mb-0">
                                            <thead>
                                                <tr>
                                                    <th scope="col">#</th>
                                                    <th scope="col">Name</th>
                                                    <th scope="col">Image</th>
                                                    <th scope="col">Target Amount</th>
                                                    <th scope="col">Status</th>
                                                    <th scope="col">Created At</th>
                                                    <th scope="col">Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($sponsors as $index => $sponsor): ?>
                                                    <tr>
                                                        <th scope="row"><?php echo $index + 1; ?></th>
                                                        <td><?php echo htmlspecialchars($sponsor['name']); ?></td>
                                                        <td>
                                                            <?php if (!empty($sponsor['image'])): ?>
                                                                <img src="uploads/sponsors/<?php echo htmlspecialchars($sponsor['image']); ?>" alt="<?php echo htmlspecialchars($sponsor['name']); ?>" class="img-thumbnail" style="width: 50px; height: 50px; object-fit: cover;">
                                                            <?php else: ?>
                                                                <div class="bg-light d-flex align-items-center justify-content-center rounded" style="width: 50px; height: 50px;">
                                                                    <i class="fas fa-image text-muted"></i>
                                                                </div>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo number_format($sponsor['target_amount'], 2); ?></td>
                                                        <td>
                                                            <?php 
                                                            $statusClass = '';
                                                            switch($sponsor['status']) {
                                                                case 'active':
                                                                    $statusClass = 'badge bg-success';
                                                                    break;
                                                                case 'inactive':
                                                                    $statusClass = 'badge bg-secondary';
                                                                    break;
                                                                case 'completed':
                                                                    $statusClass = 'badge bg-primary';
                                                                    break;
                                                                case 'canceled':
                                                                    $statusClass = 'badge bg-danger';
                                                                    break;
                                                                default:
                                                                    $statusClass = 'badge bg-secondary';
                                                            }
                                                            ?>
                                                            <span class="<?php echo $statusClass; ?>"><?php echo ucfirst(htmlspecialchars($sponsor['status'])); ?></span>
                                                        </td>
                                                        <td><?php echo date('M j, Y', strtotime($sponsor['created_at'])); ?></td>
                                                        <td>
                                                            <a href="edit-sponsor.php?id=<?php echo $sponsor['id']; ?>" class="btn btn-primary btn-sm">
                                                                <i class="fas fa-edit"></i>
                                                            </a>
                                                            <form method="post" class="d-inline" onsubmit="return confirm('Are you sure you want to delete this sponsor?')">
                                                                <input type="hidden" name="action" value="delete_sponsor">
                                                                <input type="hidden" name="sponsor_id" value="<?php echo $sponsor['id']; ?>">
                                                                <button type="submit" class="btn btn-danger btn-sm">
                                                                    <i class="fas fa-trash"></i>
                                                                </button>
                                                            </form>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>


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

<div class="modal fade" id="addSponsorModal" tabindex="-1" aria-labelledby="addSponsorModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="addSponsorModalLabel">Add New Sponsor</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="post" enctype="multipart/form-data" id="addSponsorForm">
                <div class="modal-body">
                    <input type="hidden" name="action" value="add_sponsor">
                    <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" required>
                    </div>
                    <div class="mb-3">
                        <label for="image" class="form-label">Sponsor Image <span class="text-danger">*</span></label>
                        <input type="file" class="form-control" id="image" name="image" accept="image/*" required>
                        <div class="form-text">Allowed formats: JPG, JPEG, PNG, GIF</div>
                        <div id="imagePreview" class="mt-2"></div>
                    </div>
                    <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" step="0.01" min="0" required>
                    </div>
                    <div class="mb-3">
                        <label for="status" class="form-label">Status <span class="text-danger">*</span></label>
                        <select class="form-select" id="status1" name="status" required>
                            <option value="active">Active</option>
                            <option value="inactive">Inactive</option>
                            <option value="completed">Completed</option>
                            <option value="canceled">Canceled</option>
                        </select>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary">Add Sponsor</button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include('includes/scripts.php')?>
<script>
// Reset form when modal is closed
document.getElementById('addSponsorModal').addEventListener('hidden.bs.modal', function () {
    document.getElementById('addSponsorForm').reset();
    document.getElementById('imagePreview').innerHTML = '';
});

// 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 = `<img src="${e.target.result}" class="img-thumbnail" style="max-width: 200px;" alt="Preview">`;
        }
        reader.readAsDataURL(file);
    } else {
        preview.innerHTML = '';
    }
});

// Form validation
document.getElementById('addSponsorForm').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();
        }
    }
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-sponsors.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation