# HG changeset patch # User Franck Deroche # Date 1543782647 -3600 # Node ID 2a03eac5e9ca453f52ba387592b5847d3d1c0f79 # Parent 0a57d5321383696303a49fd95a9efeb114581ceb index.php: Refactor pour utiliser Requete diff -r 0a57d5321383 -r 2a03eac5e9ca index.php --- a/index.php Tue Nov 20 00:59:57 2018 +0100 +++ b/index.php Sun Dec 02 21:30:47 2018 +0100 @@ -1,8 +1,11 @@ varSet('mode', 'GET')) { $query = " SELECT * FROM Mess @@ -11,10 +14,10 @@ LIMIT 10 "; $sk->setTitle('Dual { v10 : OS Edition } Blog'); - } elseif($_GET['mode'] == 'cal') { + } elseif($request->get('mode') == 'cal') { $sk->showCalendar(true); - $year = intval($_GET['year']); - $month = intval($_GET['month']); + $year = intval($request->get('year')); + $month = intval($request->get('month')); $sk->setCalendarMonth($month, $year); $sk->setTitle(TextUtils::getMonthName($month) . " $year - Dual Blog"); $query = " @@ -26,19 +29,18 @@ ORDER BY num_mess DESC LIMIT 10 "; - } elseif($_GET['mode'] == 'tag') { - $tag = $_GET['tag']; + } elseif($request->get('mode') == 'tag') { + $tag = $request->get('tag'); $sk->setTitle("Tag: $tag - Dual Blog"); $query = " SELECT * FROM Mess m LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess LEFT JOIN Tags t ON l.idTag = t.idTag - WHERE t.Tag='{$_GET['tag']}' + WHERE t.Tag='{$tag}' ORDER BY num_mess DESC "; } - $db = Factory::getDB(); $db->query($query); while($row = $db->GetRow()) { $post = new Post($row);