Kineo\Model\CandidatesModel::getCandidatesByConstituencyId()

Complexity

Conditions	3
Paths	2

Size

Total Lines	24
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	4
Bugs	0	Features	0

<?php
	public function getCandidatesByConstituencyId($constituencyId) 
	{
		$stmt = $this->db->prepare(
			"SELECT a.id, a.name, a.party FROM `tblCandidates` AS a 
			LEFT JOIN `tblConstituencies` AS b 
			ON a.constituency_id = b.id 
			WHERE b.id = :id
			ORDER BY a.name ASC"
		);
		
		$stmt->bindValue(':id', $constituencyId, \PDO::PARAM_INT);
		
		$stmt->execute();
		
		$result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
		
		if(is_array($result) && !empty($result)) {
			$this->candidates = $result;
			
			return $this->candidates;
		} else {
			return false;
		}
	}
}