Example #1
0
    /**
     * @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;
    }
Example #2
0
 /**
  * @param Room
  * @return void
  */
 public function deleteRoom(Room $room)
 {
     $statement = $this->_dbCon->query('DELETE FROM `room` WHERE `id` = ?', array($room->getId()));
 }