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; }