public static function getTypes() { $bdd = DAOConnectBDD::connect(); $req = $bdd->prepare('select * from type'); $req->execute(); $res = $req->fetchAll(); return $res; }
public static function getInfosClasses() { $bdd = DAOConnectBDD::connect(); $req = $bdd->prepare('select classe.idClasse, nomClasse, etablissement.idEtablissement, nomEtablissement from classe, exister, etablissement where classe.idClasse = exister.idClasse and exister.idEtablissement = etablissement.idEtablissement;'); $req->execute(); $res = $req->fetchAll(); return $res; }
public static function getInfosEnfant($idEnf) { $bdd = DAOConnectBDD::connect(); $req = $bdd->prepare('select nomEnf, prenomEnf, nomClasse, nomEtablissement from enfant, classe, etablissement where idEnf = :idEnf and enfant.idClasse = classe.idClasse and enfant.idEtablissement = etablissement.idEtablissement;'); $req->execute(array("idEnf" => $idEnf)); $res = $req->fetchAll(); return $res; }
public static function getEtablissements() { $bdd = DAOConnectBDD::connect(); $req = $bdd->prepare('select * from etablissement'); $req->execute(); $res = $req->fetchAll(); return $res; }
public static function login($login, $mdp) { $bdd = DAOConnectBDD::connect(); $req = $bdd->prepare('select mdpBene from benevole where loginBene = :login'); $req->execute(array('login' => $login)); $res = $req->fetch(); if ($res[0] == $mdp) { return true; } else { return false; } }
public static function getAdherents() { $bdd = DAOConnectBDD::connect(); $req = $bdd->prepare('select * from adherent'); $req->execute(); $adhs = $req->fetchAll(PDO::FETCH_CLASS, "DAOAdherent"); foreach ($adhs as $res) { array_push(DAOAdherent::$adherents, $res); } foreach (DAOAdherent::$adherents as $adh) { $adh->enfant = array(); $req = $bdd->prepare('select * from enfant where idAd = :idAd'); $req->execute(array('idAd' => $adh->idAd)); $enfs = $req->fetchAll(PDO::FETCH_CLASS, "DAOEnfant"); foreach ($enfs as $res) { array_push($adh->enfant, $res); } } return DAOAdherent::$adherents; }
public static function updateEtatBenevole($idBene, $etat) { $bdd = DAOConnectBDD::connect(); $req = $bdd->prepare('update benevole set estAdmin = :etat where idBene = :idBene;'); $req->execute(array("etat" => $etat, "idBene" => $idBene)); }
public static function creerLivre($codeISBN, $titre, $editeur, $auteur, $anneeEdition, $formatEdition, $idCategorie, $idType, $idDiscipline) { $bdd = DAOConnectBDD::connect(); $req = $bdd->prepare('insert into manuel values (:codeISBN,:titre,:editeur,:auteur,:anneeEdition,:formatEdition,:idCategorie,:idType,:idDiscipline);'); $req->execute(array("codeISBN" => $codeISBN, "titre" => $titre, "editeur" => $editeur, "auteur" => $auteur, "anneeEdition" => $anneeEdition, "formatEdition" => $formatEdition, "idCategorie" => $idCategorie, "idType" => $idType, "idDiscipline" => $idDiscipline)); }