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: schools.php

<?php
require_once __DIR__ . '/../db.php';
require_once './../header.php';

require_admin();

$view = $_GET['view'] ?? 'list';

// Create
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['create'])) {
    $stmt = $mysqli->prepare("INSERT INTO schools(name, city) VALUES(?, ?)");
    $stmt->bind_param("ss", $_POST['name'], $_POST['city']);
    $stmt->execute();

echo "<script>alert('School created successfully!');</script>";
    echo "<script>location.href = '${base_url}admin/schools.php';</script>";
    exit;
}

// Update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update'])) {
    $id = $_POST['id'];
    $stmt = $mysqli->prepare("UPDATE schools SET name=?, city=? WHERE id=?");
    $stmt->bind_param("ssi", $_POST['name'], $_POST['city'], $_POST['id']);
    $stmt->execute();

echo "<script>alert('Record updated successfully!');</script>";
    echo "<script>location.href = '${base_url}admin/schools.php?view=view&id=$id';</script>";
    exit;
}

// Delete
if (isset($_GET['del'])) {
    $id = (int)$_GET['del'];
    $mysqli->query("DELETE FROM schools WHERE id=$id");
    header('Location: schools.php?view=list&msg=deleted');
    exit;
}

// Fetch schools with total students
$schools = $mysqli->query("
    SELECT s.id, s.name, s.city, COUNT(st.id) AS total_students
    FROM schools s
    LEFT JOIN students st ON s.id = st.school_id
    GROUP BY s.id
    ORDER BY s.id DESC
");

// Fetch single school for view
$school_view = null;
if ($view === 'view' && isset($_GET['id'])) {
    $id = (int)$_GET['id'];
    $school_view = $mysqli->query("
        SELECT s.id, s.name, s.city, COUNT(st.id) AS total_students
        FROM schools s
        LEFT JOIN students st ON s.id = st.school_id
        WHERE s.id=$id
        GROUP BY s.id
    ")->fetch_assoc();
}
?>
<!doctype html>
<html>
  <head>
    <meta charset="utf-8">
    <title>Schools</title>
    <link rel="stylesheet" href="/assets/style.css">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
    <style>
      .hidden { display: none; }
    </style>
  </head>
  <body class="p-0 pb-3" style="font-size: 16px !important">
  <div class="pt-3 container-fluid">

<?php if ($view === 'list'): ?>
      
      <div id="header" class="mb-2 d-flex justify-content-between align-items-center">
          <div class="fw-bold" style="font-size: 18px;">Schools - List</div>
          <div class="d-flex gap-2">
              <a href="schools.php?view=add" class="btn btn-success btn-sm">+ Add School</a>
          </div>
      </div>

<div id="indexView" class="card">
        <div class="card-body p-0">
          <input type="text" id="searchBox" class="form-control mb-2" placeholder="Search by name or city...">
          <table class="table table-hover align-middle m-0" id="schoolsTable">
              <thead class="table-dark">
                  <tr>
                      <th>ID</th>
                      <th>School Name</th>
                      <th>City</th>
                      <th>Total Students</th>
                      <th></th>
                  </tr>
              </thead>
              <tbody>
              <?php while ($s = $schools->fetch_assoc()): ?>
              <tr>
                  <td><?= $s['id'] ?></td>
                  <td><?= e($s['name']) ?></td>
                  <td><?= e($s['city']) ?></td>
                  <td><?= $s['total_students'] ?></td>
                  <td class="d-flex gap-1">
                      <a class="btn btn-sm btn-info" href="schools.php?view=view&id=<?= $s['id'] ?>">View</a>
                      <a class="btn btn-sm btn-warning" href="schools.php?view=edit&id=<?= $s['id'] ?>">Edit</a>
                  </td>
              </tr>
              <?php endwhile; ?>
              </tbody>
          </table>
        </div>
      </div>

rows.forEach(row => {
                  const schoolName = row.cells[1].textContent.toLowerCase();
                  const city = row.cells[2].textContent.toLowerCase();

if (schoolName.includes(searchValue) || city.includes(searchValue)) {
                      row.style.display = '';
                  } else {
                      row.style.display = 'none';
                  }
              });
          });
      </script>
      <?php endif; ?>

<?php if ($view === 'view' && $school_view): ?>
      
      <div id="viewSchool">
          <div class="mb-2">
              <a href="schools.php?view=list" class="btn btn-outline-secondary" style="padding: 2px 8px !important; border-radius: 50%; background: gray; color: white">←</a>
              <span style="padding-left: 5px"><b>Schools - View</b></span>
          </div>

<div class="card mb-4">
              <div class="card-header">School Details</div>
              <div class="card-body">
                  <p><strong>ID:</strong> <?= $school_view['id'] ?></p>
                  <p><strong>Name:</strong> <?= e($school_view['name']) ?></p>
                  <p><strong>City:</strong> <?= e($school_view['city']) ?></p>
                  <p><strong>Total Students:</strong> <?= $school_view['total_students'] ?></p>
              </div>
          </div>
      </div>
      <?php endif; ?>

<?php if ($view === 'add'): ?>
      
      <div id="addView">
          <div class="mb-2">
              <a href="schools.php?view=list" class="btn btn-outline-secondary" style="padding: 2px 8px !important; border-radius: 50%; background: gray; color: white">←</a>
              <span style="padding-left: 5px"><b>Schools - Create</b></span>
          </div>

<div class="card">
              <form method="post">
                <div class="card-header">
                  School Details
                </div>
                <div class="card-body">
                  <input type="hidden" name="create" value="1">
                  <div class="mb-3">
                      <label class="form-label">ID</label>
                      <input class="form-control" placeholder="Auto" disabled>
                  </div>
                  <div class="mb-3">
                      <label class="form-label">Name</label>
                      <input name="name" class="form-control" placeholder="Enter school name" required>
                  </div>
                  <div class="mb-3">
                      <label class="form-label">City</label>
                      <input name="city" class="form-control" placeholder="Enter school city">
                  </div>
                </div>
                <button class="btn btn-success btn-sm mb-3" style="margin-left: 2px; margin-right: 2px;">Save</button>
                <a href="schools.php" class="btn btn-danger btn-sm mb-3">Cancel</a>
              </form>
          </div>
      </div>
      <?php endif; ?>

<?php if ($view === 'edit' && isset($_GET['id'])):
          $id = (int)$_GET['id'];
          $school = $mysqli->query("SELECT * FROM schools WHERE id=$id")->fetch_assoc();
      ?>
      
      <div id="editView">
          <div class="mb-2">
              <a href="schools.php?view=list" class="btn btn-outline-secondary" style="padding: 2px 8px !important; border-radius: 50%; background: gray; color: white">←</a>
              <span style="padding-left: 5px"><b>Schools - Edit</b></span>
          </div>

<div class="card">
              <form method="post">
                <div class="card-header">
                  Update School
                </div>

<div class="card-body">
                  <input type="hidden" name="update" value="1">
                  <input type="hidden" name="id" value="<?= $school['id'] ?>">
                  <div class="mb-3">
                      <label class="form-label">Name</label>
                      <input name="name" class="form-control" value="<?= e($school['name']) ?>" required>
                  </div>
                  <div class="mb-3">
                      <label class="form-label">City</label>
                      <input name="city" class="form-control" value="<?= e($school['city']) ?>">
                  </div>
                </div>
                <button class="btn btn-success btn-sm mb-3" style="margin-left: 2px; margin-right: 2px;">Update</button>
                <a href="/admin/schools.php" class="btn btn-danger btn-sm mb-3">Cancel</a>
              </form>
          </div>
      </div>
      <?php endif; ?>

</div>
  </body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: schools.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation