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;
}
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();
?>
</body>
</html>
