public static function get_all_job_applicant($connection)
{
$statement = $connection->prepare("SELECT * FROM jobapplicant");
$statement->execute();
$result = $statement->get_result();
$job_applicants = array();
while ($row = $result->fetch_assoc()) {
$job_applicant = new JobApplicant();
$job_applicant->set_email($row["email"]);
$job_applicant->set_password($row["password"]);
$job_applicant->set_first_name($row["first_name"]);
$job_applicant->set_last_name($row["last_name"]);
$job_applicant->set_industry($row["industry"]);
$job_applicant->set_about($row["about_me"]);
$job_applicant->set_contact($row["contact"]);
$job_applicant->set_nationality($row["nationality"]);
$job_applicant->set_birthday($row["birthday"]);
$job_applicant->set_location($row["location"]);
array_push($job_applicants, $job_applicant);
}
return $job_applicants;
}
