";
echo"Galerie de Photos
";
function eacheone($albumid){
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
$query=("SELECT * FROM evenementsmedia where albumid='".$albumid."' AND status='1' order by ordre ASC LIMIT 1");
$result=mysqli_query($conn,$query) or die(mysqli_error($conn));
$num_rows=mysqli_num_rows($result);
if($num_rows==true){
$data=mysqli_fetch_object($result);
$id=$data->id;
$titre=$data->titre;
$retour ="![\"".$titre."\"](\"/info/images/gallery/img_300_".$id.".jpg\")
";
}else{
$retour ="![\"".$titre."\"](\"/info/images/album/cover-300-".$albumid.".jpg\")
";
}
return $retour;
}
function albums(){
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
$query=("SELECT DISTINCT u.albumid,e.datedeb, e.titre FROM evenementsmedia u, evenements e WHERE u.albumid=e.id ORDER BY datedeb DESC");
$result=mysqli_query($conn,$query) or die(mysqli_error($conn));
$num_rows=mysqli_num_rows($result);
if($num_rows==true){
while ($row = mysqli_fetch_array($result)) {
echo"";
}
}
}
//echo"Nos événements
";
//albums();
function eacheoneother($albumid){
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
$query=("SELECT * FROM remedia where albumid='".$albumid."' AND status='1' order by ordre ASC LIMIT 1");
$result=mysqli_query($conn,$query) or die(mysqli_error($conn));
$num_rows=mysqli_num_rows($result);
if($num_rows==true){
$data=mysqli_fetch_object($result);
$id=$data->id;
$titre=$data->titre;
$retour ="![\"".$titre."\"](\"/info/images/albums/photo-300X200-".$id.".jpg\")
";
}else{
$retour ="![\"".$titre."\"](\"/info/images/albums/cover-300-".$albumid.".jpg\")
";
}
return $retour;
}
function autresalbums(){
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_eyar.php");
include($_SERVER['DOCUMENT_ROOT']."/test/databases/new/db_vekirin.php");
$query=("SELECT * FROM galerie WHERE status='1' ORDER BY datetime DESC");
$result=mysqli_query($conn,$query) or die(mysqli_error($conn));
$num_rows=mysqli_num_rows($result);
if($num_rows==true){
while ($row = mysqli_fetch_array($result)) {
echo"";
}
}
}
echo"
";
echo"
Autres albums
";
autresalbums();
echo"";
include($_SERVER['DOCUMENT_ROOT']."/reveber/db_girtin.php");
echo"
";
include($_SERVER['DOCUMENT_ROOT']."/x_footer.php");
/*
$tampon = ob_get_contents();
$tampon = str_replace(array("\n", "\r", "\t"), "", $tampon);
file_put_contents("$cache", $tampon) ; //pour une meilleure organisation, on créera un répertoire cache pour y stocker les fichiers du cache
ob_end_clean(); // toujours fermer et vider le tampon
header("Refresh: 1; URL=".$_SERVER['REQUEST_URI']);
}
*/
?>