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

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

function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); }

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

/* ---------------------------
   CREATE
----------------------------*/
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['create'])) {
    $title = $_POST['title'] ?? '';
    $description = $_POST['description'] ?? '';
    $duration = (int)($_POST['duration'] ?? 0);
    $language = ($_POST['language'] ?? 'english');

$stmt = $mysqli->prepare("INSERT INTO quizzes (title, description, duration, language) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("ssis", $title, $description, $duration, $language);
    $stmt->execute();
    $quiz_id = $stmt->insert_id;

if (!empty($_POST['questions'])) {
        foreach ($_POST['questions'] as $qIndex => $question) {
            $question = trim($question);
            if ($question === '') continue;

$qMarks = isset($_POST['qmarks'][$qIndex]) ? (float)$_POST['qmarks'][$qIndex] : 0;
            $stmtQ = $mysqli->prepare("INSERT INTO questions (quiz_id, question, marks) VALUES (?, ?, ?)");
            $stmtQ->bind_param("isd", $quiz_id, $question, $qMarks);
            $stmtQ->execute();
            $qid = $stmtQ->insert_id;

if (!empty($_POST['options'][$qIndex])) {
                foreach ($_POST['options'][$qIndex] as $oIndex => $optText) {
                    $optText = trim($optText);
                    if ($optText === '') continue;

$oMarks = isset($_POST['omarks'][$qIndex][$oIndex]) ? (float)$_POST['omarks'][$qIndex][$oIndex] : 0;
                    $stmtO = $mysqli->prepare("INSERT INTO options (question_id, option_text, marks) VALUES (?, ?, ?)");
                    $stmtO->bind_param("isd", $qid, $optText, $oMarks);
                    $stmtO->execute();
                }
            }
        }
    }

echo "<script>location.href = '${base_url}admin/quizzes.php?view=view&id=$quiz_id';</script>";
    // header("Location: /quizzes.php");
    exit;
}

/* ---------------------------
   UPDATE
----------------------------*/
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update'])) {
    $quiz_id = (int)($_POST['quiz_id'] ?? 0);
    $title = $_POST['title'] ?? '';
    $description = $_POST['description'] ?? '';
    $duration = (int)($_POST['duration'] ?? 0);
    $language = ($_POST['language'] ?? 'english');

$stmt = $mysqli->prepare("UPDATE quizzes SET title=?, description=?, duration=?, language=? WHERE id=?");
    $stmt->bind_param("ssisi", $title, $description, $duration, $language, $quiz_id);
    $stmt->execute();

// Remove existing questions & options, we will re-insert from the form
    $mysqli->query("DELETE FROM options WHERE question_id IN (SELECT id FROM questions WHERE quiz_id=$quiz_id)");
    $mysqli->query("DELETE FROM questions WHERE quiz_id=$quiz_id");

if (!empty($_POST['questions'])) {
        foreach ($_POST['questions'] as $qIndex => $question) {
            $question = trim($question);
            if ($question === '') continue;

echo "<script>alert('Record updated successfully!');</script>";
    echo "<script>location.href = '${base_url}admin/quizzes.php';</script>";

// header("Location: /quizzes.php?view=index");
    exit;
}

/* ---------------------------
   DELETE
----------------------------*/
// if ($view === 'delete' && isset($_GET['id'])) {
//     $quiz_id = (int)$_GET['id'];
//     $mysqli->query("DELETE FROM options WHERE question_id IN (SELECT id FROM questions WHERE quiz_id=$quiz_id)");
//     $mysqli->query("DELETE FROM questions WHERE quiz_id=$quiz_id");
//     $mysqli->query("DELETE FROM quizzes WHERE id=$quiz_id");
//     header("Location: quizzes.php?view=index");
//     exit;
// }
?>
<div class="container-fluid py-4">

<?php if ($view === 'index'): ?>
  <div id="header" class="mb-1 text-end">
      <span class="mb-1 fw-bold" style="float: left; font-size: 18px;">Quizzes - List</span>
      <a href="quizzes.php?view=add" class="btn btn-success btn-sm">+ Add Quiz</a>
  </div>

<div class="card">
    <div class="card-body p-0">
      <input type="text" id="searchInput" class="form-control mb-2" placeholder="Search quizzes by any column...">
      <div class="table-responsive">
        <table class="table table-hover align-middle" id="quizTable">
          <thead class="table-dark">
            <tr>
              <th style="width:80px;">ID</th>
              <th>Title</th>
              <th>Description</th>
              <th style="width:140px;">Duration</th>
              
              <th style="width:240px;"></th>
            </tr>
          </thead>
          <tbody>
          <?php
            $res = $mysqli->query("SELECT * FROM quizzes ORDER BY id DESC");
            while ($row = $res->fetch_assoc()):
          ?>
            <tr>
              <td><?= (int)$row['id'] ?></td>
              <td><?= h($row['title']) ?></td>
              <td class="text-truncate" style="max-width:400px;"><?= h($row['description']) ?></td>
              <td><?= (int)$row['duration'] ?> min</td>
              <td style="text-align: center">
                <a href="quizzes.php?view=view&id=<?= (int)$row['id'] ?>" class="btn btn-sm btn-info">View</a>
                <a href="quizzes.php?view=edit&id=<?= (int)$row['id'] ?>" class="btn btn-sm btn-warning">Edit</a>
                
              </td>
            </tr>
          <?php endwhile; ?>
          </tbody>
        </table>
      </div>
    </div>
  </div>

<?php elseif ($view === 'add' || $view === 'edit'):
  $quiz = ['title'=>'','description'=>'','duration'=>0];
  $questions = [];
  $options = [];
  if ($view === 'edit' && isset($_GET['id'])) {
      $id = (int)$_GET['id'];
      $quiz = $mysqli->query("SELECT * FROM quizzes WHERE id=$id")->fetch_assoc();
      $qRes = $mysqli->query("SELECT * FROM questions WHERE quiz_id=$id ORDER BY id ASC");
      while($q = $qRes->fetch_assoc()){
          $questions[] = $q;
          $oRes = $mysqli->query("SELECT * FROM options WHERE question_id=".$q['id']." ORDER BY id ASC");
          while($o = $oRes->fetch_assoc()){
              $options[$q['id']][] = $o;
          }
      }
  }
?>
  <div class="card">
    <div class="card-body">
      <h4 class="mb-3"><?= $view==='add' ? 'Add Quiz' : 'Edit Quiz' ?></h4>

<div class="row g-3">
          <div class="col-md-6">
            <label class="form-label">Title</label>
            <input type="text" name="title" class="form-control" value="<?= h($quiz['title']) ?>" required>
          </div>
          <div class="col-md-3">
            <label class="form-label">Duration (minutes)</label>
            <input type="number" name="duration" class="form-control" min="0" value="<?= (int)$quiz['duration'] ?>" required>
          </div>
          <div class="col-md-3">
            <label class="form-label">Language</label>
            <select class="form-select" name="language" required>
              <option value="">Choose option</option>
              <option value="english" <?php if($quiz['language']=="english") echo 'selected'; ?>>English</option>
              <option value="urdu" <?php if($quiz['language']=="urdu") echo 'selected'; ?>>Urdu</option>
            </select>
          </div>
          <div class="col-12">
            <label class="form-label">Description</label>
            <textarea name="description" rows="3" class="form-control"><?= h($quiz['description']) ?></textarea>
          </div>
        </div>

<hr>

<div class="d-flex justify-content-between align-items-center mb-2">
          <h5 class="mb-0">Questions</h5>
        </div>

<div id="questions-container">
          <?php $qIndex = 0; foreach($questions as $q): ?>
            <div class="question-card card mb-3 p-3 border-success" data-qindex="<?= $qIndex ?>">
              <div class="row g-2">
                <div class="col-md-12">
                  <label class="form-label">Question</label>
                  <textarea name="questions[<?= $qIndex ?>]" class="form-control" rows="2" cols="50" placeholder="Enter question..." required><?= h($q['question']) ?></textarea>
                  
                </div>
                <div class="col-md-3">
                  <input type="hidden" step="0.01" name="qmarks[<?= $qIndex ?>]" class="form-control" value="0">
                </div>
              </div>

<div class="mt-3">
                <div class="d-flex justify-content-between align-items-center">
                  <strong>Options</strong>
                  <div>
                    <button type="button" class="btn btn-sm btn-outline-success add-option" data-qindex="<?= $qIndex ?>">+ Add Option</button>
                    <button type="button" class="btn btn-sm btn-outline-danger remove-question">Remove Question</button>
                  </div>
                </div>

<div class="options-container mt-2">
                  <?php $oIndex = 0; foreach(($options[$q['id']] ?? []) as $opt): ?>
                    <div class="input-group mb-2 option-item">
                      <input type="text" class="form-control" name="options[<?= $qIndex ?>][<?= $oIndex ?>]" value="<?= h($opt['option_text']) ?>" placeholder="Option text" required>
                      <input type="number" step="0.01" class="form-control" style="max-width:200px" name="omarks[<?= $qIndex ?>][<?= $oIndex ?>]" value="<?= (float)$opt['marks'] ?>" placeholder="Marks" required>
                      <button type="button" class="btn btn-danger remove-option">&times;</button>
                    </div>
                  <?php $oIndex++; endforeach; ?>
                </div>
              </div>
            </div>
          <?php $qIndex++; endforeach; ?>
        </div>

<div class="mt-3">
          <button type="button" class="btn btn-sm btn-primary" id="add-question">+ Add Question</button>
          <button type="submit" name="<?= $view==='add' ? 'create' : 'update' ?>" class="btn btn-sm btn-success">Save Quiz</button>
          <a href="quizzes.php?view=index" class="btn btn-sm btn-danger">Cancel</a>
        </div>
      </form>
    </div>
  </div>

// Add a new question block
  document.getElementById('add-question').addEventListener('click', function() {
      const container = document.getElementById('questions-container');
      const html = `
      <div class="question-card card mb-3 p-3 border-success" data-qindex="${qIndex}">
        <div class="row g-2">
          <div class="col-md-12">
            <label class="form-label">Question</label>
            <textarea name="questions[${qIndex}]" class="form-control" rows="2" cols="50" placeholder="Enter question..." required></textarea>
          </div>
          <div class="col-md-3">
            <input type="hidden" step="0.01" name="qmarks[${qIndex}]" class="form-control" value=0 placeholder="e.g. 1">
          </div>
        </div>

<div class="mt-3">
          <div class="d-flex justify-content-between align-items-center">
            <strong>Options</strong>
          </div>

<div class="options-container mt-2">
            <div class="input-group mb-2 option-item">
              <input type="text" class="form-control" name="options[${qIndex}][0]" placeholder="Option text" required>
              <input type="number" step="0.01" class="form-control" style="max-width:200px" name="omarks[${qIndex}][0]" placeholder="Marks" required>
              <button type="button" class="btn btn-danger remove-option">&times;</button>
            </div>
          </div>
          <div>
            <button type="button" class="btn btn-sm btn-outline-success add-option" data-qindex="${qIndex}">+ Add Option</button>
            <button type="button" class="btn btn-sm btn-outline-danger remove-question">Remove Question</button>
          </div>
        </div>
      </div>`;
      container.insertAdjacentHTML('beforeend', html);
      qIndex++;
  });

// Event delegation for adding/removing options & questions
  document.addEventListener('click', function(e){
      // Add Option
      if (e.target.classList.contains('add-option')) {
          const qCard = e.target.closest('.question-card');
          const qIdx = qCard.getAttribute('data-qindex'); // reliable source
          const optsContainer = qCard.querySelector('.options-container');
          const oIndex = optsContainer.querySelectorAll('.option-item').length;

// Remove Option
      if (e.target.classList.contains('remove-option')) {
          e.target.closest('.option-item').remove();
      }

// Remove Question
      if (e.target.classList.contains('remove-question')) {
          e.target.closest('.question-card').remove();
      }
  });
  </script>

<?php elseif ($view === 'view' && isset($_GET['id'])):
  $id = (int)$_GET['id'];
  $quiz = $mysqli->query("SELECT * FROM quizzes WHERE id=$id")->fetch_assoc();
  $qRes = $mysqli->query("SELECT * FROM questions WHERE quiz_id=$id ORDER BY id ASC");
?>
  <div class="card mb-3">
    <div class="card-body">
      <div class="d-flex justify-content-between align-items-start">
        <div>
          <h5 class="mb-1"><b>Title: <?= h($quiz['title']) ?></b></h5>
          <p class="text-muted mb-2">Description: <?= nl2br(h($quiz['description'])) ?></p>
          <p class="text-muted mb-2">Language: <?= nl2br(h(ucfirst($quiz['language']))) ?></p>
        </div>
        <div class="text-end">
          <span class="badge bg-primary fs-6">Duration: <?= (int)$quiz['duration'] ?> min</span><br>
          <span class="badge bg-secondary mt-2">Created: <?= h($quiz['created_at'] ?? '') ?></span>
        </div>
      </div>
    </div>
  </div>

<?php $qNo=1; while($q = $qRes->fetch_assoc()): ?>
    <div class="card mb-3 border-success">
      <div class="card-body">
        <div class="d-flex justify-content-between">
          <h5 class="card-title mb-2"><?= $qNo++ ?>. <?= h($q['question']) ?></h5>
          
        </div>
        <?php
          $oRes = $mysqli->query("SELECT * FROM options WHERE question_id=".$q['id']." ORDER BY id ASC");
          if ($oRes->num_rows > 0):
        ?>
          <ul class="list-group">
            <?php while($o = $oRes->fetch_assoc()): ?>
              <li class="list-group-item d-flex justify-content-between">
                <span><?= h($o['option_text']) ?></span>
                <span class="badge bg-success"><?= (float)$o['marks'] ?> marks</span>
              </li>
            <?php endwhile; ?>
          </ul>
        <?php else: ?>
          <p class="text-muted mb-0">No options added.</p>
        <?php endif; ?>
      </div>
    </div>
  <?php endwhile; ?>

<?php endif; ?>

</div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: quizzes.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation