function afficherListePhotos() { //requete sql if ($this->numpara) { $result = mysql_query("SELECT numphoto,legende,numparaphoto FROM if_para_photo WHERE numpara='{$this->numpara}' ORDER BY ordre"); while ($row = mysql_fetch_row($result)) { $unePhoto = new Photo(); $unePhoto->numphoto = $row[0]; $unePhoto->legendePhoto = $row[1]; $unePhoto->numparaphoto = $row[2]; $unePhoto->infosPhoto(); $this->photos[] = $unePhoto; } } else { $result = mysql_query("SELECT numphoto FROM if_photo ORDER BY nom_photo"); while ($row = mysql_fetch_row($result)) { $unePhoto = new Photo(); $unePhoto->numphoto = $row[0]; $unePhoto->infosPhoto(); $this->photos[] = $unePhoto; } } if (count($this->photos) >= 1) { return true; } }
if ($numlien) { $leLien = new Lien(); $leLien->numlien = $numlien; $leLien->infosLien(); } else { if ($numfichier) { $leFichier = new Fichier(); $leFichier->numfichier = $numfichier; $leFichier->numparafichier = $numparafichier; $leFichier->infosFichier(); } else { if ($numphoto) { $laPhoto = new Photo(); $laPhoto->numphoto = $numphoto; $laPhoto->numparaphoto = $numparaphoto; $laPhoto->infosPhoto(); } else { if ($numvideo) { $laVideo = new Video(); $laVideo->numvideo = $numvideo; $laVideo->numparavideo = $numparavideo; $laVideo->infosVideo(); } } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
/** * Va répérer toutes les infos concernant la page. * Va remplir toutes les propriétés de l'objet page pas leur équivalent dans la Bdd. */ function infosPage() { if ($this->numpage) { $row = SelectMultiple("if_page", "numpage", $this->numpage); } else { $row = SelectMultiple("if_page", "accueil_site", "o", "AND publiee='o' AND lg='{$this->lg}'"); $this->numpage = $row["numpage"]; } $this->lg = $row["lg"]; $this->nomPageGoogle = $row["nom"]; $this->titrePage = miseEnForme($row["titre"]); $this->descrPage = $row["description"]; $this->keywPage = $row["keywords"]; $this->aliasPage = $row["alias"]; $this->hcreaPage = $row["hcrea"]; $this->hmodifPage = $row["hmodif"]; $this->publiePage = $row["publiee"]; $this->accueilPage = $row["accueil"]; $this->accueilSite = $row["accueil_site"]; $this->id_c = $row["iduti_c"]; $this->id_m = $row["iduti_m"]; if ($row["iduti_m"]) { $riw = SelectMultiple("if_utilisateur", "iduti", $row["iduti_m"]); } else { $riw = SelectMultiple("if_utilisateur", "iduti", $row["iduti_c"]); } $this->auteur = $riw["prenom"] . " " . $riw["nom"]; $this->nomFichier = $row["specifique"]; //La bandeau photo de la page $laPhoto = new Photo(); $laPhoto->numphoto = $row["numphoto"]; $laPhoto->infosPhoto(); $this->nomPhoto = $laPhoto->nomPhoto; //A quelles rubriques, catégories, et sous-catégories est liée la page ? $leMenu = new Menu(); $leMenu->type = "sscateg"; $leMenu->champ = "numpage"; $leMenu->valeur = $this->numpage; $row = $leMenu->isMenu(); $result = mysql_query("SELECT if_categorie.numrub,if_sscateg.numcateg,if_sscateg.numsscateg FROM if_categorie,if_sscateg WHERE if_sscateg.numpage='{$this->numpage}' AND if_sscateg.numcateg=if_categorie.numcateg"); if (mysql_numrows($result) > 0) { while ($row = mysql_fetch_row($result)) { $this->list_numsscateg[] = $row[2]; $this->numsscateg = $row[2]; $this->numcateg = $row[1]; $this->numrub = $row[0]; } } $result = mysql_query("SELECT numrub,numcateg FROM if_categorie WHERE numpage='{$this->numpage}'"); if (mysql_numrows($result) > 0) { while ($row = mysql_fetch_row($result)) { $this->list_numcateg[] = $row[1]; if (!$this->numcateg) { $this->numcateg = $row[1]; } if (!$this->numrub) { $this->numrub = $row[0]; } } } $result = mysql_query("SELECT numrub FROM if_rubrique WHERE numpage='{$this->numpage}'"); if (mysql_numrows($result) > 0) { while ($row = mysql_fetch_row($result)) { $this->list_numrub[] = $row[0]; if (!$this->numrub) { $this->numrub = $row[0]; } } //fin du while } //fin du if }