annotate index.php @ 86:2a03eac5e9ca

index.php: Refactor pour utiliser Requete
author Franck Deroche <franck@defr.org>
date Sun, 02 Dec 2018 21:30:47 +0100
parents f6552a610bfd
children
rev   line source
webmaster@0 1 <?php
webmaster@11 2 require_once("classes.php");
webmaster@11 3 $sk = Factory::getSkeleton();
franck@86 4 $request = Factory::getRequete();
franck@86 5 $db = Factory::getDB();
franck@86 6
webmaster@11 7 // Détermination de la requête à exécuter
franck@86 8 if(!$request->varSet('mode', 'GET')) {
webmaster@11 9 $query = "
webmaster@11 10 SELECT *
webmaster@11 11 FROM Mess
webmaster@6 12 WHERE num_version='Version 10'
webmaster@6 13 ORDER BY num_mess DESC
webmaster@6 14 LIMIT 10
webmaster@11 15 ";
webmaster@44 16 $sk->setTitle('Dual { v10 : OS Edition } Blog');
franck@86 17 } elseif($request->get('mode') == 'cal') {
webmaster@11 18 $sk->showCalendar(true);
franck@86 19 $year = intval($request->get('year'));
franck@86 20 $month = intval($request->get('month'));
webmaster@11 21 $sk->setCalendarMonth($month, $year);
webmaster@44 22 $sk->setTitle(TextUtils::getMonthName($month) . " $year - Dual Blog");
webmaster@11 23 $query = "
webmaster@6 24 SELECT *
webmaster@11 25 FROM Mess
webmaster@11 26 WHERE
webmaster@11 27 YEAR(DatePost) = $year AND
webmaster@11 28 MONTH(DatePost) = $month
webmaster@6 29 ORDER BY num_mess DESC
webmaster@11 30 LIMIT 10
webmaster@11 31 ";
franck@86 32 } elseif($request->get('mode') == 'tag') {
franck@86 33 $tag = $request->get('tag');
webmaster@44 34 $sk->setTitle("Tag: $tag - Dual Blog");
webmaster@11 35 $query = "
webmaster@11 36 SELECT *
webmaster@11 37 FROM Mess m
webmaster@11 38 LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess
webmaster@11 39 LEFT JOIN Tags t ON l.idTag = t.idTag
franck@86 40 WHERE t.Tag='{$tag}'
webmaster@11 41 ORDER BY num_mess DESC
webmaster@11 42 ";
webmaster@0 43 }
webmaster@27 44 $db->query($query);
webmaster@11 45 while($row = $db->GetRow()) {
webmaster@11 46 $post = new Post($row);
webmaster@11 47 $sk->addBlogPost($post->format());
webmaster@36 48 $sk->checkUpdateTime(strtotime($row['DatePost']));
webmaster@0 49 }
webmaster@11 50 echo $sk;
webmaster@0 51 ?>