function __construct($requete, &$tabResult, $parametres)
{
$dbh = ConnexionBDD::getInstance();
$stmt = $dbh->prepareEtExecuteRequete($dbh, $requete, $parametres);
while ($row = $stmt->fetch()) {
try {
$id = $row['id'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$dateFin = $row['date'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$titre = stripslashes($row['titre']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$description = stripslashes($row['description']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$idMembre = $row['id_membre'];
} catch (Exception $e) {
echo $e->getMessage();
}
$evenement = new Evenement($id, $titre, $description, $dateFin, $idMembre);
$tabResult[] = $evenement;
}
}
function __construct($requete, &$tabResult, $parametres)
{
$dbh = ConnexionBDD::getInstance();
$stmt = $dbh->prepareEtExecuteRequete($dbh, $requete, $parametres);
while ($row = $stmt->fetch()) {
try {
$id = $row['id'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$libelle = stripslashes($row['libelle']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$description = stripslashes($row['description']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$nom = stripslashes($row['nom']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$url = $row['url'];
} catch (Exception $e) {
echo $e->getMessage();
}
$dispo = new Disposition($id, $description, $libelle, $nom, $url);
$tabResult[] = $dispo;
}
}
/**
* objet gérant la base de données
* */
static function getInstance()
{
if (self::$instance === null) {
self::$instance = new self();
}
return self::$instance;
}
function __construct($requete, &$tabResult, $parametres)
{
$dbh = ConnexionBDD::getInstance();
$stmt = $dbh->prepareEtExecuteRequete($dbh, $requete, $parametres);
//print_r($parametres);
while ($row = $stmt->fetch()) {
try {
$id = $row['id'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$maildest = $row['mailDestinataire'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$objet = stripslashes($row['objet']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$message = stripslashes($row['message']);
} catch (Exception $e) {
echo $e->getMessage();
}
$msg = new Message($id, $maildest, $objet, $message);
$tabResult[] = $msg;
}
}
function __construct($requete, &$tabResult, $parametres)
{
$dbh = ConnexionBDD::getInstance();
$stmt = $dbh->prepareEtExecuteRequete($dbh, $requete, $parametres);
//print_r($parametres);
while ($row = $stmt->fetch()) {
try {
$id = $row['id'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$pseudo = $row['pseudo'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$mdp = $row['motDePasse'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$email = $row['email'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$id_grade = $row['id_grade'];
} catch (Exception $e) {
echo $e->getMessage();
}
$personne = new Personne($id, $pseudo, $mdp, $email, $id_grade);
$tabResult[] = $personne;
}
}
function __construct($requete, &$tabResult, $parametre)
{
$dbh = ConnexionBDD::getInstance();
$stmt = $dbh->prepareEtExecuteRequete($dbh, $requete, $parametre);
while ($row = $stmt->fetch()) {
try {
$id = $row['id'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$titre = stripslashes($row['titre']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$texte1 = stripslashes($row['texte']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$texte2 = stripslashes($row['texte2']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$date = $row['date'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$idMembre = $row['id_membre'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$id_disposition = $row['id_disposition'];
} catch (Exception $e) {
echo $e->getMessage();
}
$news = new News($id, $titre, $texte1, $texte2, $date, $idMembre, $id_disposition);
$tabResult[] = $news;
}
}
function __construct($requete, &$tabResult, $parametres)
{
$dbh = ConnexionBDD::getInstance();
$stmt = $dbh->prepareEtExecuteRequete($dbh, $requete, $parametres);
while ($row = $stmt->fetch()) {
try {
$id = $row['id'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$chemin = $row['chemin'];
} catch (Exception $e) {
echo $e->getMessage();
}
$video = new Video($id, $chemin);
$tabResult[] = $video;
}
}
function __construct($requete, &$tabResult, $parametres)
{
$dbh = ConnexionBDD::getInstance();
$stmt = $dbh->prepareEtExecuteRequete($dbh, $requete, $parametres);
while ($row = $stmt->fetch()) {
try {
$id = $row['id'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$libelle = stripslashes($row['libelle']);
} catch (Exception $e) {
echo $e->getMessage();
}
$grades = new Grade($id, $libelle);
$tabResult[] = $grades;
}
}
function __construct($requete, &$tabResult, $parametres)
{
$dbh = ConnexionBDD::getInstance();
$stmt = $dbh->prepareEtExecuteRequete($dbh, $requete, $parametres);
while ($row = $stmt->fetch()) {
try {
$id = $row['id'];
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$titre = stripslashes($row['titre']);
} catch (Exception $e) {
echo $e->getMessage();
}
try {
$url = $row['url'];
} catch (Exception $e) {
echo $e->getMessage();
}
$album = new Album($id, $titre, $url);
$tabResult[] = $album;
}
}
