changeset 6:2ea1b19e21f3

Reformatage des requetes, on parcoure toujours l'integralité du recordset. On respecte maintenant la limite de 80 caractères sur les différentes requetes d'une part, et on limite directement à 10 le nombre de post dans la requete de base de façon a ne pas devoir le faire en PHP ensuite (simplification du code et amelioration des performances).
author Franck Deroche <webmaster@defr.org>
date Sat, 20 Oct 2007 17:03:08 +0200
parents 5bfffcb2624b
children e4e880f786d4
files index.php
diffstat 1 files changed, 14 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/index.php	Sat Oct 20 16:58:13 2007 +0200
+++ b/index.php	Sat Oct 20 17:03:08 2007 +0200
@@ -12,11 +12,19 @@
      $Data = new DataAccess;
      include("top.php");
      $Data->Connect();
-     if($type != "cal") 
-	$Data->Query("SELECT * FROM Mess Where num_version='Version 10' ORDER BY num_mess DESC");
-     else
-	$Data->Query("SELECT * FROM Mess WHERE YEAR(DatePost)={$year} AND MONTH(DatePost)={$month} ORDER BY num_mess DESC");
-     $i=0;
+     $query = ($type != 'cal') ?
+     "	SELECT * 
+	FROM Mess 
+        WHERE num_version='Version 10'
+        ORDER BY num_mess DESC
+        LIMIT 10
+     " : "
+        SELECT * 
+        FROM Mess 
+        WHERE YEAR(DatePost)={$year} AND MONTH(DatePost)={$month} 
+        ORDER BY num_mess DESC
+     ";
+     $Data->query($query);
      if($type == "cal") {
 	echo("<div class='cal'>");
 	if($prevYear > $startDate['year'] - 1 || ($prevYear > $startDate['Year'] - 2 && $prevMonth > $startDate['month'] - 1))
@@ -29,7 +37,7 @@
 	    echo("<a class='calNext'>{$arMonth[$month%12]} {$nextYear}</a>");
 	echo("{$arMonth[$month - 1]} {$year}</div> ");
     }
-    while(($row=$Data->GetRow()) && ($i++<10 || $type == "cal")) {
+    while($row=$Data->GetRow()) {
     $mood = '';
     $Mess=$Data->utf8_ensure(str_replace("<P>","<p>",str_replace("</P>","</p>", $row['Message'])));
     $dateFormatee = strftime("%A %d %B %Y, %Hh%M", strtotime($row['DatePost']));