/** * @param Room * @return Queue */ public function fetchQueueByRoom(Room $room) { $results = $this->_dbCon->query('SELECT * FROM `queue` WHERE `id` = ?', array($room->getId())); $row = $results->current(); $queue = new Queue(); $queue->setId($row['id']); return $queue; }
/** * @param Room * @return void */ public function deleteRoom(Room $room) { $statement = $this->_dbCon->query('DELETE FROM `room` WHERE `id` = ?', array($room->getId())); }