public function getAllContent()
{
$SQL = "SELECT `Img_loc`, `Date`, `Venue`, `Desc` FROM `content`";
$this->connect();
$result = $this->conn->query($SQL);
if ($result->num_rows > 0) {
$array = array();
$i = 0;
while ($row = $result->fetch_assoc()) {
$v = new Venue();
$v->setImg($row["Img_loc"]);
$v->setDate($row["Date"]);
$v->setVenue($row["Venue"]);
$v->setDesc($row["Desc"]);
$array[$i] = $v;
$i++;
}
return $array;
}
return NULL;
}
public function parseMovieVenues($id, $venues)
{
foreach ($venues->children() as $venue_element) {
$venue = new Venue();
$venue->setVenue($venue_element, $id);
if ($venue->exists()) {
if ($venue->requiresUpdate()) {
$venue->update();
}
} else {
$venue->insert();
}
}
}
