MAINHACK

Viewing / Editing File: check_status_apps.php

<?php
include("functions.php");
if (isset($_GET['myindex']) && isset($_GET['myschoolcode'])) {

$indexNo = htmlspecialchars($_GET['myindex']);  
$schoolCode = htmlspecialchars($_GET['myschoolcode']);
$phone = htmlspecialchars($_GET['phone']);

// 1. Check stud_payment
$checkPay = mysqli_query($new, "SELECT * FROM stud_payment WHERE indexNumber='$indexNo' and s_code = '$schoolCode'");
if (!$checkPay) die("Error in stud_payment query: " . mysqli_error($new));
$hasPayment = mysqli_num_rows($checkPay) > 0;

// 2. Check enrol_generic
$checkGeneric = mysqli_query($new, "SELECT * FROM enrol_generic WHERE indexNo='$indexNo' and s_code = '$schoolCode'");
if (!$checkGeneric) die("Error in enrol_generic query: " . mysqli_error($new));
$hasGeneric = mysqli_num_rows($checkGeneric) > 0;

// 3. Check entrol_details (check both index_no and schoolID for safety)
$checkDetails = mysqli_query($new, "SELECT * FROM enrol_details WHERE index_no='$indexNo' and s_code = '$schoolCode'");
if (!$checkDetails) die("Error in enrol_details query: " . mysqli_error($new));
$hasDetails = mysqli_num_rows($checkDetails) > 0;

if ($hasPayment && $hasGeneric && !$hasDetails) {
    header("Location: login");
    exit();
}

elseif ($hasPayment && $hasDetails) {
    header("Location: login");
    exit();
}

elseif (!$hasPayment && !$hasDetails) {

header("Location: collection?myindex=" . urlencode($indexNo) . 
       "&myschoolcode=" . urlencode($schoolCode));

exit();

}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: check_status_apps.php

Server Info

System Features

User Info