Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u530111037

Directory:

/home/u530111037/domains/goodcharacteropc.com/public_html/admin

Free Space:

3.34 TB

🔧 Quick Actions

✏️ Editing: advisory.php

<?php
require_once __DIR__.'/../db.php';
require_once './../header.php';
require_admin();

// ── UPLOAD DIR ──────────────────────────────────────
$upload_dir = $_SERVER['DOCUMENT_ROOT'] . '/uploads/advisory/';
if (!is_dir($upload_dir)) mkdir($upload_dir, 0755, true);

$success = '';
$error   = '';

// ── DELETE ──────────────────────────────────────────
if (isset($_GET['delete'])) {
    $del_id = (int)$_GET['delete'];
    $row = $mysqli->query("SELECT image FROM advisory_board WHERE id=$del_id")->fetch_assoc();
    if ($row) {
        $img_path = $upload_dir . $row['image'];
        if ($row['image'] && file_exists($img_path)) unlink($img_path);
        $mysqli->query("DELETE FROM advisory_board WHERE id=$del_id");
        $success = 'Member deleted successfully.';
    }
}

// ── ADD ─────────────────────────────────────────────
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'add') {
    $name        = trim($mysqli->real_escape_string($_POST['name']));
    $designation = trim($mysqli->real_escape_string($_POST['designation']));
    $description = trim($mysqli->real_escape_string($_POST['description']));
    $order       = (int)($_POST['display_order'] ?? 0);
    $image_name  = '';

// Image: file upload takes priority over URL
    if (!empty($_FILES['image']['name'])) {
        $ext        = strtolower(pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION));
        $allowed    = ['jpg','jpeg','png','webp'];
        if (!in_array($ext, $allowed)) {
            $error = 'Invalid image type. Allowed: jpg, jpeg, png, webp.';
        } elseif ($_FILES['image']['size'] > 2 * 1024 * 1024) {
            $error = 'Image too large. Max 2MB.';
        } else {
            $image_name = 'adv_' . time() . '_' . rand(100,999) . '.' . $ext;
            move_uploaded_file($_FILES['image']['tmp_name'], $upload_dir . $image_name);
        }
    } elseif (!empty($_POST['image_url'])) {
        $image_name = trim($mysqli->real_escape_string($_POST['image_url']));
    }

if (!$error) {
        if (!$name || !$designation || !$description) {
            $error = 'Name, Designation and Description are required.';
        } else {
            $mysqli->query("INSERT INTO advisory_board (name, designation, description, image, display_order, status)
                            VALUES ('$name','$designation','$description','$image_name',$order,'active')");
            $success = 'Member added successfully.';
        }
    }
}

// ── EDIT ─────────────────────────────────────────────
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'edit') {
    $edit_id     = (int)$_POST['edit_id'];
    $name        = trim($mysqli->real_escape_string($_POST['name']));
    $designation = trim($mysqli->real_escape_string($_POST['designation']));
    $description = trim($mysqli->real_escape_string($_POST['description']));
    $order       = (int)($_POST['display_order'] ?? 0);
    $image_name  = trim($mysqli->real_escape_string($_POST['existing_image']));

if (!empty($_FILES['image']['name'])) {
        $ext     = strtolower(pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION));
        $allowed = ['jpg','jpeg','png','webp'];
        if (!in_array($ext, $allowed)) {
            $error = 'Invalid image type. Allowed: jpg, jpeg, png, webp.';
        } elseif ($_FILES['image']['size'] > 2 * 1024 * 1024) {
            $error = 'Image too large. Max 2MB.';
        } else {
            // delete old file if it was an uploaded file (not a URL)
            if ($image_name && !filter_var($image_name, FILTER_VALIDATE_URL) && file_exists($upload_dir . $image_name)) {
                unlink($upload_dir . $image_name);
            }
            $image_name = 'adv_' . time() . '_' . rand(100,999) . '.' . $ext;
            move_uploaded_file($_FILES['image']['tmp_name'], $upload_dir . $image_name);
        }
    } elseif (!empty($_POST['image_url'])) {
        $image_name = trim($mysqli->real_escape_string($_POST['image_url']));
    }

if (!$error) {
        $mysqli->query("UPDATE advisory_board 
                        SET name='$name', designation='$designation', description='$description',
                            image='$image_name', display_order=$order
                        WHERE id=$edit_id");
        $success = 'Member updated successfully.';
    }
}

// ── FETCH ALL ────────────────────────────────────────
$members = $mysqli->query("SELECT * FROM advisory_board ORDER BY display_order ASC, created_at DESC")->fetch_all(MYSQLI_ASSOC);

// ── FETCH SINGLE FOR EDIT MODAL ──────────────────────
$edit_row = null;
if (isset($_GET['edit'])) {
    $edit_id  = (int)$_GET['edit'];
    $edit_row = $mysqli->query("SELECT * FROM advisory_board WHERE id=$edit_id")->fetch_assoc();
}
?>

<div class="container-fluid py-4">

<?php if ($success): ?>
    <div class="alert alert-success alert-dismissible fade show" role="alert">
      <?= htmlspecialchars($success) ?>
      <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
    </div>
  <?php endif; ?>
  <?php if ($error): ?>
    <div class="alert alert-danger alert-dismissible fade show" role="alert">
      <?= htmlspecialchars($error) ?>
      <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
    </div>
  <?php endif; ?>

<div class="d-flex justify-content-between align-items-center mb-3">
    <h5 class="mb-0 fw-bold">Advisory Board Members</h5>
    <button class="btn btn-sm btn-primary" data-bs-toggle="modal" data-bs-target="#addModal">
      + Add Member
    </button>
  </div>

<div class="card shadow-sm">
    <div class="table-responsive">
      <table class="table table-hover align-middle mb-0" style="font-size:14px;">
        <thead class="table-dark">
          <tr>
            <th>#</th>
            <th>Image</th>
            <th>Name</th>
            <th>Designation</th>
            <th>Description</th>
            <th>Order</th>
            <th>Status</th>
            <th>Actions</th>
          </tr>
        </thead>
        <tbody>
          <?php if (empty($members)): ?>
            <tr><td colspan="8" class="text-center text-muted py-4">No members added yet.</td></tr>
          <?php else: ?>
            <?php foreach ($members as $i => $m): ?>
              <tr>
                <td><?= $i + 1 ?></td>
                <td>
                  <?php
                    $src = '';
                    if ($m['image']) {
                      if (filter_var($m['image'], FILTER_VALIDATE_URL)) {
                        $src = $m['image'];
                      } else {
                        $src = (strpos($m['image'], 'http') === 0) ? htmlspecialchars($m['image']) : $base_url . 'uploads/advisory/' . htmlspecialchars($m['image']);
                      }
                    } else {
                      $src = 'https://cdn-icons-png.flaticon.com/512/3135/3135715.png';
                    }
                  ?>
                  <img src="<?= $src ?>" 
                       style="width:52px; height:52px; object-fit:cover; border-radius:8px; border:1px solid #eee;">
                </td>
                <td><?= htmlspecialchars($m['name']) ?></td>
                <td><span style="color:#d3ad68; font-weight:600"><?= htmlspecialchars($m['designation']) ?></span></td>
                <td style="max-width:260px;">
                  <span style="display:-webkit-box;-webkit-line-clamp:2;-webkit-box-orient:vertical;overflow:hidden;">
                    <?= htmlspecialchars($m['description']) ?>
                  </span>
                </td>
                <td class="text-center"><?= (int)$m['display_order'] ?></td>
                <td>
                  <span class="badge <?= $m['status'] === 'active' ? 'bg-success' : 'bg-secondary' ?>">
                    <?= ucfirst($m['status']) ?>
                  </span>
                </td>
                <td>
                  <a href="advisory.php?edit=<?= $m['id'] ?>" class="btn btn-sm btn-outline-primary me-1">Edit</a>
                  <a href="advisory.php?delete=<?= $m['id'] ?>" 
                     class="btn btn-sm btn-outline-danger"
                     onclick="return confirm('Delete <?= htmlspecialchars(addslashes($m['name'])) ?>?')">Delete</a>
                </td>
              </tr>
            <?php endforeach; ?>
          <?php endif; ?>
        </tbody>
      </table>
    </div>
  </div>
</div>

<div class="modal fade" id="addModal" tabindex="-1">
  <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <form method="POST" enctype="multipart/form-data">
        <input type="hidden" name="action" value="add">
        <div class="modal-header">
          <h5 class="modal-title">Add Advisory Member</h5>
          <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
        </div>
        <div class="modal-body">
          <div class="row g-3">

<div class="col-md-6">
              <label class="form-label fw-semibold">Designation <span class="text-danger">*</span></label>
              <input type="text" name="designation" class="form-control" required maxlength="150" placeholder="e.g. Professor, IIT Mumbai">
            </div>

<div class="col-12">
              <label class="form-label fw-semibold">Description <span class="text-danger">*</span>
                <small class="text-muted fw-normal">(~50 words max)</small>
              </label>
              <textarea name="description" class="form-control" rows="3" required maxlength="300" 
                        id="addDesc" oninput="countWords('addDesc','addWordCount')"></textarea>
              <div class="form-text">Words: <span id="addWordCount">0</span> / ~50</div>
            </div>

<div class="col-md-6">
              <label class="form-label fw-semibold">Upload Image</label>
              <input type="file" name="image" class="form-control" accept=".jpg,.jpeg,.png,.webp"
                     onchange="previewImage(this,'addPreview')">
              <div class="form-text">JPG/PNG/WEBP, max 2MB</div>
            </div>

<div class="col-md-6">
              <label class="form-label fw-semibold">— or — Image URL</label>
              <input type="url" name="image_url" class="form-control" placeholder="https://example.com/photo.jpg"
                     oninput="previewUrl(this,'addPreview')">
              <div class="form-text">Leave blank if uploading a file</div>
            </div>

<div class="col-md-4">
              <label class="form-label fw-semibold">Display Order</label>
              <input type="number" name="display_order" class="form-control" value="0" min="0">
              <div class="form-text">Lower number shows first</div>
            </div>

</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 Member</button>
        </div>
      </form>
    </div>
  </div>
</div>

<?php if ($edit_row): ?>
<div class="modal fade" id="editModal" tabindex="-1">
  <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <form method="POST" enctype="multipart/form-data">
        <input type="hidden" name="action" value="edit">
        <input type="hidden" name="edit_id" value="<?= $edit_row['id'] ?>">
        <input type="hidden" name="existing_image" value="<?= htmlspecialchars($edit_row['image']) ?>">
        <div class="modal-header">
          <h5 class="modal-title">Edit Advisory Member</h5>
          <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
        </div>
        <div class="modal-body">
          <div class="row g-3">

<div class="col-md-6">
              <label class="form-label fw-semibold">Designation <span class="text-danger">*</span></label>
              <input type="text" name="designation" class="form-control" required maxlength="150"
                     value="<?= htmlspecialchars($edit_row['designation']) ?>">
            </div>

<div class="col-12">
              <label class="form-label fw-semibold">Description <span class="text-danger">*</span>
                <small class="text-muted fw-normal">(~50 words max)</small>
              </label>
              <textarea name="description" class="form-control" rows="3" required maxlength="300"
                        id="editDesc" oninput="countWords('editDesc','editWordCount')"><?= htmlspecialchars($edit_row['description']) ?></textarea>
              <div class="form-text">Words: <span id="editWordCount">0</span> / ~50</div>
            </div>

<div class="col-md-6">
              <label class="form-label fw-semibold">Upload New Image</label>
              <input type="file" name="image" class="form-control" accept=".jpg,.jpeg,.png,.webp"
                     onchange="previewImage(this,'editPreview')">
              <div class="form-text">Leave blank to keep existing image</div>
            </div>

<div class="col-md-6">
              <label class="form-label fw-semibold">— or — Image URL</label>
              <input type="url" name="image_url" class="form-control" placeholder="https://example.com/photo.jpg"
                     value="<?= filter_var($edit_row['image'], FILTER_VALIDATE_URL) ? htmlspecialchars($edit_row['image']) : '' ?>"
                     oninput="previewUrl(this,'editPreview')">
            </div>

<div class="col-12 text-center">
              <?php
                $edit_src = '';
                if ($edit_row['image']) {
                  if (filter_var($edit_row['image'], FILTER_VALIDATE_URL)) {
                    $edit_src = $edit_row['image'];
                  } else {
                    $edit_src = $base_url . 'uploads/advisory/' . htmlspecialchars($edit_row['image']);
                  }
                } else {
                  $edit_src = 'https://cdn-icons-png.flaticon.com/512/3135/3135715.png';
                }
              ?>
              <img id="editPreview" src="<?= $edit_src ?>"
                   style="width:100px; height:100px; object-fit:cover; border-radius:10px; border:1px solid #eee;" alt="Preview">
            </div>

<div class="col-md-4">
              <label class="form-label fw-semibold">Display Order</label>
              <input type="number" name="display_order" class="form-control" min="0"
                     value="<?= (int)$edit_row['display_order'] ?>">
            </div>

</div>
        </div>
        <div class="modal-footer">
          <a href="advisory.php" class="btn btn-secondary">Cancel</a>
          <button type="submit" class="btn btn-primary">Save Changes</button>
        </div>
      </form>
    </div>
  </div>
</div>

<script>
  document.addEventListener('DOMContentLoaded', function(){
    var modal = new bootstrap.Modal(document.getElementById('editModal'));
    modal.show();
    // count words for existing content
    countWords('editDesc','editWordCount');
  });
</script>
<?php endif; ?>

<script>
function previewImage(input, previewId) {
  const preview = document.getElementById(previewId);
  const file = input.files[0];
  if (file) {
    const reader = new FileReader();
    reader.onload = e => { preview.src = e.target.result; preview.style.display = 'block'; };
    reader.readAsDataURL(file);
  }
}

function previewUrl(input, previewId) {
  const preview = document.getElementById(previewId);
  if (input.value) {
    preview.src = input.value;
    preview.style.display = 'block';
  }
}

function countWords(textareaId, counterId) {
  const val = document.getElementById(textareaId).value.trim();
  const count = val === '' ? 0 : val.split(/\s+/).length;
  const counter = document.getElementById(counterId);
  counter.textContent = count;
  counter.style.color = count > 55 ? 'red' : 'inherit';
}
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: advisory.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation