comparison 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
comparison
equal deleted inserted replaced
82:0a57d5321383 86:2a03eac5e9ca
1 <?php 1 <?php
2 require_once("classes.php"); 2 require_once("classes.php");
3 $sk = Factory::getSkeleton(); 3 $sk = Factory::getSkeleton();
4 $request = Factory::getRequete();
5 $db = Factory::getDB();
6
4 // Détermination de la requête à exécuter 7 // Détermination de la requête à exécuter
5 if(!array_key_exists('mode', $_GET)) { 8 if(!$request->varSet('mode', 'GET')) {
6 $query = " 9 $query = "
7 SELECT * 10 SELECT *
8 FROM Mess 11 FROM Mess
9 WHERE num_version='Version 10' 12 WHERE num_version='Version 10'
10 ORDER BY num_mess DESC 13 ORDER BY num_mess DESC
11 LIMIT 10 14 LIMIT 10
12 "; 15 ";
13 $sk->setTitle('Dual { v10 : OS Edition } Blog'); 16 $sk->setTitle('Dual { v10 : OS Edition } Blog');
14 } elseif($_GET['mode'] == 'cal') { 17 } elseif($request->get('mode') == 'cal') {
15 $sk->showCalendar(true); 18 $sk->showCalendar(true);
16 $year = intval($_GET['year']); 19 $year = intval($request->get('year'));
17 $month = intval($_GET['month']); 20 $month = intval($request->get('month'));
18 $sk->setCalendarMonth($month, $year); 21 $sk->setCalendarMonth($month, $year);
19 $sk->setTitle(TextUtils::getMonthName($month) . " $year - Dual Blog"); 22 $sk->setTitle(TextUtils::getMonthName($month) . " $year - Dual Blog");
20 $query = " 23 $query = "
21 SELECT * 24 SELECT *
22 FROM Mess 25 FROM Mess
24 YEAR(DatePost) = $year AND 27 YEAR(DatePost) = $year AND
25 MONTH(DatePost) = $month 28 MONTH(DatePost) = $month
26 ORDER BY num_mess DESC 29 ORDER BY num_mess DESC
27 LIMIT 10 30 LIMIT 10
28 "; 31 ";
29 } elseif($_GET['mode'] == 'tag') { 32 } elseif($request->get('mode') == 'tag') {
30 $tag = $_GET['tag']; 33 $tag = $request->get('tag');
31 $sk->setTitle("Tag: $tag - Dual Blog"); 34 $sk->setTitle("Tag: $tag - Dual Blog");
32 $query = " 35 $query = "
33 SELECT * 36 SELECT *
34 FROM Mess m 37 FROM Mess m
35 LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess 38 LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess
36 LEFT JOIN Tags t ON l.idTag = t.idTag 39 LEFT JOIN Tags t ON l.idTag = t.idTag
37 WHERE t.Tag='{$_GET['tag']}' 40 WHERE t.Tag='{$tag}'
38 ORDER BY num_mess DESC 41 ORDER BY num_mess DESC
39 "; 42 ";
40 } 43 }
41 $db = Factory::getDB();
42 $db->query($query); 44 $db->query($query);
43 while($row = $db->GetRow()) { 45 while($row = $db->GetRow()) {
44 $post = new Post($row); 46 $post = new Post($row);
45 $sk->addBlogPost($post->format()); 47 $sk->addBlogPost($post->format());
46 $sk->checkUpdateTime(strtotime($row['DatePost'])); 48 $sk->checkUpdateTime(strtotime($row['DatePost']));