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; }