MAINHACK

Viewing / Editing File: fetch_students.php

<?php
include("../functions.php");
session_start();

$s_code = $_SESSION['s_code_Xw2119904'];
$search = $_GET['q'] ?? '';  // if using Select2 or similar

header('Content-Type: application/json');

// --- FIXED SQL ---
// Grouped AND/OR correctly
$sql = "
    SELECT id, student_name, schoolID, unique_student_code
    FROM enrol_details
    WHERE s_code = '".mysqli_real_escape_string($new, $s_code)."'
      AND (
            student_name LIKE '%".mysqli_real_escape_string($new, $search)."%' OR
            schoolID LIKE '%".mysqli_real_escape_string($new, $search)."%' OR
            unique_student_code LIKE '%".mysqli_real_escape_string($new, $search)."%'
          )
    ORDER BY student_name DESC
";

$result = mysqli_query($new, $sql);
$out = [];

if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {

// --- APPLY YOUR LOGIC ---
        if (empty($row['schoolID'])) {
            $final_id = $row['unique_student_code'];
        } elseif (!empty($row['schoolID']) && !empty($row['unique_student_code'])) {
            $final_id = $row['unique_student_code'];
        } else {
            $final_id = $row['schoolID'];
        }

$out[] = [
            "id" => $final_id,
            "text" => $row['student_name']
        ];
    }
}

echo json_encode($out);
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: fetch_students.php

Server Info

System Features

User Info