Add new page popular topics.

1 files changed, 16 insertions, 0 deletions

diff --git a/app/Http/Controllers/IndexController.php b/app/Http/Controllers/IndexController.php
index cb401b5..bb1d301 100644
--- a/app/Http/Controllers/IndexController.php
+++ b/app/Http/Controllers/IndexController.php
@@ -104,4 +104,20 @@ class IndexController extends Controller
 
             return view('list', ["articles" => $articles, "count" => $count]);
     }
+
+    public function populartopics() {
+	    $topics = DB::select("
+			SELECT
+			    c.name,
+			    count(c.name) AS count
+			FROM category AS c
+			JOIN
+				article_category AS ac ON c.id = ac.category_id
+			GROUP BY
+				c.name
+			ORDER BY count(c.name) DESC;");
+#echo "<pre>"; var_dump($topics);exit;
+
+	    return view('topicpopular', ['topics' => $topics ]);
+    }
 }