PollContainer.php

obecná práce s anketami

php

<?php

final class PollContainer
{

	/** @var Database */
	private $db;

	public function __construct()
	{
		$this->db = Database::getInstance();
	}
	
	
	/**
	 * @return array
	 */
	public function getAll()
	{
		$data = array();
		$query = $this->db->query("
			SELECT * FROM `poll`
		");
		$polls = $query->fetchAll(PDO::FETCH_ASSOC);
		
		foreach ($polls as $poll) {
			$pollInfo = $poll;
			
			$query = $this->db->prepare("
				SELECT `id`, `text`, `count`, `color`
				FROM `poll_answer`
				WHERE `poll_id` = ?
			");
			$query->execute(array($poll["id"]));
			$pollInfo["answers"] = $query->fetchAll(PDO::FETCH_ASSOC);
			
			$data[] = $pollInfo;
		}
		
		return $data;
	}

}

Neformátovaný

Přidáno: 7.8.2013
Expirace: Neuvedeno

Autor: Martin Konečný (pavelco1998)