public static function get_all_employer($connection) { $statement = $connection->prepare("SELECT * FROM employer"); $statement->execute(); $result = $statement->get_result(); $employers = array(); while ($row = $result->fetch_assoc()) { $employer = new Employer(); $employer->set_email($row["email"]); $employer->set_password($row["password"]); $employer->set_address($row["address"]); $employer->set_contact($row["contact"]); $employer->set_industry($row["industry"]); $employer->set_about($row["about"]); $employer->set_company_name($row["company_name"]); $employer->set_license_no($row["licence_no"]); $employer->set_logo($row["logo"]); array_push($employers, $employer); } return $employers; }
$industries = Industry::get_all_industry($connection); for ($i = 0; $i < sizeof($industries); $i++) { echo $industries[$i]->get_name(); echo "<br />"; } echo "<br />"; $positions = Position::get_all_position($connection); for ($i = 0; $i < sizeof($positions); $i++) { echo $positions[$i]->get_name(); echo "<br />"; } echo "<br />"; $rnd_employer = new Employer(); $rnd_employer->set_email("*****@*****.**"); $rnd_employer->set_password("123456"); $rnd_employer->set_address("nus"); $rnd_employer->set_contact(12345677); $rnd_employer->set_industry("F&B"); $rnd_employer->set_about("huh"); $rnd_employer->set_company_name("some company"); $rnd_employer->set_license_no("nj2i3n4"); Employer::update_employer($rnd_employer, $connection); $employers = Employer::get_all_employer($connection); for ($i = 0; $i < sizeof($employers); $i++) { $employer = $employers[$i]; echo $employer->get_email(); echo " " . $employer->get_industry()->get_name(); echo "<br />"; } $database->close_connection(); ?>