1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
// Dans la classe d'accés aux données :
public function retournerUnclient($id)
{
$req="SELECT * FROM client WHERE IDClient=".$id;
$res=mysql_query($req);
if (mysql_num_rows($res)==1)
{
$this->set_IdClient(mysql_result($res,0,"IDClient"));
$this->set_titre(mysql_result($res,0,"TITRE"));
$this->set_nom(mysql_result($res,0,"NOM"));
$this->set_prenom(mysql_result($res,0,"PRENOM"));
$this->set_DateNaissance(mysql_result($res,0,"DATEDENAISSANCE"));
$this->age();
$this->set_mail(mysql_result($res,0,"mail"));
$this->set_motPasse(mysql_result($res,0,"motPasse"));
$this->set_adresse(mysql_result($res,0,"ADRESSE"));
$this->set_code_postal(mysql_result($res,0,"CODE_POSTAL"));
$this->set_ville(mysql_result($res,0,"VILLE"));
return $this;
}
}
public function retournerLesclients()
{
$req="select * from client";
$res = mysql_query($req);
$macol= new Collection();
while($row = mysql_fetch_array($res))
{
$lecl=new client_DAO;
$lecl->retournerUnclient($row["IDClient"]);
$macol->add($lecl);
}
return $macol->getAll(); //retourne une collection de catégorie
}
public function age()
{
$req=("SELECT *, (((EXTRACT(YEAR FROM CURRENT_DATE)) * 365.2422+ (EXTRACT(MONTH FROM CURRENT_DATE) - 1) * 31.0+ EXTRACT(DAY FROM CURRENT_DATE))-((EXTRACT(YEAR FROM DateDeNaissance)) * 365.2422+ (EXTRACT(MONTH FROM DateDeNaissance) -1 ) * 31.0+ (EXTRACT(DAY FROM DateDeNaissance))) / 365.2422 AS Age FROM client");
$res = mysql_query($req);
echo $res;
} |
Partager