public function selectAllPages()
{
$query = 'SELECT label, title, body, slug, id FROM page';
$this->db->query($query);
$result = $this->db->fetchAll();
$allPages = [];
foreach ($result as $key => $value) {
$allPages[] = new \Models\PageModel($value['label'], $value['title'], $value['body'], $value['slug'], $value['id']);
}
return $allPages;
}
public function getAll()
{
$query = "SELECT id, username FROM users";
$this->db->query($query);
$result = $this->db->fetchAll();
$allUsers = [];
foreach ($result as $value) {
$allUsers[] = new \Models\UserModels($value['username'], $value['password'], $value['id']);
}
return $allUsers;
}
public function getLecturesById($id)
{
$query = 'SELECT name, startTime, endTime, break, hall_id, conference_Id, day, l.id
FROM lectures as l
WHERE c.id = ?';
$this->db->query($query, [$id]);
$result = $this->db->fetchAll();
$lecture = [];
foreach ($result as $key => $value) {
$lecture[] = new LectureModel($value['name'], $value['startTime'], $value['endTime'], $value['break'], $value['hall_id'], $value['conference_Id'], $value['day'], $value['id']);
}
return $lecture;
}
public function selectId()
{
$query = 'SELECT name, address, id FROM venues';
$this->db->query($query);
$result = $this->db->fetchAll();
$allId = [];
foreach ($result as $key => $value) {
$allId[] = new \Models\VenueModel($value['name'], $value['address'], $value['id']);
}
$id = array_pop($allId);
$id = $id->getId();
return $id;
}
public function selectAllConferencesDetails()
{
$query = 'SELECT c.confName, c.startDate, c.endDate, c.venue_id, c.id, v.name, v.address
FROM conferences c
JOIN venues v
ON v.id = c.venue_id';
$this->db->query($query);
$result = $this->db->fetchAll();
$allConferences = [];
foreach ($result as $key => $value) {
$allConferences[] = new \BindingModels\Conference($value['confName'], $value['startDate'], $value['endDate'], $value['venue_id'], $value['id'], $value['name'], $value['address']);
}
return $allConferences;
}
public function getCheck($className)
{
$query = "SELECT 1 FROM {$className} LIMIT 1";
$this->db->query($query);
$result = $this->db->fetchAll();
return $result;
}
