MAINHACK

Viewing / Editing File: load_students.php

<?php
include("functions.php");
$s_code = $_SESSION['s_code_Xw2119904'];
$offset = isset($_GET['offset']) ? intval($_GET['offset']) : 1;
$limit  = isset($_GET['limit']) ? intval($_GET['limit']) : 1000;
$search = isset($_GET['search']) ? trim($_GET['search']) : "";

// Get logo & school name
$getscholname = mysqli_query($new, "SELECT school_name, logo FROM schools WHERE school_code = '$s_code'");
$name = mysqli_fetch_array($getscholname);
$thisname = $name['school_name'];
$logo = $name['logo'];

// Optional search filter
$searchClause = "";
if ($search !== "") {
  $safeSearch = mysqli_real_escape_string($new, $search);
  $searchClause = "AND (
    student_name LIKE '%$safeSearch%' OR
    unique_student_code LIKE '%$safeSearch%' OR
    classname LIKE '%$safeSearch%' OR
    housename LIKE '%$safeSearch%'
  )";
}

// Main query
$query = "
  SELECT * FROM enrol_details 
  WHERE s_code = '$s_code' 
  AND raw_score != '' 
  $searchClause 
  ORDER BY student_name ASC 
  LIMIT $offset, $limit
";
$result = $new->query($query);

// Render each card
if ($result && $result->num_rows > 0) {
  while ($row = $result->fetch_assoc()) {
    $card_id = 'card_' . htmlspecialchars($row['unique_student_code']);
    $photo = !empty($row['photo']) ? $row['photo'] : 'https://via.placeholder.com/80';
    
   $classid = $row['class_id'];

// Fetch class name
$getclassname = mysqli_query($new, "SELECT program_id FROM class WHERE cid = '$classid' and s_code = '$s_code'");
$namee = mysqli_fetch_assoc($getclassname);
$program_id = $namee['program_id'];

// Fetch programme name
$getprograme = mysqli_query($new, "SELECT program_name FROM programme WHERE progid  = '$program_id' AND s_code = '$s_code'");
$thisprogram = mysqli_fetch_assoc($getprograme);
$myprograme = $thisprogram['program_name'] ?? '';

?>
    <div class="card" id="<?= $card_id ?>">
      <div class="card-header">
        <div class="logo-container">
          <img src="<?= htmlspecialchars($logo) ?>" alt="academy logo" crossOrigin="anonymous">
        </div>
        <div class="card-header-text">
          <div class="academy"><?= htmlspecialchars($thisname) ?></div>
        </div>
      </div>

<div class="card-body">
        <div class="card-left">
          <div class="name"><?= htmlspecialchars($row['student_name']) ?></div>
          <div class="id">Student ID: <?= htmlspecialchars($row['unique_student_code']) ?></div>
          <div class="details">
            Mother: <?= htmlspecialchars($row['father_name']) ?><br>
            Father: <?= htmlspecialchars($row['mother_name']) ?><br>
            Programme: <?php echo $myprograme; ?><br>
            Class: <?= htmlspecialchars($row['classname']) ?><br>
            House: <?= htmlspecialchars($row['housename']) ?><br>
          </div>
        </div>
        <div class="card-right">
          <img src="<?= htmlspecialchars($photo) ?>" alt="student" crossOrigin="anonymous">
        </div>
      </div>
 <br  />
      <div class="card-footer"></div>
      <button class="download-btn" data-card="<?= $card_id ?>" data-name="<?= htmlspecialchars($row['student_name']) ?>">⬇ Download</button>
    </div>
<?php
  }
} else {
  // no results — the front-end will show the "No Results" message
}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: load_students.php

Server Info

System Features

User Info