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