<?php

class Candidate
{
  private $idcandidate;
  private $candidate_name;

  public function __construct($id, $cand)
  {
    $this->idcandidate = $id;
    $this->candidate_name = $cand;
  }
  
  public function getIdCandidate()
  {
    return $this->idcandidate;
  }

  public function getCandidateName()
  {
    return $this->candidate_name;
  }
  
  public function setId($id)
  {
    $this->idcandidate = $id;
  }
  public function setCandidateName($c)
  {
    $this->candidate_name = $c;
  }

  public static function getCandidates()
  {
    $req = BDD::getBDD()->query('SELECT * FROM Candidates2005;');
    $toReturn = array();
    while($result = $req->fetch())
      {
	$toReturn[$result['id']] = $result['candidate_name'];
      }
    return $toReturn;    
  }

  public function getSolutions()
  {
    $toReturn = array();
    $req = $bdd->prepare('SELECT * from Candidates2005 c, Solutions2005 s WHERE s.numCandidate=c.id and numCandidate=:c ORDER BY numInstance');
    $req->execute(array('c'=>$this->idcandidate));
    $result = $req->fetchAll();
    $toReturn = $result;
    return $toReturn;
  }
}
?>