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

Free Space:

3.18 TB

🔧 Quick Actions

✏️ Editing: assign_quizzes.php

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

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

// Delete record
if (isset($_GET['delete'])) {
    $stmt = $mysqli->prepare("DELETE FROM quiz_school WHERE quiz_id=? AND school_id=?");
    $stmt->bind_param('ii', $_GET['quiz_id'], $_GET['school_id']);
    $stmt->execute();
    echo "<script>alert('Record deleted successfully!');</script>";
    echo "<script>location.href = '${base_url}admin/assign_quizzes.php';</script>";
    // header('Location: assign_quizzes.php');
    exit;
}

// Save (Add or Update)
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $quiz_id = (int)$_POST['quiz_id'];
    $school_id = (int)$_POST['school_id'];
    $amount = $_POST['amount'] !== '' ? (float)$_POST['amount'] : null;

// Check for duplicate
    $stmt = $mysqli->prepare("SELECT 1 FROM quiz_school WHERE quiz_id=? AND school_id=?");
    $stmt->bind_param('ii', $quiz_id, $school_id);
    $stmt->execute();
    $exists = $stmt->get_result()->num_rows > 0;

if ($exists && empty($_POST['edit_mode'])) {
        $message = "This quiz is already assigned to the selected school!";
    } else {
        if (!empty($_POST['edit_mode'])) {
            $stmt = $mysqli->prepare("UPDATE quiz_school SET amount=? WHERE quiz_id=? AND school_id=?");
            $stmt->bind_param('dii', $amount, $quiz_id, $school_id);
            $stmt->execute();
        } else {
            $stmt = $mysqli->prepare("INSERT INTO quiz_school (quiz_id, school_id, amount) VALUES (?, ?, ?)");
            $stmt->bind_param('iid', $quiz_id, $school_id, $amount);
            $stmt->execute();
        }

if (!$message) {
            echo "<script>location.href = '${base_url}admin/assign_quizzes.php';</script>";
            exit;
        }
    }
}
?>

<?php if ($message): ?>
        <div class="alert alert-danger"><?= htmlspecialchars($message) ?></div>
    <?php endif; ?>

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

<table class="table table-hover align-middle" id="quizTable">
                <thead class="table-dark">
                    <tr>
                        <th>Quiz</th>
                        <th>School</th>
                        <th>Price</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                <?php
                $result = $mysqli->query("
                    SELECT qs.quiz_id, qs.school_id, qs.amount, q.title AS quiz_title, s.name AS school_name
                    FROM quiz_school qs
                    JOIN quizzes q ON q.id = qs.quiz_id
                    JOIN schools s ON s.id = qs.school_id
                    ORDER BY qs.quiz_id DESC
                ");
                while ($row = $result->fetch_assoc()):
                ?>
                    <tr>
                        <td><?= htmlspecialchars($row['quiz_title']) ?></td>
                        <td><?= htmlspecialchars($row['school_name']) ?></td>
                        <td><?= $row['amount'] !== null ? number_format($row['amount'], 2) : '-' ?></td>
                        <td>
                            <a href="?view=edit&quiz_id=<?= $row['quiz_id'] ?>&school_id=<?= $row['school_id'] ?>" class="btn btn-sm btn-warning">Edit</a>
                            <a href="?delete=1&quiz_id=<?= $row['quiz_id'] ?>&school_id=<?= $row['school_id'] ?>" class="btn btn-sm btn-danger" onclick="return confirm('Delete this assignment?')">Delete</a>
                        </td>
                    </tr>
                <?php endwhile; ?>
                </tbody>
            </table>
          </div>
        </div>

rows.forEach(row => {
                    const quizName = row.cells[0].textContent.toLowerCase();
                    const schoolName = row.cells[1].textContent.toLowerCase();
                    if (quizName.includes(searchValue) || schoolName.includes(searchValue)) {
                        row.style.display = '';
                    } else {
                        row.style.display = 'none';
                    }
                });
            });
        </script>

<?php else:
        $quiz_id = $_GET['quiz_id'] ?? '';
        $school_id = $_GET['school_id'] ?? '';
        $amount = '';
        $edit_mode = false;
        if ($view === 'edit' && $quiz_id && $school_id) {
            $stmt = $mysqli->prepare("SELECT * FROM quiz_school WHERE quiz_id=? AND school_id=?");
            $stmt->bind_param('ii', $quiz_id, $school_id);
            $stmt->execute();
            $row = $stmt->get_result()->fetch_assoc();
            $amount = $row['amount'];
            $edit_mode = true;
        }

$quizzes = $mysqli->query("SELECT id, title FROM quizzes WHERE is_active=1 ORDER BY id DESC");
        $schools = $mysqli->query("SELECT id, name FROM schools ORDER BY id DESC");
    ?>
      <div class="mb-2">
          <a href="assign_quizzes.php" class="btn btn-outline-secondary" style="padding: 2px 6px !important; border-radius: 50%; background: gray; color: white">←</a>
          <span style="padding-left: 5px"><b><?= $_GET['view'] === 'add' ? 'Assign Quizzes - Create' : 'Assign Quizzes - Edit' ?></b></span>
      </div>
      <div class="card">
        <div class="card-header m-0"><?= $_GET['view'] === 'add' ? 'Assign Quiz' : 'Edit Assign' ?></div>
        <div class="card-body">
        <form method="post">
            <input type="hidden" name="edit_mode" value="<?= $edit_mode ? 1 : '' ?>">

<div class="mb-3">
                <label class="form-label">Quiz</label>
                <select name="quiz_id" class="form-control" required <?= $edit_mode ? 'readonly disabled' : '' ?>>
                    <option value="">Select Quiz</option>
                    <?php while ($q = $quizzes->fetch_assoc()): ?>
                        <option value="<?= $q['id'] ?>" <?= $quiz_id == $q['id'] ? 'selected' : '' ?>><?= htmlspecialchars($q['title']) ?></option>
                    <?php endwhile; ?>
                </select>
                <?php if ($edit_mode): ?>
                    <input type="hidden" name="quiz_id" value="<?= $quiz_id ?>">
                <?php endif; ?>
            </div>

<div class="mb-3">
                <label class="form-label">School</label>
                <select name="school_id" class="form-control" required <?= $edit_mode ? 'readonly disabled' : '' ?>>
                    <option value="">Select School</option>
                    <?php while ($s = $schools->fetch_assoc()): ?>
                        <option value="<?= $s['id'] ?>" <?= $school_id == $s['id'] ? 'selected' : '' ?>><?= htmlspecialchars($s['name']) ?></option>
                    <?php endwhile; ?>
                </select>
                <?php if ($edit_mode): ?>
                    <input type="hidden" name="school_id" value="<?= $school_id ?>">
                <?php endif; ?>
            </div>

<div class="mb-3">
                <label class="form-label">Price</label>
                <input type="number" step="0.01" name="amount" class="form-control" value="<?= htmlspecialchars($amount) ?>">
            </div>

<button type="submit" class="btn btn-success btn-sm">Save</button>
            <a href="assign_quizzes.php" class="btn btn-danger btn-sm">Cancel</a>
        </form>
      </div>
    </div>
    <?php endif; ?>
</div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: assign_quizzes.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation