Mercurial > defr > DualBlog
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']));