public static function getApplication($application_id) { $db = Connection::getInstance(); $mysqli = $db->getConnection(); $query = "select * from application where application_id='{$application_id}';"; $result = $mysqli->query($query); $application = new application(); if ($result->num_rows > 0) { if ($row = $result->fetch_assoc()) { $application->setSchool_id($row["schoolId"]); $application->setApplication_id($row["application_id"]); $application->setApplicant_id($row["applicantId"]); $application->setType($row["typeOfApplication"]); $application->setMedium($row["medium"]); $application->setOrderOfPreference($row["orderOfPreference"]); $application->setDistance($row["distanceToSchool"]); $application->setIsverified($row["isverified"]); } } return $application; }