Visiter
$q_contenu = " select * from ".$row_module['table']." where 1 ";
$q_contenu.= " and id=\"".$row_navigation_module['id_table']."\" ";
$q_contenu.= " and date_debut_affichage<=\"".$aujourdhui."\" ";
$q_contenu.= " and date_fin_affichage>=\"".$aujourdhui."\" ";
$r_contenu=mysql_query($q_contenu);
while($row_contenu=mysql_fetch_array($r_contenu)){
if($row_contenu["titre"]!="") { ?> } else { ?> }
if($row_contenu["visuel"]!="" && file_exists($_SERVER['DOCUMENT_ROOT'].$chemin_root.$path_visuel_bdd."/".$row_contenu["visuel"])){
// this is the name of the temporal file created by the PHP engine
$pathinfo=pathinfo($_SERVER['DOCUMENT_ROOT'].$chemin_root.$path_visuel_bdd."/".$row_contenu["visuel"]);
$nom_complet = $pathinfo['basename']; // nom complet
$extension = $pathinfo['extension']; // extension
$nom_fichier = $pathinfo['filename']; // nom fichier sans extension
if(file_exists($_SERVER['DOCUMENT_ROOT'].$chemin_root.$path_visuel_bdd."/".$nom_fichier."_zoom.".$extension)){?>
}else{?>
}
}
if($row_contenu["texte"]!="") { ?> }
if($row_contenu["url_video"]!="") { ?> }
}?>
$q_contenu = " select * from ".$row_module['table']." where 1 ";
$q_contenu.= " and id=\"".$row_navigation_module['id_table']."\" ";
$q_contenu.= " and date_debut_affichage<=\"".$aujourdhui."\" ";
$q_contenu.= " and date_fin_affichage>=\"".$aujourdhui."\" ";
$r_contenu=mysql_query($q_contenu);
while($row_contenu=mysql_fetch_array($r_contenu)){
if($row_contenu["url"]!="") { ?>
}
}?>