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: index.bk.20251212.php

<?php
require_once __DIR__.'/../db.php';
require_once './../header.php';
require_admin(); // Your admin login check

// Count schools
$schools_count = $mysqli->query("SELECT COUNT(*) as total FROM schools")->fetch_assoc()['total'];

// Count quizzes
$quizzes_count = $mysqli->query("SELECT COUNT(*) as total FROM quizzes")->fetch_assoc()['total'];

// Count participa  nts
$total_schools = $mysqli->query("SELECT COUNT(DISTINCT id) as total_schools FROM schools")->fetch_assoc()['total_schools'];

// Students Count`
$students_count = $mysqli->query("SELECT COUNT(DISTINCT id) as total FROM students")->fetch_assoc()['total'];

// Fetch all questions across all quizzes
$questions = $mysqli->query("
    SELECT id, quiz_id, question
    FROM questions
    ORDER BY id ASC
")->fetch_all(MYSQLI_ASSOC);

// helper escape if not defined
if (!function_exists('e')) {
    function e($s) { return htmlspecialchars($s, ENT_QUOTES|ENT_SUBSTITUTE, 'UTF-8'); }
}

$filter_quiz_id = isset($_GET['quiz_id']) && (int)$_GET['quiz_id'] > 0 ? (int)$_GET['quiz_id'] : null;

$sql = "
      SELECT a.id AS attempt_id,
             a.student_id,
             a.quiz_id,
             a.status,
             a.marksObtained as score,
             a.started_at,
             a.completed_at,
             s.full_name AS student_name,
             s.school_id,
             sch.name AS school_name,
             qz.title AS quiz_title
      FROM attempts a
      LEFT JOIN students s ON a.student_id = s.id
      LEFT JOIN schools sch ON s.school_id = sch.id
      LEFT JOIN quizzes qz ON a.quiz_id = qz.id
      " . ($filter_quiz_id ? " WHERE a.quiz_id = {$filter_quiz_id} " : "") . "
      ORDER BY a.id DESC LIMIT 50
      ";

$attempts_rs = $mysqli->query($sql);
if (!$attempts_rs) {
    die("DB error: " . $mysqli->error);
}

$attempts = []; // key => chosen attempt row
while ($r = $attempts_rs->fetch_assoc()) {
    $key = $r['student_id'] . '|' . $r['quiz_id'];
    if (!isset($attempts[$key])) {
        $attempts[$key] = $r;
        continue;
    }
    // compare existing vs new
    $existing = $attempts[$key];
    // if existing is completed, keep existing
    if ($existing['status'] === 'completed') {
        continue;
    }
    // if new is completed, replace
    if ($r['status'] === 'completed') {
        $attempts[$key] = $r;
        continue;
    }
    // otherwise both not completed: pick latest started_at
    $existing_time = strtotime($existing['started_at']);
    $new_time = strtotime($r['started_at']);
    if ($new_time > $existing_time) {
        $attempts[$key] = $r;
    }
}

$attempts = array_values($attempts);

if (count($attempts) === 0) {
    ?>
    <!doctype html>
    <html><head>
      <meta charset="utf-8"><title>Student Report</title>
      <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
    </head>
    <body class="p-4">
      <div class="container">
        <h1>Student Report</h1>
        <p class="text-muted">No attempts found<?= $filter_quiz_id ? " for quiz ID " . e($filter_quiz_id) : "" ?>.</p>
      </div>
    </body></html>
    <?php
    exit;
}

$quiz_ids = [];
$attempt_ids = [];
foreach ($attempts as $a) {
    $quiz_ids[] = (int)$a['quiz_id'];
    $attempt_ids[] = (int)$a['attempt_id'];
}
$quiz_ids = array_values(array_unique($quiz_ids));
$attempt_ids = array_values(array_unique($attempt_ids));

$quiz_questions = []; // quiz_id => array of question rows in order
$all_question_ids = [];

if (count($quiz_ids) > 0) {
    $in = implode(',', $quiz_ids);
    $qsql = "SELECT id, quiz_id, question FROM questions WHERE quiz_id IN ({$in}) ORDER BY quiz_id, id ASC";
    $qres = $mysqli->query($qsql);
    while ($q = $qres->fetch_assoc()) {
        $quiz_questions[(int)$q['quiz_id']][] = $q;
        $all_question_ids[] = (int)$q['id'];
    }
}

$option_positions = []; // [question_id][option_id] = posIndex (0-based)
$option_is_correct = []; // [option_id] = is_correct (0/1)
if (count($all_question_ids) > 0) {
    $in = implode(',', array_unique($all_question_ids));
    $osql = "SELECT id, question_id, option_text, is_correct FROM options WHERE question_id IN ({$in}) ORDER BY question_id, id ASC";
    $ores = $mysqli->query($osql);
    while ($o = $ores->fetch_assoc()) {
        $qid = (int)$o['question_id'];
        if (!isset($option_positions[$qid])) $option_positions[$qid] = [];
        $option_positions[$qid][] = (int)$o['id']; // push id in order
        $option_is_correct[(int)$o['id']] = (int)$o['is_correct'];
    }
    // convert to map option_id => position
    foreach ($option_positions as $qid => $arr) {
        $map = [];
        foreach ($arr as $pos => $opt_id) {
            $map[$opt_id] = $pos; // 0-based index (0 -> A)
        }
        $option_positions[$qid] = $map;
    }
}

$answers_by_attempt = []; // [attempt_id][question_id] = ['option_id'=>..., 'is_correct'=>0/1]
if (count($attempt_ids) > 0) {
    $in = implode(',', $attempt_ids);
    $aSql = "SELECT attempt_id, question_id, option_id, is_correct FROM attempt_answers WHERE attempt_id IN ({$in})";
    $ares = $mysqli->query($aSql);
    while ($ar = $ares->fetch_assoc()) {
        $aid = (int)$ar['attempt_id'];
        $qid = (int)$ar['question_id'];
        $oid = (int)$ar['option_id'];
        $is_correct_flag = isset($ar['is_correct']) ? (int)$ar['is_correct'] : null;
        // if is_correct null, fallback to options.is_correct map if available
        if ($is_correct_flag === null) {
            $is_correct_flag = isset($option_is_correct[$oid]) ? (int)$option_is_correct[$oid] : 0;
        }
        $answers_by_attempt[$aid][$qid] = [
            'option_id' => $oid,
            'is_correct' => $is_correct_flag
        ];
    }
}

$max_questions = 0;
foreach ($quiz_questions as $qid => $qs) {
    $cnt = count($qs);
    if ($cnt > $max_questions) $max_questions = $cnt;
}
if ($max_questions === 0) $max_questions = 1; // safety

$rows = []; // each row = associative array for rendering
foreach ($attempts as $a) {
    $attempt_id = (int)$a['attempt_id'];
    $quiz_id = (int)$a['quiz_id'];
    $student_name = $a['student_name'];
    $school_name = $a['school_name'];
    $quiz_title = $a['quiz_title'];
    // questions for this quiz
    $qs = isset($quiz_questions[$quiz_id]) ? $quiz_questions[$quiz_id] : [];
    // prepare question cells in order
    $cells = [];
    $marks = null;
    // prefer recorded attempts.score if present & not null
    if ($a['score'] !== null) {
        $marks = (int)$a['score'];
    } else {
        $marks = 0; // will compute from answers
    }

foreach ($qs as $qIndex => $qrow) {
        $qId = (int)$qrow['id'];
        if (isset($answers_by_attempt[$attempt_id]) && isset($answers_by_attempt[$attempt_id][$qId])) {
            $ans = $answers_by_attempt[$attempt_id][$qId];
            $optId = (int)$ans['option_id'];
            $is_correct = (int)$ans['is_correct'];
            // get option position (A/B/C)
            if (isset($option_positions[$qId]) && isset($option_positions[$qId][$optId])) {
                $pos = (int)$option_positions[$qId][$optId]; // 0-based
                $letter = chr(65 + $pos); // 0->A
            } else {
                // fallback: unknown option order -> show '-'
                $letter = '-';
            }
            // if attempts.score wasn't present, use is_correct sum
            if ($a['score'] === null) {
                if ($is_correct) $marks++;
            }
            $cells[] = [
                'letter' => $letter,
                'is_correct' => $is_correct ? 1 : 0
            ];
        } else {
            // no answer for this question
            $cells[] = [
                'letter' => '-',
                'is_correct' => null
            ];
        }
    }

// pad cells to max_questions
    $pad = $max_questions - count($cells);
    for ($i=0;$i<$pad;$i++) $cells[] = ['letter'=>'','is_correct'=>null];

$rows[] = [
        'attempt_id' => $attempt_id,
        'student_name' => $student_name,
        'school_name' => $school_name,
        'quiz_title' => $quiz_title,
        'cells' => $cells,
        'marks' => $marks,
        'status' => $a['status']
    ];
}
?>

<!doctype html>
<html>
<head>
  <meta charset="utf-8">
  <title>Admin • Dashboard</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>
    .correct-cell {
      background-color: hsl(134.2, 39.3%, 51.6%) !important;
    }   /* light green */
    .wrong-cell {
      background-color: hsl(0, 74.5%, 56.9%) !important;
    }   /* light red */
    .no-answer {
      background-color: hsl(0, 1.1%, 63.9%) !important;
      color:#666 !important;
    }
    .table-responsive {
      max-height:70vh !important;
      overflow:auto !important;
    }
  </style>
</head>

<div class="mt-2 card">
    <div class="row text-center">
        <div class="card-header">
          Admin Overview
        </div>

<div class="col-md-3">
            <div class="shadow-sm" style="padding: 20px">
                <h3><?= $schools_count ?></h3>
                <p>Schools</p>
                <a href="schools.php" class="btn btn-primary">View Schools</a>
            </div>
        </div>
        <div class="col-md-3">
            <div class="shadow-sm" style="padding: 20px">
                <h3><?= $quizzes_count ?></h3>
                <p>Quizzes</p>
                <a href="quizzes.php" class="btn btn-success">View Quizzes</a>
            </div>
        </div>
        <div class="col-md-3">
            <div class="shadow-sm" style="padding: 20px">
                <h3><?= $students_count ?></h3>
                <p>Registered Students</p>
                <a href="students.php" class="btn btn-secondary">View Students</a>
            </div>
        </div>
        <div class="col-md-3">
            <div class="shadow-sm" style="padding: 20px">
                <h3><?= $total_schools ?></h3>
                <p>Registered Schools</p>
                <a href="schools.php" class="btn btn-warning">View Schools</a>
            </div>
        </div>
    </div>
  </div>
</div>

<div class="container-fluid">

  <hr style="margin-top: 6px; margin-bottom: 0px">

<div class="mt-0 table-responsive">
  <table class="table table-hover" style="font-size: 14px" id="reportTable">
    <thead>
      <tr>
        <td colspan="3"><span class="fs-6 fw-bold ">Student Wise Report</span></td>
        <td colspan="100" class="pt-2 pb-0" style="text: right">
          <div class="input-group mb-1" style="display:inline-flex; float: right; width: 50% !important" >
            <button id="exportExcel" class="btn btn-success btn-sm" style="margin-right: 5px; border-radius: 5px">Export</button>
            <div class="input-group-prepend">
              
            </div>
            <input id="searchInput" class="form-control" placeholder="Student name, school or quiz...">
            
          </div>
        </td>
      </tr>
    </thead>
    <thead class="table-dark align-middle">
      <tr>
        <th>#</th>
        <th>Student Name</th>
        <th>School Name</th>
        <th>Quiz Title</th>
        <?php for ($i=1; $i<= $max_questions; $i++): ?>
          <th style="text-align:center">Q<?= $i ?></th>
        <?php endfor; ?>
        <th>Marks Obtained</th>
        <th>Status</th>
        <th>Certificate</th>
      </tr>
    </thead>
    <tbody>
    <?php if (count($rows) === 0): ?>
      <tr><td colspan="<?= 6 + $max_questions ?>" class="text-center">No data</td></tr>
    <?php
      endif;
      $i=1;
    ?>

<?php foreach ($rows as $r): ?>
      <tr>
        <td><?= $i ?></td>
        <td><?= e($r['student_name']) ?></td>
        <td><?= e($r['school_name']) ?></td>
        <td><?= e($r['quiz_title']) ?></td>

<?php
          $i++;
          foreach ($r['cells'] as $cell):
            $letter = $cell['letter'] ?? '-';
            $is_correct = $cell['is_correct'];
            $tdClass = '';
            // if ($is_correct === 1) $tdClass = 'correct-cell';
            // elseif ($is_correct === 0) $tdClass = 'wrong-cell';
            // else $tdClass = 'no-answer';
        ?>
          <td class="correct-cell text-center"><?= $letter === '' ? '-' : e($letter) ?></td>
        <?php endforeach; ?>

<td class="text-center"><?= (int)$r['marks'] ?></td>
        <td class="text-center"><?= e(ucfirst($r['status'])) ?></td>
        <td class="text-center">
          <?php if ($r['status'] === 'completed'): ?>
            <a class="" href="<?php echo $base_url; ?>certificate.php?attempt_id=<?= (int)$r['attempt_id'] ?>" target="_blank">Certificate</a>
          <?php else: ?>
            <span class="text-muted">Not completed</span>
          <?php endif; ?>
        </td>
      </tr>
    <?php endforeach; ?>
    </tbody>
  </table>
 </div>
</div>

</body>
<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>

document.getElementById("exportExcel").addEventListener("click", function () {
    try {
        var table = document.getElementById("reportTable");

// Convert table to workbook
        var wb = XLSX.utils.table_to_book(table, { sheet: "Report" });

// Save to file
        XLSX.writeFile(wb, "student_report.xlsx");
    } catch (err) {
        console.error("Export error:", err);
        alert("Export failed. Check console for details.");
    }
});
</script>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: index.bk.20251212.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation