$db = mysql_connect("localhost", "inter486", "d4mn1t12"); mysql_select_db("inter486_concours12",$db); $maintenant=date("Y-m-d"); $jour=$maintenant; $fois=0; $compteur=0; $nettoyage="delete from concours where dateFin<'$maintenant'"; $rss=mysql_query($nettoyage); $today = date ("Y-m-d", mktime(0,0,0,date("m"),date("d")-5,date("Y"))); $lstTri="Alpha"; $ordre="alphabetique"; if(isset($_GET['lstTri'])){ $lstTri=$_GET['lstTri']; } $classement="liste"; switch ($lstTri){ case "Alpha": $Alpha="selected"; $ordre="alphabetique"; break; case "DateDec": $DateDec="selected"; $ordre="de date de début décroissant"; break; case "DateCr": $DateCr="selected"; $ordre="de date de début croissant"; break; case "DateFDec": $DateFDec="selected"; $ordre="de date de fin décroissant"; break; case "DateFCr": $DateFCr="selected"; $ordre="de date de fin croissant"; break; case "VisiteD": $VisiteD="selected"; $ordre="du plus visité"; break; case "VisiteC": $VisiteC="selected"; $ordre="du moins visité"; break; } if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } ?>
|
$total_result=0; $sql = "SELECT * FROM concours order by date1 desc "; //echo $sqlDuJour; $rss1=mysql_query($sql) ; if($rss1 ){ while ($var2=mysql_fetch_row($rss1)){ $total_result=$total_result+1; } } echo "un total de ".$total_result." concours trouvés"; $max_results = 10; $from = (($page * $max_results) - $max_results); if ($lstTri=="Alpha" ){ $sqlDuJour = "SELECT * FROM concours order by titre asc limit $from,$max_results"; } if ($lstTri=="DateDec" ){ $sqlDuJour = "SELECT * FROM concours order by date1 desc, Titre asc limit $from,$max_results"; } if ($lstTri=="DateCr" ){ $sqlDuJour = "SELECT * FROM concours order by date1 asc, Titre asc limit $from,$max_results"; } if ($lstTri=="DateFDec" ){ $sqlDuJour = "SELECT * FROM concours order by dateFin desc, Titre asc limit $from,$max_results"; } if ($lstTri=="DateFCr" ){ $sqlDuJour = "SELECT * FROM concours order by dateFin asc, Titre asc limit $from,$max_results"; } if ($lstTri=="VisiteD" ){ $sqlDuJour = "SELECT * FROM concours order by click desc, Titre asc limit $from,$max_results"; } if ($lstTri=="VisiteC" ){ $sqlDuJour = "SELECT * FROM concours order by click asc, Titre asc limit $from,$max_results"; } //$sqlDuJour = "SELECT * FROM concours where date1>='$today' order by date1 desc limit $from,$max_results"; //echo $sqlDuJour; $rs2=mysql_query($sqlDuJour) ; if(!$rs2 ){ echo "Actuellement vide"; }else{ while ($var2=mysql_fetch_row($rs2)){ $compteur++; if ($var2[8]=="quotidien"){ $frequence="Participation quotidienne"; $couleur="red"; } if ($var2[8]=="hebdo"){ $frequence="Participation hebdomadaire"; $couleur="black"; } if ($var2[8]=="unique"){ $frequence="Participation unique"; $couleur="orange"; } if ($var2[8]!="unique" && $var2[8] !="quotidien" && $var2[8]!="hebdo"){ $frequence="Participation mensuel"; $couleur="gray"; } $jour=$var2[7]; $compte++; if($compte==2){ $img="img07.gif" ; $compte=0; }else{ $img="img05.gif"; } $var2[1]=$content = mb_convert_encoding($var2[1], 'UTF-8'); $var2[2]=$content = mb_convert_encoding($var2[2], 'UTF-8'); ?>
|
"; if($page > 1){ $prev = ($page - 1); echo "Précédent "; } $fr=$page-5; $dd=5; if($fr<1){ $fr=1; } if($page==1){ $dd=9; } if($page==2){ $dd=8; } if($page==3){ $dd=7; } if($page==4){ $dd=6; } if($dd+$page>$total_pages){ $dd=$total_pages-$page; } $next = ($page + 1); for($i = $fr; $i <= $page+$dd; $i++){ if(($page) == $i){ echo "[$i] "; } else { echo "$i "; } } if($page < $total_pages){ $next = ($page + 1); echo "Suivant>>"; } echo " |