public static function get_all_advertise($connection) { $statement = $connection->prepare("SELECT * FROM advertise"); $statement->execute(); $result = $statement->get_result(); $advertises = array(); while ($row = $result->fetch_assoc()) { $advertise = new Advertise(); $advertise->set_email($row["email"]); $advertise->set_title($row["title"]); $advertise->set_content($row["content"]); array_push($advertises, $advertise); } return $advertises; }