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/working.old/admin

Free Space:

3.3 TB

🔧 Quick Actions

✏️ Editing: oldWorkingQuizzes.php

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

/**
 * Modes
 */
$edit_id = isset($_GET['edit']) ? (int)$_GET['edit'] : 0;
$is_add  = isset($_GET['add']);
$is_edit = $edit_id > 0;

/**
 * Create quiz + questions (single submit on Add page)
 */
if (isset($_POST['save_quiz'])) {
    $title    = e($_POST['title']);
    $desc     = e($_POST['description']);
    $duration = isset($_POST['duration']) ? (int)$_POST['duration'] : 0;
    $status   = isset($_POST['is_active']) ? 1 : 0;

// Insert quiz
    $mysqli->query("INSERT INTO quizzes (title, description, duration, is_active)
                    VALUES ('$title','$desc',$duration,$status)");
    $quiz_id = $mysqli->insert_id;

// Insert questions + options if provided
    print_r($_POST['questions']);
    if (!empty($_POST['questions'])) {
        foreach ($_POST['questions'] as $qIndex => $qData) {
            if (!isset($qData['text'])) continue;
            $qText = trim($qData['text']);
            $marks = $qData['marks'];
            if ($qText === '') continue;

$qTextEsc = e($qText);
            $mysqli->query("INSERT INTO questions (quiz_id, question, marks) VALUES ($quiz_id, '$qTextEsc', $marks)");
            $question_id = $mysqli->insert_id;

if (!empty($qData['options'])) {
                foreach ($qData['options'] as $oIndex => $optText) {
                    $optText = trim($optText);
                    if ($optText === '') continue;
                    $optEsc = e($optText);
                    $is_correct = (isset($qData['correct']) && $qData['correct'] !== '' && (int)$qData['correct'] === (int)$oIndex) ? 1 : 0;

$mysqli->query("INSERT INTO options (question_id, option_text, is_correct)
                                    VALUES ($question_id, '$optEsc', $is_correct)");
                }
            }
        }
    }

// Back to list after creating everything
    header("Location: quizzes.php");
    exit;
}

/**
 * Update quiz (Edit page)
 */
if (isset($_POST['update_quiz'])) {
    $id       = (int)$_POST['quiz_id'];
    $title    = e($_POST['title']);
    $desc     = e($_POST['description']);
    $duration = isset($_POST['duration']) ? (int)$_POST['duration'] : 0;
    $status   = isset($_POST['is_active']) ? 1 : 0;

$mysqli->query("UPDATE quizzes
                    SET title='$title', description='$desc', duration=$duration, is_active=$status
                    WHERE id=$id");

header("Location: quizzes.php?edit=$id");
    exit;
}

/**
 * Delete a quiz (and its questions/options via manual cleanup or FK cascade)
 */
if (isset($_GET['del'])) {
    $id = (int)$_GET['del'];
    // If you don't have ON DELETE CASCADE on options -> questions, clean up manually:
    $resQ = $mysqli->query("SELECT id FROM questions WHERE quiz_id=$id");
    while ($rowQ = $resQ->fetch_assoc()) {
        $qid = (int)$rowQ['id'];
        $mysqli->query("DELETE FROM options WHERE question_id=$qid");
    }
    $mysqli->query("DELETE FROM questions WHERE quiz_id=$id");
    $mysqli->query("DELETE FROM quizzes WHERE id=$id");

header("Location: quizzes.php");
    exit;
}

/**
 * Add single question on Edit page
 */
if (isset($_POST['add_question'])) {
    $qid = (int)$_POST['quiz_id'];
    $question_text = isset($_POST['question']) ? trim($_POST['question']) : '';
    if ($question_text !== '') {
        $qEsc = e($question_text);
        $mysqli->query("INSERT INTO questions (quiz_id, question) VALUES ($qid, '$qEsc')");
        $question_id = $mysqli->insert_id;

if (!empty($_POST['options'])) {
            foreach ($_POST['options'] as $idx => $opt) {
                $opt_text = trim($opt);
                if ($opt_text === '') continue;
                $optEsc   = e($opt_text);
                $is_correct = (isset($_POST['correct']) && (int)$_POST['correct'] === (int)$idx) ? 1 : 0;

$mysqli->query("INSERT INTO options (question_id, option_text, is_correct)
                                VALUES ($question_id, '$optEsc', $is_correct)");
            }
        }
    }
    header("Location: quizzes.php?edit=".$qid);
    exit;
}

/**
 * Delete a single question from Edit page
 */
if ($is_edit && isset($_GET['delq'])) {
    $qDelId = (int)$_GET['delq'];
    $mysqli->query("DELETE FROM options WHERE question_id=$qDelId");
    $mysqli->query("DELETE FROM questions WHERE id=$qDelId");
    header("Location: quizzes.php?edit=".$edit_id);
    exit;
}

/**
 * Fetch data for list view
 */
$quizzes = $mysqli->query("SELECT q.*, COUNT(que.id) as total_questions
                           FROM quizzes q
                           LEFT JOIN questions que ON q.id=que.quiz_id
                           GROUP BY q.id
                           ORDER BY q.id DESC");

/**
 * Fetch quiz + questions for edit view
 */
$edit_quiz = null;
$questions_rs = null;
if ($is_edit) {
    $edit_quiz = $mysqli->query("SELECT * FROM quizzes WHERE id=$edit_id")->fetch_assoc();
    // Pull questions + aggregated options
    $questions_rs = $mysqli->query("
        SELECT q.*,
               GROUP_CONCAT(CONCAT(o.id,'|',REPLACE(o.option_text,'|','/'),'|',o.is_correct) SEPARATOR '||') AS opts
        FROM questions q
        LEFT JOIN options o ON o.question_id = q.id
        WHERE q.quiz_id = $edit_id
        GROUP BY q.id
        ORDER BY q.id DESC
    ");
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Manage Quizzes</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">

<style>
.question-block{border:1px solid #e5e7eb;background:#f9fafb;border-radius:.5rem;padding:15px;margin-bottom:15px}
.option-correct{font-weight:600}
.badge-space{gap:.25rem}
</style>
</head>
<body class="p-0 pb-3" style="font-size: 16px !important">
<div class="pt-3 container-fluid">

<?php if (!$is_add && !$is_edit): ?>
        
        <div class="mb-1 text-end">
            <span class="mb-1 fw-bold" style="float: left; font-size: 18px;">Quizzes - List</span>
            <a href="?add=1" class="btn btn-sm btn-success">+ Add New Quiz</a>
        </div>

<div class="card">
            <div class="card-body p-0">
                <table class="table table-hover align-middle m-0">
                    <thead class="table-dark">
                        <tr>
                            <th>ID</th>
                            <th>Title</th>
                            <th>Duration (min)</th>
                            <th>Questions</th>
                            <th>Status</th>
                            <th></th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php while ($q = $quizzes->fetch_assoc()): ?>
                        <tr>
                            <td><?= $q['id'] ?></td>
                            <td><?= e($q['title']) ?></td>
                            <td><?= (int)$q['duration'] ?></td>
                            <td><?= (int)$q['total_questions'] ?></td>
                            <td>
                                <?= $q['is_active']
                                    ? '<span class="badge bg-success">Active</span>'
                                    : '<span class="badge bg-secondary">Inactive</span>' ?>
                            </td>
                            <td class="badge-space d-flex">
                                <a href="?edit=<?= $q['id'] ?>" class="btn btn-sm btn-warning">Edit</a>
                                
                            </td>
                        </tr>
                        <?php endwhile; ?>
                        <?php if ($quizzes->num_rows === 0): ?>
                        <tr><td colspan="6" class="text-center text-muted p-4">No quizzes yet.</td></tr>
                        <?php endif; ?>
                    </tbody>
                </table>
            </div>
        </div>

<?php elseif ($is_add): ?>
        
        <div class="mb-2">
            <a href="quizzes.php" class="btn btn-outline-secondary" style="padding: 2px 8px !important; border-radius: 50%; background: gray; color: white">←</a>
            <span style="padding-left: 5px"><b>Quizzes - Create</b></span>
        </div>

<form method="post">
            <div class="card mb-4">
                <div class="card-header">
                  Quiz Details
                </div>
                <div class="card-body">
                  <div class="row g-3">
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Title</label>
                        <input type="text" name="title" class="form-control" required>
                    </div>
                    <div class="col-md-6 mb-3">
                        <label class="form-label">Duration (minutes)</label>
                        <input type="number" name="duration" min="1" class="form-control" required>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Description</label>
                        <textarea name="description" class="form-control" rows="3"></textarea>
                    </div>
                    <div class="form-check form-switch mb-2">
                        <input class="form-check-input" type="checkbox" name="is_active" id="is_active_add" checked>
                        <label class="form-check-label" for="is_active_add">Active</label>
                    </div>
                  </div>
                </div>
            </div>

<div class="card mb-4">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <span>Questions</span>
                </div>
                <div class="card-body" id="questions-container">
                    
                </div>
                <div class="p-2">
                  <button type="button" class="btn btn-sm btn-success addQuestion" onclick="addQuestion()">+ Add Question</button>
                </div>
                <div class="card-footer">
                  <button type="submit" type="submit" name="save_quiz" class="btn btn-success btn-sm" style="margin-right: 2px;" name="button">Save</button>
                  <a href="/admin/quizzes.php" class="btn btn-danger btn-sm">Cancel</a>
                </div>
            </div>

</form>

<?php elseif ($is_edit): ?>
        
        <div class="mb-2">
            <a href="quizzes.php" class="btn btn-outline-secondary" style="padding: 2px 8px !important; border-radius: 50%; background: gray; color: white">←</a>
            <span style="padding-left: 5px"><b>Quizzes - Edit</b></span>
        </div>

<div class="card mb-4">
                <form method="post">
                  <div class="card-header">
                    Quiz Details
                    <a href="/admin/quizzes.php" class="btn btn-danger btn-sm" style="float: right;">Cancel</a>
                    <button type="submit" type="submit" name="update_quiz" class="btn btn-success btn-sm" style="float: right; margin-right: 2px;" name="button">Update</button>
                  </div>
                  <div class="card-body">
                    <div class="row g-3">
                      <input type="hidden" name="quiz_id" value="<?= $edit_quiz['id'] ?>">
                      <div class="col-md-6 dmb-3">
                          <label class="form-label">Title</label>
                          <input type="text" name="title" class="form-control" value="<?= e($edit_quiz['title']) ?>" required>
                      </div>
                      <div class="col-md-6 mb-3">
                          <label class="form-label">Duration (minutes)</label>
                          <input type="number" name="duration" min="1" class="form-control" value="<?= (int)$edit_quiz['duration'] ?>" required>
                      </div>
                      <div class="mb-3">
                          <label class="form-label">Description</label>
                          <textarea name="description" class="form-control" rows="3"><?= e($edit_quiz['description']) ?></textarea>
                      </div>
                      <div class="form-check form-switch mb-2">
                          <input class="form-check-input" type="checkbox" name="is_active" id="is_active_edit" <?= $edit_quiz['is_active'] ? 'checked' : '' ?>>
                          <label class="form-check-label" for="is_active_edit">Active</label>
                      </div>
                      
                    </div>
                  </div>
                </form>
        </div>

<div class="card mb-4">
            <div class="card-header">Existing Questions</div>
            <div class="card-body">
                <?php if ($questions_rs && $questions_rs->num_rows): ?>
                    <?php while ($row = $questions_rs->fetch_assoc()): ?>
                        <div class="question-block">
                            <div class="d-flex justify-content-between">
                                <strong>Q<?= $row['id']; ?>.</strong>
                                <strong><?= $row['marks']; ?></strong>
                                
                            </div>
                            <div class="mt-2 mb-2"><?= nl2br(e($row['question'])) ?></div>
                            <?php
                                $opts = [];
                                if (!empty($row['opts'])) { $opts = explode('||', $row['opts']); }
                            ?>
                            <ul class="mb-0">
                                <?php foreach ($opts as $raw):
                                    if (!$raw) continue;
                                    list($oid,$txt,$cor) = explode('|',$raw);
                                ?>
                                    <li class="<?= $cor ? 'option-correct text-success' : '' ?>">
                                        <?= e($txt) ?> <?= $cor ? '(Correct)' : '' ?>
                                    </li>
                                <?php endforeach; ?>
                            </ul>
                        </div>
                    <?php endwhile; ?>
                <?php else: ?>
                    <p class="text-muted mb-0">No questions yet.</p>
                <?php endif; ?>
            </div>
        </div>

<div class="card">
            <div class="card-header">Add Question</div>
            <div class="card-body">
                <form method="post">
                    <input type="hidden" name="quiz_id" value="<?= $edit_id ?>">
                    <div class="mb-3">
                        <label class="form-label">Question</label>
                        <textarea name="question" class="form-control" required></textarea>
                    </div>
                    <?php for ($i=0; $i<4; $i++): ?>
                        <div class="mb-2">
                            <label class="form-label">Option <?= $i+1 ?></label>
                            <input type="text" name="options[<?= $i ?>]" class="form-control" required>
                        </div>
                    <?php endfor; ?>
                    <div class="mb-3">
                        <label class="form-label">Correct Option</label>
                        <select name="correct" class="form-select" required>
                            <option value="">Select</option>
                            <option value="0">Option 1</option>
                            <option value="1">Option 2</option>
                            <option value="2">Option 3</option>
                            <option value="3">Option 4</option>
                        </select>
                    </div>
                    <button type="submit" name="add_question" class="btn btn-primary">Add Question</button>
                </form>
            </div>
        </div>

<?php endif; ?>

</div>

<?php if ($is_add): ?>
<script>
let questionCount = 0;

// Adds one question block with 4 options
function addQuestion() {
    const qIndex = questionCount++;
    const container = document.getElementById('questions-container');

// document.getElementsByClassName("addQuestion").style.display = 'none';
    [].forEach.call(document.querySelectorAll('.addQuestion'), function (el) {
      el.style.visibility = 'hidden';
    });

const html = `
    <div class="question-block">
        <div class="mb-2">
            <label class="form-label">Question</label>
            <textarea name="questions[${qIndex}][text]" class="form-control" required></textarea>
        </div>
        <div class="mb-3">
            <label class="form-label">Marks</label>
            <input type="number" name="questions[${qIndex}][marks]" class="form-control" required>
        </div>
        ${[0,1,2,3].map(i => `
            <div class="mb-2">
                <label class="form-label">Option ${i+1}</label>
                <input type="text" name="questions[${qIndex}][options][${i}]" class="form-control" required>
            </div>
        `).join('')}
        <div class="mb-3">
            <label class="form-label">Correct Option</label>
            <select name="questions[${qIndex}][correct]" class="form-select" required>
                <option value="">Select</option>
                <option value="0">Option 1</option>
                <option value="1">Option 2</option>
                <option value="2">Option 3</option>
                <option value="3">Option 4</option>
            </select>
        </div>
        <button type="button" class="btn btn-sm btn-outline-danger" onclick="this.parentElement.remove()">Remove Question</button>
        <button type="button" class="btn btn-sm btn-outline-success addQuestion" onclick="addQuestion()">+ Add Question</button>
    </div>`;

container.insertAdjacentHTML('beforeend', html);
}

// Add one default question on load
document.addEventListener('DOMContentLoaded', () => addQuestion());
</script>
<?php endif; ?>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: oldWorkingQuizzes.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation