public static function get_all_industry($connection) { $statement = $connection->prepare("SELECT * FROM industry"); $statement->execute(); $result = $statement->get_result(); $industries = array(); while ($row = $result->fetch_assoc()) { $industry = new Industry(); $industry->set_name($row["industry"]); array_push($industries, $industry); } return $industries; }