public static function getSelectedApplicantsForSchool($schoolId)
{
$db = Connection::getInstance();
$mysqli = $db->getConnection();
$query = "select * from studentApplicant s left join guardian g on g.NIC=s.NIC where selectedSchoolId='{$schoolId}';";
$result = $mysqli->query($query);
$appplicants = array();
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$applicant = new StudentApplicant();
$applicant->setApplicantId($row["applicantId"]);
$applicant->setFirstname($row["firstname"]);
$applicant->setLastName($row["lastname"]);
$applicant->setGender($row["gender"]);
$applicant->setReligion($row["religion"]);
$applicant->setDateOfBirth($row["dateofBirth"]);
$applicant->setSelectedSchool($row["selectedSchoolId"]);
$applicant->setGuardianNic($row["NIC"]);
$applicant->setGuardian_lastname($row["g_lastName"]);
$applicant->setGuardian_firstname($row["g_firstName"]);
$applicant->setGuardian_contact($row["contactNumber"]);
$appplicants[] = $applicant;
}
}
return $appplicants;
}
