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

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

// Handle actions (delete, status change)
if (isset($_GET['action']) && isset($_GET['id'])) {
    $updateId = intval($_GET['id']);
    $action = $_GET['action'];
    
    if ($action === 'delete') {
        // Delete update
        $deleteSql = "DELETE FROM updates WHERE id = ?";
        $stmt = mysqli_prepare($conn, $deleteSql);
        mysqli_stmt_bind_param($stmt, 'i', $updateId);
        if (mysqli_stmt_execute($stmt)) {
            $successMsg = "Update deleted successfully!";
        } else {
            $errorMsg = "Failed to delete update: " . mysqli_error($conn);
        }
        mysqli_stmt_close($stmt);
    } elseif ($action === 'toggle_status') {
        // Toggle update status
        $currentStatus = $_GET['current_status'];
        $newStatus = $currentStatus === 'published' ? 'draft' : 'published';
        
        $updateSql = "UPDATE updates SET status = ? WHERE id = ?";
        $stmt = mysqli_prepare($conn, $updateSql);
        mysqli_stmt_bind_param($stmt, 'si', $newStatus, $updateId);
        if (mysqli_stmt_execute($stmt)) {
            $successMsg = "Update status updated successfully!";
        } else {
            $errorMsg = "Failed to update update status: " . mysqli_error($conn);
        }
        mysqli_stmt_close($stmt);
    }
}

// Get search and filter parameters
$search = $_GET['search'] ?? '';
$status = $_GET['status'] ?? '';
$type = $_GET['type'] ?? '';
$page = $_GET['page'] ?? 1;
$per_page = 10;
$offset = ($page - 1) * $per_page;

// Build query for updates
$update_query = "SELECT * FROM updates WHERE 1=1";
$count_query = "SELECT COUNT(*) as total FROM updates WHERE 1=1";

// Add search filter
if (!empty($search)) {
    $search_term = mysqli_real_escape_string($conn, $search);
    $update_query .= " AND (title LIKE '%$search_term%' OR content LIKE '%$search_term%')";
    $count_query .= " AND (title LIKE '%$search_term%' OR content LIKE '%$search_term%')";
}

// Add status filter
if (!empty($status) && in_array($status, ['published', 'draft'])) {
    $update_query .= " AND status = '$status'";
    $count_query .= " AND status = '$status'";
}

// Add type filter
if (!empty($type)) {
    $type_filter = mysqli_real_escape_string($conn, $type);
    $update_query .= " AND update_type = '$type_filter'";
    $count_query .= " AND update_type = '$type_filter'";
}

// Add ordering and pagination
$update_query .= " ORDER BY publish_date DESC, created_at DESC LIMIT $per_page OFFSET $offset";

// Execute update query
$update_result = mysqli_query($conn, $update_query);
$updates = [];
while($row = mysqli_fetch_assoc($update_result)) {
    $updates[] = $row;
}

// Execute count query for pagination
$count_result = mysqli_query($conn, $count_query);
$total_updates = mysqli_fetch_assoc($count_result)['total'];
$total_pages = ceil($total_updates / $per_page);

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

// Function to format date
function formatDate($date) {
    return date('M j, Y g:i A', strtotime($date));
}

// Function to get status badge class
function getStatusBadge($status) {
    switch ($status) {
        case 'published':
            return 'badge bg-success';
        case 'draft':
            return 'badge bg-warning';
        default:
            return 'badge bg-secondary';
    }
}

// Function to get type badge class
function getTypeBadge($type) {
    switch ($type) {
        case 'announcement':
            return 'badge bg-primary';
        case 'event':
            return 'badge bg-info';
        case 'news':
            return 'badge bg-secondary';
        case 'maintenance':
            return 'badge bg-warning';
        case 'alert':
            return 'badge bg-danger';
        case 'community':
            return 'badge bg-success';
        default:
            return 'badge bg-light text-dark';
    }
}

// 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;
}

// Function to truncate text
function truncateText($text, $length = 100) {
    if (strlen($text) <= $length) {
        return $text;
    }
    return substr($text, 0, $length) . '...';
}
?>

<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 Updates</h4>
                            <div class="page-title-right">
                                <a href="add-update.php" class="btn btn-primary">
                                    <i class="fas fa-plus me-2"></i>Add New Update
                                </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">
                                <h5 class="card-title mb-3">Filters</h5>
                                <form method="GET" action="manage-updates.php" class="row g-3">
                                    <div class="col-md-4">
                                        <label for="search" class="form-label">Search</label>
                                        <input type="text" class="form-control" id="search" name="search" 
                                               value="<?php echo htmlspecialchars($search); ?>" 
                                               placeholder="Search by title or content">
                                    </div>
                                    <div class="col-md-3">
                                        <label for="status" class="form-label">Status</label>
                                        <select class="form-select" id="status1" name="status">
                                            <option value="">All Status</option>
                                            <option value="published" <?php echo $status === 'published' ? 'selected' : ''; ?>>Published</option>
                                            <option value="draft" <?php echo $status === 'draft' ? 'selected' : ''; ?>>Draft</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label for="type" class="form-label">Type</label>
                                        <select class="form-select" id="type" name="type">
                                            <option value="">All Types</option>
                                            <?php foreach($update_types as $key => $value): ?>
                                                <option value="<?php echo $key; ?>" <?php echo $type == $key ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($value); ?>
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label d-block">&nbsp;</label>
                                        <button type="submit" class="btn btn-primary w-100">
                                            <i class="fas fa-filter me-1"></i> Filter
                                        </button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-3">
                                    <h4 class="card-title">Updates List</h4>
                                    <div class="text-muted">
                                        Total: <?php echo $total_updates; ?> updates
                                    </div>
                                </div>

<?php if(!empty($updates)): ?>
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#</th>
                                                    <th>Update Details</th>
                                                    <th>Type</th>
                                                    <th>Status</th>
                                                    <th>Publish Date</th>
                                                    <th>Created</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach($updates as $index => $update): 
                                                    $imagePath = getUpdateImagePath($update['featured_image']);
                                                ?>
                                                    <tr>
                                                        <td><?php echo $offset + $index + 1; ?></td>
                                                        <td>
                                                            <div class="d-flex align-items-start">
                                                                <?php if($imagePath): ?>
                                                                    <div class="flex-shrink-0 me-3">
                                                                        <img src="<?php echo $imagePath; ?>" 
                                                                             alt="<?php echo htmlspecialchars($update['title']); ?>" 
                                                                             class="rounded" width="60" height="60" style="object-fit: cover;">
                                                                    </div>
                                                                <?php endif; ?>
                                                                <div class="flex-grow-1">
                                                                    <h6 class="mb-1"><?php echo htmlspecialchars($update['title']); ?></h6>
                                                                    <p class="text-muted mb-0 small">
                                                                        <?php echo truncateText(htmlspecialchars($update['content']), 120); ?>
                                                                    </p>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <span class="<?php echo getTypeBadge($update['update_type']); ?>">
                                                                <?php echo ucfirst($update['update_type']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <span class="<?php echo getStatusBadge($update['status']); ?>">
                                                                <?php echo ucfirst($update['status']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <small class="text-muted">
                                                                <?php echo formatDate($update['publish_date']); ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <small class="text-muted">
                                                                <?php echo formatDate($update['created_at']); ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group">
                                                                <button type="button" class="btn btn-sm btn-light dropdown-toggle" 
                                                                        data-bs-toggle="dropdown" aria-expanded="false">
                                                                    Actions
                                                                </button>
                                                                <ul class="dropdown-menu">
                                                                    <li>
                                                                        <a class="dropdown-item" href="edit-update.php?id=<?php echo $update['id']; ?>">
                                                                            <i class="fas fa-edit me-2"></i>Edit
                                                                        </a>
                                                                    </li>
                                                                    <li><hr class="dropdown-divider"></li>
                                                                    <li>
                                                                        <a class="dropdown-item text-warning" 
                                                                           href="?action=toggle_status&id=<?php echo $update['id']; ?>&current_status=<?php echo $update['status']; ?>">
                                                                            <i class="fas fa-sync me-2"></i>
                                                                            <?php echo $update['status'] === 'published' ? 'Mark as Draft' : 'Publish'; ?>
                                                                        </a>
                                                                    </li>
                                                                    <li>
                                                                        <a class="dropdown-item text-danger" 
                                                                           href="#" 
                                                                           onclick="confirmDelete(<?php echo $update['id']; ?>, '<?php echo htmlspecialchars($update['title']); ?>')">
                                                                            <i class="fas fa-trash me-2"></i>Delete
                                                                        </a>
                                                                    </li>
                                                                </ul>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>

<?php if($total_pages > 1): ?>
                                    <div class="d-flex justify-content-between align-items-center mt-3">
                                        <div class="text-muted">
                                            Showing <?php echo count($updates); ?> of <?php echo $total_updates; ?> entries
                                        </div>
                                        <nav>
                                            <ul class="pagination pagination-rounded mb-0">
                                                
                                                <?php if($page > 1): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page - 1])); ?>" aria-label="Previous">
                                                            <span aria-hidden="true">&laquo;</span>
                                                        </a>
                                                    </li>
                                                <?php endif; ?>

<?php for($i = 1; $i <= $total_pages; $i++): ?>
                                                    <?php if($i == 1 || $i == $total_pages || ($i >= $page - 2 && $i <= $page + 2)): ?>
                                                        <li class="page-item <?php echo $i == $page ? 'active' : ''; ?>">
                                                            <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $i])); ?>">
                                                                <?php echo $i; ?>
                                                            </a>
                                                        </li>
                                                    <?php elseif($i == $page - 3 || $i == $page + 3): ?>
                                                        <li class="page-item disabled">
                                                            <span class="page-link">...</span>
                                                        </li>
                                                    <?php endif; ?>
                                                <?php endfor; ?>

<?php if($page < $total_pages): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page + 1])); ?>" aria-label="Next">
                                                            <span aria-hidden="true">&raquo;</span>
                                                        </a>
                                                    </li>
                                                <?php endif; ?>
                                            </ul>
                                        </nav>
                                    </div>
                                    <?php endif; ?>

<?php else: ?>
                                    <div class="text-center py-5">
                                        <div class="mb-4">
                                            <i class="fas fa-newspaper display-1 text-muted"></i>
                                        </div>
                                        <h4 class="text-muted">No Updates Found</h4>
                                        <p class="text-muted mb-4">
                                            <?php if(!empty($search) || !empty($status) || !empty($type)): ?>
                                                No updates match your current filters.
                                            <?php else: ?>
                                                No updates have been created yet.
                                            <?php endif; ?>
                                        </p>
                                        <a href="add-update.php" class="btn btn-primary">
                                            <i class="fas fa-plus me-2"></i>Add Your First Update
                                        </a>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>


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


<?php include('includes/scripts.php')?>
<script>
function confirmDelete(updateId, updateTitle) {
    if (confirm('Are you sure you want to delete "' + updateTitle + '"? This action cannot be undone.')) {
        window.location.href = '?action=delete&id=' + updateId;
    }
}

// Auto-submit form when filters change (optional)
document.addEventListener('DOMContentLoaded', function() {
    const statusFilter = document.getElementById('status');
    const typeFilter = document.getElementById('type');
    
    if (statusFilter) {
        statusFilter.addEventListener('change', function() {
            if (this.value) {
                this.form.submit();
            }
        });
    }
    
    if (typeFilter) {
        typeFilter.addEventListener('change', function() {
            if (this.value) {
                this.form.submit();
            }
        });
    }
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-news.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation