Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.16.1.el9_7.x86_64

PHP Version:

8.2.30

User:

u226437350

Directory:

/home/u226437350/domains/maharshiwomensdegreecollege.com/public_html/clg

Free Space:

8.36 TB

🔧 Quick Actions

✏️ Editing: gallery_admin.php

<?php
// ============================================
// gallery_admin.php — Admin Upload Panel
// Maharshi Women's Degree College
// ============================================
session_start();

// ── Auth Guard ───────────────────────────────────────────────────────────────
if (!isset($_SESSION['gallery_admin']) || $_SESSION['gallery_admin'] !== true) {
    header('Location: gallery_login.php');
    exit;
}

// ── Logout ───────────────────────────────────────────────────────────────────
if (isset($_GET['logout'])) {
    session_destroy();
    header('Location: gallery_login.php');
    exit;
}

require_once 'db_config.php';
$db = getDB();
$message = '';
$msg_type = '';

// ── Handle: Create New Section ──────────────────────────────────────────────
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {

if ($_POST['action'] === 'create_section') {
        $name = trim($db->real_escape_string($_POST['section_name']));
        $desc = trim($db->real_escape_string($_POST['section_desc'] ?? ''));
        $slug = strtolower(preg_replace('/[^a-z0-9]+/i', '-', $name));
        // Ensure unique slug
        $check = $db->query("SELECT id FROM gallery_sections WHERE slug='$slug'");
        if ($check->num_rows > 0) $slug .= '-' . time();

if ($name) {
            $db->query("INSERT INTO gallery_sections (name, slug, description) VALUES ('$name','$slug','$desc')");
            $message = "Section <strong>$name</strong> created successfully!";
            $msg_type = 'success';
        } else {
            $message = 'Section name cannot be empty.';
            $msg_type = 'error';
        }
    }

// ── Handle: Upload Images ─────────────────────────────────────────────
    elseif ($_POST['action'] === 'upload_images') {
        $section_id = (int)$_POST['section_id'];
        $img_title  = trim($db->real_escape_string($_POST['img_title'] ?? ''));
        $uploaded = 0;
        $errors   = [];

if (!empty($_FILES['images']['name'][0])) {
            $allowed = ['image/jpeg','image/png','image/gif','image/webp'];
            foreach ($_FILES['images']['tmp_name'] as $i => $tmp) {
                $orig     = $_FILES['images']['name'][$i];
                $mime     = mime_content_type($tmp);
                $size     = $_FILES['images']['size'][$i];

if (!in_array($mime, $allowed)) { $errors[] = "$orig: Invalid type."; continue; }
                if ($size > 5 * 1024 * 1024)    { $errors[] = "$orig: Exceeds 5MB.";  continue; }

$ext      = pathinfo($orig, PATHINFO_EXTENSION);
                $filename = uniqid('img_', true) . '.' . strtolower($ext);
                $dest     = UPLOAD_DIR . $filename;

if (move_uploaded_file($tmp, $dest)) {
                    $orig_esc = $db->real_escape_string($orig);
                    $fn_esc   = $db->real_escape_string($filename);
                    $t_esc    = $db->real_escape_string($img_title);
                    $db->query("INSERT INTO gallery_images (section_id, title, filename, original_name, file_size)
                                VALUES ($section_id, '$t_esc', '$fn_esc', '$orig_esc', $size)");
                    // Set cover if first image in section
                    $cover = $db->query("SELECT cover_image FROM gallery_sections WHERE id=$section_id")->fetch_assoc();
                    if (empty($cover['cover_image'])) {
                        $db->query("UPDATE gallery_sections SET cover_image='$fn_esc' WHERE id=$section_id");
                    }
                    $uploaded++;
                } else {
                    $errors[] = "$orig: Upload failed.";
                }
            }
            $message = "$uploaded image(s) uploaded successfully" . ($errors ? ' with errors: ' . implode(', ', $errors) : '!');
            $msg_type = $errors ? 'warning' : 'success';
        } else {
            $message  = 'No files selected.';
            $msg_type = 'error';
        }
    }

// ── Handle: Delete Image ──────────────────────────────────────────────
    elseif ($_POST['action'] === 'delete_image') {
        $img_id = (int)$_POST['img_id'];
        $row = $db->query("SELECT filename FROM gallery_images WHERE id=$img_id")->fetch_assoc();
        if ($row) {
            @unlink(UPLOAD_DIR . $row['filename']);
            $db->query("DELETE FROM gallery_images WHERE id=$img_id");
            $message  = 'Image deleted.';
            $msg_type = 'success';
        }
    }

// ── Handle: Delete Section ────────────────────────────────────────────
    elseif ($_POST['action'] === 'delete_section') {
        $sec_id = (int)$_POST['sec_id'];
        $imgs = $db->query("SELECT filename FROM gallery_images WHERE section_id=$sec_id");
        while ($r = $imgs->fetch_assoc()) @unlink(UPLOAD_DIR . $r['filename']);
        $db->query("DELETE FROM gallery_sections WHERE id=$sec_id");
        $message  = 'Section and all its images deleted.';
        $msg_type = 'success';
    }
}

// ── Fetch Data ───────────────────────────────────────────────────────────────
$sections = $db->query("SELECT s.*, COUNT(i.id) AS img_count
    FROM gallery_sections s
    LEFT JOIN gallery_images i ON i.section_id = s.id
    GROUP BY s.id ORDER BY s.created_at DESC");

$active_sec = isset($_GET['sec']) ? (int)$_GET['sec'] : 0;
$images = [];
if ($active_sec) {
    $res = $db->query("SELECT * FROM gallery_images WHERE section_id=$active_sec ORDER BY uploaded_at DESC");
    while ($r = $res->fetch_assoc()) $images[] = $r;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Gallery Admin — Maharshi Women's Degree College</title>
<link href="https://fonts.googleapis.com/css2?family=Playfair+Display:wght@600;700&family=DM+Sans:wght@300;400;500;600&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
<style>
:root{
  --saffron:#FF671F;
  --navy:#003087;
  --gold:#C8962A;
  --cream:#FFF8F0;
  --white:#FFFFFF;
  --text:#1A1A2E;
  --muted:#6B7280;
  --border:#E5E7EB;
  --success:#16A34A;
  --error:#DC2626;
  --warning:#D97706;
  --radius:12px;
  --shadow:0 4px 24px rgba(0,0,0,0.08);
}
*{box-sizing:border-box;margin:0;padding:0}
body{font-family:'DM Sans',sans-serif;background:#F3F4F8;color:var(--text);min-height:100vh}

/* ─── HEADER ─── */
.admin-header{background:linear-gradient(135deg,var(--navy) 0%,#001A5C 100%);color:#fff;padding:18px 32px;display:flex;align-items:center;gap:16px;box-shadow:0 2px 16px rgba(0,48,135,0.3)}
.admin-header .brand{font-family:'Playfair Display',serif;font-size:1.4rem;line-height:1.2}
.admin-header .brand span{display:block;font-family:'DM Sans',sans-serif;font-size:.75rem;font-weight:300;opacity:.75;letter-spacing:1px;text-transform:uppercase}
.admin-header a.view-btn{margin-left:auto;background:var(--saffron);color:#fff;padding:8px 20px;border-radius:8px;text-decoration:none;font-size:.85rem;font-weight:600;transition:.2s}
.admin-header a.view-btn:hover{background:#e55a15}

/* ─── LAYOUT ─── */
.admin-wrap{display:grid;grid-template-columns:300px 1fr;gap:0;min-height:calc(100vh - 70px)}

/* ─── SIDEBAR ─── */
.sidebar{background:#fff;border-right:1px solid var(--border);padding:24px 0;overflow-y:auto}
.sidebar-title{padding:0 20px 14px;font-size:.7rem;font-weight:600;letter-spacing:1.5px;text-transform:uppercase;color:var(--muted);border-bottom:1px solid var(--border);margin-bottom:8px}
.sec-item{display:flex;align-items:center;gap:10px;padding:12px 20px;cursor:pointer;transition:.15s;border-left:3px solid transparent;text-decoration:none;color:var(--text)}
.sec-item:hover{background:#F9FAFB;border-left-color:var(--saffron)}
.sec-item.active{background:#FFF4ED;border-left-color:var(--saffron);color:var(--saffron)}
.sec-item .sec-name{font-weight:500;font-size:.9rem;flex:1}
.sec-item .badge{background:#E5E7EB;color:var(--muted);font-size:.7rem;padding:2px 7px;border-radius:20px;font-weight:600}
.sec-item.active .badge{background:var(--saffron);color:#fff}
.sec-cover{width:36px;height:36px;border-radius:6px;object-fit:cover;background:#F3F4F8;flex-shrink:0}
.sec-cover-placeholder{width:36px;height:36px;border-radius:6px;background:#F3F4F8;display:flex;align-items:center;justify-content:center;color:var(--border);font-size:1rem;flex-shrink:0}

/* ─── MAIN ─── */
.main-panel{padding:28px 32px;overflow-y:auto}
.panel-head{display:flex;align-items:center;justify-content:space-between;margin-bottom:24px;flex-wrap:wrap;gap:12px}
.panel-head h2{font-family:'Playfair Display',serif;font-size:1.6rem;color:var(--navy)}

/* ─── CARDS ─── */
.card{background:#fff;border-radius:var(--radius);box-shadow:var(--shadow);padding:24px;margin-bottom:20px}
.card h3{font-family:'Playfair Display',serif;font-size:1.1rem;color:var(--navy);margin-bottom:16px;display:flex;align-items:center;gap:8px}
.card h3 i{color:var(--saffron);font-size:.9rem}

/* ─── FORMS ─── */
.form-row{display:grid;grid-template-columns:1fr 1fr;gap:16px}
@media(max-width:600px){.form-row{grid-template-columns:1fr}}
.form-group{display:flex;flex-direction:column;gap:6px;margin-bottom:14px}
.form-group label{font-size:.8rem;font-weight:600;color:var(--muted);text-transform:uppercase;letter-spacing:.5px}
.form-group input,.form-group textarea,.form-group select{padding:10px 14px;border:1.5px solid var(--border);border-radius:8px;font-family:'DM Sans',sans-serif;font-size:.9rem;color:var(--text);transition:.2s;background:#fff}
.form-group input:focus,.form-group textarea:focus,.form-group select:focus{outline:none;border-color:var(--navy);box-shadow:0 0 0 3px rgba(0,48,135,0.08)}
.form-group textarea{resize:vertical;min-height:80px}

/* ─── FILE DROP ─── */
.file-drop{border:2px dashed var(--border);border-radius:10px;padding:32px;text-align:center;transition:.2s;cursor:pointer;position:relative}
.file-drop:hover,.file-drop.drag{border-color:var(--saffron);background:#FFF4ED}
.file-drop input[type=file]{position:absolute;inset:0;opacity:0;cursor:pointer;width:100%;height:100%}
.file-drop i{font-size:2.2rem;color:var(--border);margin-bottom:10px;display:block}
.file-drop p{color:var(--muted);font-size:.9rem}
.file-drop .hint{font-size:.75rem;margin-top:4px;color:#9CA3AF}
#file-preview{display:flex;flex-wrap:wrap;gap:8px;margin-top:12px}
#file-preview .prev-item{position:relative;width:70px;height:70px;border-radius:8px;overflow:hidden;border:1.5px solid var(--border)}
#file-preview .prev-item img{width:100%;height:100%;object-fit:cover}
#file-preview .prev-count{width:70px;height:70px;border-radius:8px;background:#F3F4F8;display:flex;align-items:center;justify-content:center;font-size:.85rem;font-weight:600;color:var(--muted);border:1.5px dashed var(--border)}

/* ─── BUTTONS ─── */
.btn{display:inline-flex;align-items:center;gap:8px;padding:10px 22px;border-radius:8px;font-family:'DM Sans',sans-serif;font-weight:600;font-size:.88rem;cursor:pointer;border:none;transition:.2s;text-decoration:none}
.btn-primary{background:var(--navy);color:#fff}
.btn-primary:hover{background:#002070}
.btn-saffron{background:var(--saffron);color:#fff}
.btn-saffron:hover{background:#e55a15}
.btn-danger{background:#FEE2E2;color:var(--error);border:1.5px solid #FECACA}
.btn-danger:hover{background:var(--error);color:#fff}
.btn-sm{padding:6px 14px;font-size:.78rem}

/* ─── MESSAGE ─── */
.msg{padding:12px 18px;border-radius:8px;margin-bottom:20px;font-size:.9rem;display:flex;align-items:center;gap:10px;font-weight:500}
.msg.success{background:#DCFCE7;color:#15803D;border:1px solid #BBF7D0}
.msg.error{background:#FEE2E2;color:var(--error);border:1px solid #FECACA}
.msg.warning{background:#FEF3C7;color:#92400E;border:1px solid #FDE68A}

/* ─── IMAGE GRID ─── */
.img-grid{display:grid;grid-template-columns:repeat(auto-fill,minmax(160px,1fr));gap:14px;margin-top:16px}
.img-card{position:relative;border-radius:10px;overflow:hidden;background:#F3F4F8;box-shadow:0 2px 8px rgba(0,0,0,0.06);aspect-ratio:1;group:true}
.img-card img{width:100%;height:100%;object-fit:cover;display:block;transition:.3s}
.img-card:hover img{transform:scale(1.05)}
.img-card .overlay{position:absolute;inset:0;background:linear-gradient(to top,rgba(0,0,0,0.7) 0%,transparent 55%);opacity:0;transition:.3s;display:flex;align-items:flex-end;padding:10px}
.img-card:hover .overlay{opacity:1}
.img-card .img-title{color:#fff;font-size:.75rem;font-weight:500;flex:1;overflow:hidden;text-overflow:ellipsis;white-space:nowrap}
.img-card .del-btn{background:var(--error);color:#fff;border:none;border-radius:6px;padding:4px 8px;font-size:.7rem;cursor:pointer;flex-shrink:0}
.img-card .del-btn:hover{background:#B91C1C}
.img-card .date-badge{position:absolute;top:8px;right:8px;background:rgba(0,0,0,0.55);color:#fff;font-size:.65rem;padding:2px 7px;border-radius:20px;backdrop-filter:blur(4px)}
.empty-state{text-align:center;padding:48px 20px;color:var(--muted)}
.empty-state i{font-size:3rem;margin-bottom:12px;display:block;color:#D1D5DB}
.empty-state p{font-size:.9rem}

/* ─── SECTION DELETE ─── */
.del-sec-btn{font-size:.75rem;padding:5px 12px}

/* ─── RESPONSIVE ─── */
@media(max-width:768px){
  .admin-wrap{grid-template-columns:1fr}
  .sidebar{border-right:none;border-bottom:1px solid var(--border)}
  .main-panel{padding:20px 16px}
}
</style>
</head>
<body>

<div class="admin-header">
  <i class="fas fa-images" style="font-size:1.5rem;color:var(--saffron)"></i>
  <div class="brand">
    Gallery Admin Panel
    <span>Maharshi Women's Degree College, Bhubaneswar</span>
  </div>
  <div style="margin-left:auto;display:flex;align-items:center;gap:12px">
    <span style="font-size:.78rem;opacity:.6;display:flex;align-items:center;gap:6px">
      <i class="fas fa-user-circle"></i> <?= htmlspecialchars($_SESSION['admin_user'] ?? 'Admin') ?>
    </span>
    <a href="gallery.php" class="view-btn" style="margin-left:0"><i class="fas fa-eye"></i> View Gallery</a>
    <a href="gallery_admin.php?logout=1" class="view-btn" style="background:#c0392b" onclick="return confirm('Logout?')"><i class="fas fa-sign-out-alt"></i> Logout</a>
  </div>
</div>

<aside class="sidebar">
    <div class="sidebar-title">Gallery Sections</div>
    <?php
    $sections->data_seek(0);
    while ($s = $sections->fetch_assoc()):
      $is_active = ($active_sec == $s['id']);
    ?>
    <a href="?sec=<?= $s['id'] ?>" class="sec-item <?= $is_active ? 'active' : '' ?>">
      <?php if ($s['cover_image']): ?>
        <img src="<?= UPLOAD_URL . htmlspecialchars($s['cover_image']) ?>" class="sec-cover" alt="">
      <?php else: ?>
        <div class="sec-cover-placeholder"><i class="fas fa-folder"></i></div>
      <?php endif; ?>
      <span class="sec-name"><?= htmlspecialchars($s['name']) ?></span>
      <span class="badge"><?= $s['img_count'] ?></span>
    </a>
    <?php endwhile; ?>
  </aside>

<main class="main-panel">

<?php if ($message): ?>
    <div class="msg <?= $msg_type ?>">
      <i class="fas fa-<?= $msg_type==='success'?'check-circle':($msg_type==='error'?'times-circle':'exclamation-triangle') ?>"></i>
      <?= $message ?>
    </div>
    <?php endif; ?>

<div class="panel-head">
      <h2><?= $active_sec ? htmlspecialchars($db->query("SELECT name FROM gallery_sections WHERE id=$active_sec")->fetch_assoc()['name'] ?? 'Gallery') : 'Gallery Management' ?></h2>
    </div>

<div class="card">
      <h3><i class="fas fa-plus-circle"></i> Create New Section</h3>
      <form method="POST">
        <input type="hidden" name="action" value="create_section">
        <div class="form-row">
          <div class="form-group">
            <label>Section Name *</label>
            <input type="text" name="section_name" placeholder="e.g. Farewell Party 2024" required>
          </div>
          <div class="form-group">
            <label>Description</label>
            <input type="text" name="section_desc" placeholder="Brief description (optional)">
          </div>
        </div>
        <button type="submit" class="btn btn-primary"><i class="fas fa-plus"></i> Create Section</button>
      </form>
    </div>

<div class="card">
      <h3><i class="fas fa-cloud-upload-alt"></i> Upload Images</h3>
      <form method="POST" enctype="multipart/form-data" id="uploadForm">
        <input type="hidden" name="action" value="upload_images">
        <div class="form-row">
          <div class="form-group">
            <label>Select Section *</label>
            <select name="section_id" required>
              <option value="">— Choose Section —</option>
              <?php
              $sections->data_seek(0);
              while ($s = $sections->fetch_assoc()):
              ?>
              <option value="<?= $s['id'] ?>" <?= ($active_sec==$s['id'])?'selected':'' ?>>
                <?= htmlspecialchars($s['name']) ?> (<?= $s['img_count'] ?> photos)
              </option>
              <?php endwhile; ?>
            </select>
          </div>
          <div class="form-group">
            <label>Image Title / Caption</label>
            <input type="text" name="img_title" placeholder="e.g. Flag Hoisting Ceremony">
          </div>
        </div>
        <div class="form-group">
          <label>Choose Images (JPG, PNG, GIF, WEBP — max 5MB each)</label>
          <div class="file-drop" id="fileDrop">
            <input type="file" name="images[]" id="fileInput" multiple accept="image/*">
            <i class="fas fa-cloud-upload-alt"></i>
            <p>Drag & drop images here or <strong>click to browse</strong></p>
            <p class="hint">You can select multiple images at once</p>
          </div>
          <div id="file-preview"></div>
        </div>
        <button type="submit" class="btn btn-saffron"><i class="fas fa-upload"></i> Upload Images</button>
      </form>
    </div>

<?php if ($active_sec): ?>
    <div class="card">
      <h3 style="justify-content:space-between">
        <span><i class="fas fa-th"></i> Images in This Section</span>
        <form method="POST" style="margin:0" onsubmit="return confirm('Delete this ENTIRE section and all its images?')">
          <input type="hidden" name="action" value="delete_section">
          <input type="hidden" name="sec_id" value="<?= $active_sec ?>">
          <button type="submit" class="btn btn-danger btn-sm del-sec-btn"><i class="fas fa-trash-alt"></i> Delete Section</button>
        </form>
      </h3>

<?php if (empty($images)): ?>
      <div class="empty-state">
        <i class="fas fa-images"></i>
        <p>No images uploaded yet. Use the form above to add photos.</p>
      </div>
      <?php else: ?>
      <div class="img-grid">
        <?php foreach ($images as $img): ?>
        <div class="img-card">
          <img src="<?= UPLOAD_URL . htmlspecialchars($img['filename']) ?>" alt="<?= htmlspecialchars($img['title'] ?? '') ?>" loading="lazy">
          <div class="date-badge"><?= date('d M Y', strtotime($img['uploaded_at'])) ?></div>
          <div class="overlay">
            <span class="img-title"><?= htmlspecialchars($img['title'] ?: $img['original_name']) ?></span>
            <form method="POST" onsubmit="return confirm('Delete this image?')">
              <input type="hidden" name="action" value="delete_image">
              <input type="hidden" name="img_id" value="<?= $img['id'] ?>">
              <button type="submit" class="del-btn"><i class="fas fa-trash"></i></button>
            </form>
          </div>
        </div>
        <?php endforeach; ?>
      </div>
      <?php endif; ?>
    </div>
    <?php else: ?>
    <div class="card">
      <div class="empty-state">
        <i class="fas fa-hand-point-left"></i>
        <p>Select a section from the sidebar to view and manage its images.</p>
      </div>
    </div>
    <?php endif; ?>

</main>
</div>

fileInput.addEventListener('change', showPreviews);

['dragenter','dragover'].forEach(e => fileDrop.addEventListener(e, ev => { ev.preventDefault(); fileDrop.classList.add('drag'); }));
['dragleave','drop'].forEach(e => fileDrop.addEventListener(e, ev => { ev.preventDefault(); fileDrop.classList.remove('drag'); }));

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: gallery_admin.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation