include "privat/connexion.php";
$deb = $_GET['deb'];
$categorie = $_GET['categorie'];
$Requete2="SELECT date, titre"
." FROM DAgaleriemenu WHERE chemin LIKE '%$categorie%'";
$Result2 = mysql_query ($Requete2);
list ($date, $nomcat2) = mysql_fetch_row($Result2);
$nomcat2 = rawurldecode($nomcat2);
if ($nomcat2 != "")
{
$nomcat2 = "- $nomcat2";
}
list($annee,$mois,$jour)=explode("-",$date);
if ($jour != "00")
{
$dateaff="$jour-$mois-$annee";
}
else if ($mois == "12")
{
$mois = "Décembre";
$dateaff = "$mois $annee";
}
else if ($mois == "11")
{
$mois = "Novembre";
$dateaff = "$mois $annee";
}
else if ($mois == "10")
{
$mois = "Octobre";
$dateaff = "$mois $annee";
}
else if ($mois == "09")
{
$mois = "Septembre";
$dateaff = "$mois $annee";
}
else if ($mois == "08")
{
$mois = "Août";
$dateaff = "$mois $annee";
}
else if ($mois == "07")
{
$mois = "Juillet";
$dateaff = "$mois $annee";
}
else if ($mois == "06")
{
$mois = "Juin";
$dateaff = "$mois $annee";
}
else if ($mois == "05")
{
$mois = "Mai";
$dateaff = "$mois $annee";
}
else if ($mois == "04")
{
$mois = "Avril";
$dateaff = "$mois $annee";
}
else if ($mois == "03")
{
$mois = "Mars";
$dateaff = "$mois $annee";
}
else if ($mois == "02")
{
$mois = "Février";
$dateaff = "$mois $annee";
}
else if ($mois == "01")
{
$mois = "Janvier";
$dateaff = "$mois $annee";
}
if ($categorie == "oldschool")
{
$aff = "Photos anciennes";
}
else
{
$aff = "$dateaff $nomcat2";
}
?>
$maxphoto = 24;
$Requete="select COUNT(*) from DAgalerie WHERE categorie='$categorie'";
$Result = mysql_query ($Requete);
error_reporting
(E_ALL & ~E_NOTICE & ~E_WARNING);
list($nbphot)=mysql_fetch_row($Result);
/*
$Requete="SELECT id, date, titre, lien, chemin"
." FROM DAgalerie WHERE categorie = '$categorie' ORDER BY date DESC LIMIT $deb,$maxphoto";
$Result = mysql_query ($Requete);
*/
$Requete2="SELECT idnouv, up, date, titre, commentaire, photo, photoname"
." FROM DAgalerie WHERE categorie = '$categorie' ORDER BY photoname LIMIT $deb,$maxphoto";
$Result2 = mysql_query ($Requete2);
$cpt = 1;
while (list ($idnouv, $up, $date, $titre, $commentaire, $photo, $photoname)
= mysql_fetch_row($Result2))
{
$titre = stripslashes(rawurldecode($titre));
$idnouv=$idnouv*23;
$photo = $photo."mini/".$photoname;
$photo = "images/".$photo;
$titre2 = strtoupper(substr($titre, 0, 1));
$titre = substr($titre, 1);
$titre = $titre2.$titre;
list($annee,$mois,$jour)=explode("-",$date);
list($jour,$heure,$jour)=explode(" ",$jour);
$date="$jour-$mois-$annee";
$test = getimagesize($photo);
$val = 65;
$ratio = ($test[1]/$val);
if ($test[1] == 65)
{
$larg = $test[0];
$haut = $val;
}
else if ($test[0] == 130)
{
$larg = 130;
$haut = 65;
}
?>
|
Vue: echo $up; ?> fois
|
if ( $titre != "" && $commentaire == "ok" )
{
?>
|
if ($cpt == "3")
{
$cpt = 0;
echo " | ";
?>
|
|
|
echo"";
}
else
{
echo "";
}
$cpt = $cpt + 1;
}
?>
if ($nbphot > $maxphoto)
{
$nbpage=$nbphot/$maxphoto;
$arrondi = round( $nbpage );
//echo "nbpage = $nbpage ";
//echo "arrondi = $arrondi ";
if ($nbpage > $arrondi)
{
$max = $arrondi + 2;
}
else
{
$max = $arrondi + 1;
}
$pagemin = $deb-$maxphoto;
if ($pagemin >= 0)
{
echo "<<";
}
while ($min < $max)
{
$page = ($min*$maxphoto)-$maxphoto;
if ($page == $deb)
{
echo "$min";
}
else
{
echo "$min";
}
echo " ";
$min++;
}
$page = $deb+$maxphoto;
if ($page < $nbphot)
{
echo ">>";
}
}
?>
|