diff options
Diffstat (limited to 'app/Http/Controllers/IndexController.php')
| -rw-r--r-- | app/Http/Controllers/IndexController.php | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/app/Http/Controllers/IndexController.php b/app/Http/Controllers/IndexController.php index 824a2e2..f24d1ad 100644 --- a/app/Http/Controllers/IndexController.php +++ b/app/Http/Controllers/IndexController.php @@ -19,7 +19,15 @@ class IndexController extends Controller public function about() { - return view('about'); + $count_articles = DB::Select("SELECT COUNT(*) as count FROM article;")[0]; + $count_discussions = DB::Select("SELECT COUNT(*) as count FROM discussion;")[0]; + $count_comments = DB::Select("SELECT sum(comments) as count FROM discussion;")[0]; + $count_upvotes = DB::Select("SELECT sum(upvotes) as count FROM discussion;")[0]; + return view('about', [ + "count_articles" => $count_articles->count, + "count_discussions" => $count_discussions->count, + "count_comments" => number_format($count_comments->count), + "count_upvotes" => number_format($count_upvotes->count)]); } public function topic( $topic ) |