ejessyp / flowerflow

src/Post/PostController1.php

Indentation +2 added lines, -2 removed lines

@@ -195,8 +195,8 @@
         }
         $page->add("post/show",
             ["post"  => $posts[0],
-             "postscore"  => $postscore[0]->postscore?:0,
-             "totalanswer"  => $answer[0]->totalanswer?:0,
+                "postscore"  => $postscore[0]->postscore?:0,
+                "totalanswer"  => $answer[0]->totalanswer?:0,
             "answers"  => $answers,
             "comments0"  => $comments0,
             "isOwner"  => $isOwner,

Spacing +19 added lines, -19 removed lines

@@ -44,10 +44,10 @@ 
         // Connect the database
         $this->db = $this->di->get("db");
         $this->db->connect();
-        if ($this->currentUser !=null) {
+        if ($this->currentUser!=null) {
             $sql = "SELECT id from users where username = ?;";
-            $res = $this->db->executeFetchAll($sql, [$this->currentUser]);
-            $this->userId = $res[0]->id;
+            $res = $this->db->executeFetchAll($sql, [ $this->currentUser ]);
+            $this->userId = $res[ 0 ]->id;
         }
     }
 
@@ -114,13 +114,13 @@ 
             $tags = $request->getPost("Tags") ?: null;
 
             $sql = "INSERT INTO posts (title, content, user_id) VALUES (?, ?, ?);";
-            $this->db->execute($sql, [$title, $content, $this->userId]);
+            $this->db->execute($sql, [ $title, $content, $this->userId ]);
             $lastInsertId = $this->db->lastInsertId();
             var_dump($lastInsertId);
             $tagsArray = explode(",", $tags);
             foreach ($tagsArray as $value) {
                 $sql = "INSERT INTO post2tag (post_id, tag_name) VALUES (?, ?);";
-                $this->db->execute($sql, [$lastInsertId, trim($value)]);
+                $this->db->execute($sql, [ $lastInsertId, trim($value) ]);
             }
 
             return $response->redirect("post");
@@ -146,7 +146,7 @@ 
                 $comment = $request->getPost("answer") ?: null;
 
                 $sql = "INSERT INTO comments (comment, user_id, post_id, answer) VALUES (?, ?, ?, ?);";
-                $this->db->execute($sql, [$comment, $this->userId, $post_id, 1]);
+                $this->db->execute($sql, [ $comment, $this->userId, $post_id, 1 ]);
                 $response = $this->di->get("response");
                 return $response->redirect("post/show/$post_id");
             }
@@ -171,32 +171,32 @@ 
         $orderBy = $request->getGet("orderby") ?: "created";
         $order = $request->getGet("order") ?: "asc";
         $sql = "SELECT * from posts WHERE id=?;";
-        $posts = $this->db->executeFetchAll($sql, [$postid]);
+        $posts = $this->db->executeFetchAll($sql, [ $postid ]);
         $sql = "select * from post2tag where post_id=?;";
-        $posttags = $db->executeFetchAll($sql, [$item->id]);
+        $posttags = $db->executeFetchAll($sql, [ $item->id ]);
         $sql = "SELECT sum(score) as postscore from post_votes where post_id=?;";
-        $score = $this->db->executeFetchAll($sql, [$item->id]);
+        $score = $this->db->executeFetchAll($sql, [ $item->id ]);
         $sql = "SELECT sum(answer) as totalanswer from comments where post_id=?;";
-        $answer = $this->db->executeFetchAll($sql, [$item->id]);
+        $answer = $this->db->executeFetchAll($sql, [ $item->id ]);
 
         $sql = "SELECT * from v_comments_user WHERE post_id=? and answer=1 order by accepted desc, $orderBy $order;";
         //Get the answers for the post
-        $answers = $this->db->executeFetchAll($sql, [$postid]);
+        $answers = $this->db->executeFetchAll($sql, [ $postid ]);
         $sql = "SELECT * from v_comments_user WHERE post_id=? and answer=0 and ISNULL(comment_reply_id);";
         // Get the comments for the post
-        $comments0 = $this->db->executeFetchAll($sql, [$postid]);
+        $comments0 = $this->db->executeFetchAll($sql, [ $postid ]);
 
 
         // check if the current user is the owner of the question, if yes, show the accepted answer button otherwise not
         // var_dump($this->currentUser,$posts[0]->username  );
-        $isOwner=true;
-        if ($this->currentUser != $posts[0]->username ) {
+        $isOwner = true;
+        if ($this->currentUser!=$posts[ 0 ]->username) {
             $isOwner = false;
         }
         $page->add("post/show",
-            ["post"  => $posts[0],
-             "postscore"  => $postscore[0]->postscore?:0,
-             "totalanswer"  => $answer[0]->totalanswer?:0,
+            [ "post"  => $posts[ 0 ],
+             "postscore"  => $postscore[ 0 ]->postscore ?: 0,
+             "totalanswer"  => $answer[ 0 ]->totalanswer ?: 0,
             "answers"  => $answers,
             "comments0"  => $comments0,
             "isOwner"  => $isOwner,
@@ -212,7 +212,7 @@ 
         $page = $this->di->get("page");
 
         $sql = "INSERT INTO post_votes (score, post_id, user_id) VALUES (?, ?, ?);";
-        $this->db->execute($sql, [1, $id, $this->userId]);
+        $this->db->execute($sql, [ 1, $id, $this->userId ]);
 
 
         $response = $this->di->get("response");
@@ -224,7 +224,7 @@ 
         $page = $this->di->get("page");
 
         $sql = "INSERT INTO post_votes (score, post_id, user_id) VALUES (?, ?, ?);";
-        $this->db->execute($sql, [-1, $id, $this->userId]);
+        $this->db->execute($sql, [-1, $id, $this->userId ]);
 
 
         $response = $this->di->get("response");

src/Post/PostController.php

Spacing +21 added lines, -21 removed lines

@@ -44,10 +44,10 @@ 
         // Connect the database
         $this->db = $this->di->get("db");
         $this->db->connect();
-        if ($this->currentUser !=null) {
+        if ($this->currentUser!=null) {
             $sql = "SELECT id from users where username = ?;";
-            $res = $this->db->executeFetchAll($sql, [$this->currentUser]);
-            $this->userId = $res[0]->id;
+            $res = $this->db->executeFetchAll($sql, [ $this->currentUser ]);
+            $this->userId = $res[ 0 ]->id;
         }
     }
 
@@ -120,13 +120,13 @@ 
             $tags = $request->getPost("Tags") ?: null;
 
             $sql = "INSERT INTO posts (title, content, user_id) VALUES (?, ?, ?);";
-            $this->db->execute($sql, [$title, $content, $this->userId]);
+            $this->db->execute($sql, [ $title, $content, $this->userId ]);
             $lastInsertId = $this->db->lastInsertId();
             // var_dump($lastInsertId);
             $tagsArray = explode(",", $tags);
             foreach ($tagsArray as $value) {
                 $sql = "INSERT INTO post2tag (post_id, tag_name) VALUES (?, ?);";
-                $this->db->execute($sql, [$lastInsertId, trim($value)]);
+                $this->db->execute($sql, [ $lastInsertId, trim($value) ]);
             }
 
             return $response->redirect("post");
@@ -152,7 +152,7 @@ 
                 $comment = $request->getPost("answer") ?: null;
 
                 $sql = "INSERT INTO comments (comment, user_id, post_id, answer) VALUES (?, ?, ?, ?);";
-                $this->db->execute($sql, [$comment, $this->userId, $post_id, 1]);
+                $this->db->execute($sql, [ $comment, $this->userId, $post_id, 1 ]);
                 $response = $this->di->get("response");
                 return $response->redirect("post/show/$post_id");
             }
@@ -179,43 +179,43 @@ 
         // Get the post $id , votes and answers and tags and username
         $sql = "SELECT * from posts where id=?;";
 
-        $posts = $this->db->executeFetchAll($sql, [$postid]);
+        $posts = $this->db->executeFetchAll($sql, [ $postid ]);
         $sql = "SELECT username FROM users WHERE id=?;";
-        $username = $this->db->executeFetchAll($sql, [$posts[0]->user_id]);
+        $username = $this->db->executeFetchAll($sql, [ $posts[ 0 ]->user_id ]);
         $sql = "select * from post2tag where post_id=?;";
-        $posttags = $this->db->executeFetchAll($sql, [$postid]);
+        $posttags = $this->db->executeFetchAll($sql, [ $postid ]);
         $sql = "SELECT sum(score) as postscore from post_votes where post_id=?;";
-        $postscore = $this->db->executeFetchAll($sql, [$postid]);
+        $postscore = $this->db->executeFetchAll($sql, [ $postid ]);
         // Get the comments for the post
 
         $sql = "SELECT * from comments WHERE post_id=? and answer=0 and ISNULL(comment_reply_id);";
-        $comments0 = $this->db->executeFetchAll($sql, [$postid]);
+        $comments0 = $this->db->executeFetchAll($sql, [ $postid ]);
         //Get the answers for the post $id
         // $sql = "SELECT * from comments WHERE post_id=? and answer=1 order by accepted desc, $orderBy $order;";
-        $sql ="SELECT c.*, sum(v.score) votes
+        $sql = "SELECT c.*, sum(v.score) votes
                 FROM comments AS c
                     LEFT JOIN comment_votes AS v
                     ON c.id = v.comment_id
                 WHERE post_id=? and answer=1
                 group by id
                 order by accepted desc, $orderBy $order";
-        $answers = $this->db->executeFetchAll($sql, [$postid]);
+        $answers = $this->db->executeFetchAll($sql, [ $postid ]);
         // var_dump($sql);
         // var_dump($answers);
         // check if the current user is the owner of the question, if yes, show the accepted answer button otherwise not
         // var_dump($this->currentUser,$posts[0]->username  );
-        $isOwner=true;
-        if ($this->userId != $posts[0]->user_id ) {
+        $isOwner = true;
+        if ($this->userId!=$posts[ 0 ]->user_id) {
             $isOwner = false;
         }
         $page->add("post/show",
-            ["post"  => $posts[0],
-            "postscore"  => $postscore[0]->postscore?:0,
+            [ "post"  => $posts[ 0 ],
+            "postscore"  => $postscore[ 0 ]->postscore ?: 0,
             "posttags"  => $posttags,
             "answers"  => $answers,
             "comments0"  => $comments0,
             "isOwner"  => $isOwner,
-            "post_owner"  => $username[0]->username,
+            "post_owner"  => $username[ 0 ]->username,
             ]);
 
         return $page->render([
@@ -226,9 +226,9 @@ 
     public function uppvoteAction(int $id) : object
     {
         $page = $this->di->get("page");
-        if ($this->currentUser){
+        if ($this->currentUser) {
             $sql = "INSERT INTO post_votes (score, post_id, user_id) VALUES (?, ?, ?);";
-            $this->db->execute($sql, [1, $id, $this->userId]);
+            $this->db->execute($sql, [ 1, $id, $this->userId ]);
             $response = $this->di->get("response");
             return $response->redirect("post/show/$id");
         }
@@ -241,7 +241,7 @@ 
         $page = $this->di->get("page");
         if ($this->currentUser) {
             $sql = "INSERT INTO post_votes (score, post_id, user_id) VALUES (?, ?, ?);";
-            $this->db->execute($sql, [-1, $id, $this->userId]);
+            $this->db->execute($sql, [-1, $id, $this->userId ]);
 
             $response = $this->di->get("response");
             return $response->redirect("post/show/$id");

src/Comment/CommentController.php

Spacing +13 added lines, -13 removed lines

@@ -44,10 +44,10 @@ 
         // Connect the database
         $this->db = $this->di->get("db");
         $this->db->connect();
-        if ($this->currentUser !=null) {
+        if ($this->currentUser!=null) {
             $sql = "SELECT id from users where username = ?;";
-            $res = $this->db->executeFetchAll($sql, [$this->currentUser]);
-            $this->userId = $res[0]->id;
+            $res = $this->db->executeFetchAll($sql, [ $this->currentUser ]);
+            $this->userId = $res[ 0 ]->id;
         }
     }
 
@@ -61,7 +61,7 @@ 
             if ($submit) {
                 $comment = $request->getPost("comment") ?: null;
                 $sql = "INSERT INTO comments (comment, post_id, user_id, answer) VALUES (?, ?, ?, ?);";
-                $this->db->execute($sql, [$comment, $id, $this->userId, 0]);
+                $this->db->execute($sql, [ $comment, $id, $this->userId, 0 ]);
                 return $response->redirect("post/show/$id");
             }
         }
@@ -74,7 +74,7 @@ 
         $page = $this->di->get("page");
         if ($this->currentUser) {
             $sql = "INSERT INTO comment_votes (score, comment_id, user_id) VALUES (?, ?, ?);";
-            $this->db->execute($sql, [1, $id, $this->userId]);
+            $this->db->execute($sql, [ 1, $id, $this->userId ]);
 
             $response = $this->di->get("response");
             return $response->redirect("post/show/$post_id");
@@ -88,7 +88,7 @@ 
         $page = $this->di->get("page");
         if ($this->currentUser) {
             $sql = "INSERT INTO comment_votes (score, comment_id, user_id) VALUES (?, ?, ?);";
-            $this->db->execute($sql, [-1, $id, $this->userId]);
+            $this->db->execute($sql, [-1, $id, $this->userId ]);
 
             $response = $this->di->get("response");
             return $response->redirect("post/show/$post_id");
@@ -107,16 +107,16 @@ 
         $page = $this->di->get("page");
         //get the status of this answer
         $sql = "select accepted from comments where post_id=? and id=?;";
-        $res = $this->db->executeFetchAll($sql, [$post_id, $id]);
+        $res = $this->db->executeFetchAll($sql, [ $post_id, $id ]);
 
-        if ($res[0]->accepted==0) {
-            $accepted =1;
-        } elseif ($res[0]->accepted==1) {
-            $accepted=0;
+        if ($res[ 0 ]->accepted==0) {
+            $accepted = 1;
+        } elseif ($res[ 0 ]->accepted==1) {
+            $accepted = 0;
         }
         //change the status of this answer
         $sql = "update comments set accepted=? where post_id=? and id=?;";
-        $this->db->execute($sql, [$accepted, $post_id, $id]);
+        $this->db->execute($sql, [ $accepted, $post_id, $id ]);
         $response = $this->di->get("response");
         return $response->redirect("post/show/$post_id");
     }
@@ -137,7 +137,7 @@ 
             if ($submit) {
                 $comment = $request->getPost("comment") ?: null;
                 $sql = "INSERT INTO comments (comment, comment_reply_id, post_id, user_id, answer) VALUES (?, ?, ?, ?, ?);";
-                $this->db->execute($sql, [$comment, $id, $post_id, $this->userId, 0]);
+                $this->db->execute($sql, [ $comment, $id, $post_id, $this->userId, 0 ]);
                 return $response->redirect("post/show/$post_id");
             }
         }

src/Tag/TagController.php

Spacing +2 added lines, -2 removed lines

@@ -85,10 +85,10 @@
     {
         $page = $this->di->get("page");
         $sql = "Select * from posts where id IN (SELECT post_id from post2tag WHERE tag_name=?);;";
-        $posts = $this->db->executeFetchAll($sql, [$tagname]);
+        $posts = $this->db->executeFetchAll($sql, [ $tagname ]);
 
         $page->add("tag/show",
-            ["tagName" => $tagname,
+            [ "tagName" => $tagname,
             "items"  => $posts,
             ]);
 

src/User/UserController.php

Spacing +15 added lines, -15 removed lines

@@ -44,10 +44,10 @@ 
         // Connect the database
         $this->db = $this->di->get("db");
         $this->db->connect();
-        if ($this->currentUser !=null) {
+        if ($this->currentUser!=null) {
             $sql = "SELECT id from users where username = ?;";
-            $res = $this->db->executeFetchAll($sql, [$this->currentUser]);
-            $this->userId = $res[0]->id;
+            $res = $this->db->executeFetchAll($sql, [ $this->currentUser ]);
+            $this->userId = $res[ 0 ]->id;
         }
     }
 
@@ -76,12 +76,12 @@ 
             //Get Posts
             $user_id = $res->id;
             $sql = "SELECT * FROM posts WHERE user_id=?;";
-            $posts = $this->db->executeFetchAll($sql, [$user_id]);
+            $posts = $this->db->executeFetchAll($sql, [ $user_id ]);
 
             // var_dump($posts);
             //Get the answers for the user
             $sql = "SELECT * from comments WHERE user_id=? and answer=1;";
-            $answers = $this->db->executeFetchAll($sql, [$user_id]);
+            $answers = $this->db->executeFetchAll($sql, [ $user_id ]);
             $bonus = 0;
             foreach ($answers as $value) {
                 // var_dump($value->accepted);
@@ -92,19 +92,19 @@ 
 
             // Get the comments for the user
             $sql = "SELECT * from comments WHERE user_id=? and answer=0;";
-            $comments = $this->db->executeFetchAll($sql, [$user_id]);
+            $comments = $this->db->executeFetchAll($sql, [ $user_id ]);
             // var_dump($comments);
-            $reputation = count($posts)*3 + (count($answers)- $bonus)*3 +
+            $reputation = count($posts)*3 + (count($answers) - $bonus)*3 +
             + $bonus*100 + count($comments);
             $page->add("user/index",
-                ["current_user" => $this->currentUser,
+                [ "current_user" => $this->currentUser,
                 "avatar" => $avatar,
                 "reputation" => $reputation,
                 "items"  => $posts,
                 "answers" => $answers,
                 "comments" => $comments,
                 ]);
-            return $page->render(["title" => $title, ]);
+            return $page->render([ "title" => $title, ]);
         }
         $response = $this->di->get("response");
         return $response->redirect("user/login");
@@ -124,11 +124,11 @@ 
         //Get Posts
 
         $sql = "SELECT * from posts WHERE user_id=?;";
-        $posts =  $this->db->executeFetchAll($sql, [$user_id]);
+        $posts = $this->db->executeFetchAll($sql, [ $user_id ]);
         // var_dump($res->email);
         //Get the answers for the user
         $sql = "SELECT * from comments WHERE user_id=? and answer=1;";
-        $answers = $this->db->executeFetchAll($sql, [$user_id]);
+        $answers = $this->db->executeFetchAll($sql, [ $user_id ]);
         $bonus = 0;
         foreach ($answers as $value) {
             if ($value->accepted==1) {
@@ -138,19 +138,19 @@ 
 
         // Get the comments for the user
         $sql = "SELECT * from comments WHERE user_id=? and answer=0;";
-        $comments = $this->db->executeFetchAll($sql, [$user_id]);
+        $comments = $this->db->executeFetchAll($sql, [ $user_id ]);
         // var_dump($comments);
-        $reputation = count($posts)*3 + (count($answers)- $bonus)*3 +
+        $reputation = count($posts)*3 + (count($answers) - $bonus)*3 +
         + $bonus*100 + count($comments);
         $page->add("user/profile",
-            ["user" => $res->username,
+            [ "user" => $res->username,
             "avatar" => $avatar,
             "reputation" => $reputation,
             "posts"  => $posts,
             "answers" => $answers,
             "comments" => $comments,
             ]);
-        return $page->render(["title" => $title, ]);
+        return $page->render([ "title" => $title, ]);
     }
 
     /**

view/user/index.php

Spacing +8 added lines, -8 removed lines

@@ -18,20 +18,20 @@ 
 endif;
 ?>
 <?php foreach ($items as $item) :
-    $db =  $this->di->get("db");
+    $db = $this->di->get("db");
     $sql = "SELECT sum(score) as postscore from post_votes where post_id=?;";
-    $score = $db->executeFetchAll($sql, [$item->id]);
+    $score = $db->executeFetchAll($sql, [ $item->id ]);
     $sql = "select * from post2tag where post_id=?;";
-    $posttags = $db->executeFetchAll($sql, [$item->id]);
+    $posttags = $db->executeFetchAll($sql, [ $item->id ]);
     $sql = "SELECT sum(answer) as totalanswer from comments where post_id=?;";
-    $answer = $db->executeFetchAll($sql, [$item->id]);
+    $answer = $db->executeFetchAll($sql, [ $item->id ]);
     ?>
 
     <div class=posts>
         <div class=leftpost>
-            <div class=countvotes><?= $score[0]->postscore?:0?></div>
+            <div class=countvotes><?= $score[ 0 ]->postscore ?: 0?></div>
             <div class=countvotes>votes</div>
-            <div class=countanswers><?= $answer[0]->totalanswer?: 0?></div>
+            <div class=countanswers><?= $answer[ 0 ]->totalanswer ?: 0?></div>
             <div class=countvotes>answers</div>
         </div>
         <div class=rightpost>
@@ -59,9 +59,9 @@ 
 <table class=table>
     <?php foreach ($answers as $answer):
         if ($answer->accepted==1) {
-            $acceptAns ="accepted";
+            $acceptAns = "accepted";
         } else {
-            $acceptAns ="NoShowAcceptButton";
+            $acceptAns = "NoShowAcceptButton";
         };
     ?>
         <tr>

view/user/profile.php

Spacing +10 added lines, -10 removed lines

@@ -23,21 +23,21 @@ 
 endif;
 ?>
 <?php foreach ($posts as $item) :
-    $db =  $this->di->get("db");
+    $db = $this->di->get("db");
     $sql = "SELECT sum(score) as postscore from post_votes where post_id=?;";
-    $score = $db->executeFetchAll($sql, [$item->id]);
+    $score = $db->executeFetchAll($sql, [ $item->id ]);
     $sql = "select * from post2tag where post_id=?;";
-    $posttags = $db->executeFetchAll($sql, [$item->id]);
+    $posttags = $db->executeFetchAll($sql, [ $item->id ]);
     $sql = "SELECT sum(answer) as totalanswer from comments where post_id=?;";
-    $answer = $db->executeFetchAll($sql, [$item->id]);
+    $answer = $db->executeFetchAll($sql, [ $item->id ]);
 
-    $urlToShowPost = url("post/show/$item->id");?>
+    $urlToShowPost = url("post/show/$item->id"); ?>
 
     <div class=posts>
         <div class=leftpost>
-            <div class=countvotes><?=  $score[0]->postscore?:0?></div>
+            <div class=countvotes><?=  $score[ 0 ]->postscore ?: 0?></div>
             <div class=countvotes>votes</div>
-            <div class=countanswers><?= $answer[0]->totalanswer?: 0?></div>
+            <div class=countanswers><?= $answer[ 0 ]->totalanswer ?: 0?></div>
             <div class=countvotes>answers</div>
         </div>
         <div class=rightpost>
@@ -63,14 +63,14 @@ 
 
     <?php foreach ($answers as $answer):
         if ($answer->accepted==1) {
-            $acceptAns ="accepted";
+            $acceptAns = "accepted";
         } else {
-            $acceptAns ="NoShowAcceptButton";
+            $acceptAns = "NoShowAcceptButton";
         };
         // var_dump($acceptAns);
     ?>
         <div class=profileposts>
-                <a href="<?= url("post/show/{$answer->post_id}"); ?>"><?= Markdown::defaultTransform($answer->comment);?></a>
+                <a href="<?= url("post/show/{$answer->post_id}"); ?>"><?= Markdown::defaultTransform($answer->comment); ?></a>
                 <div class=<?=$acceptAns?>><i class="fa-2x fas fa-check"></i></div>
         </div>
     <?php endforeach; ?>

view/tag/show.php

Spacing +6 added lines, -6 removed lines

@@ -33,21 +33,21 @@
 endif;
 ?>
 <?php foreach ($items as $item) :
-    $db =  $this->di->get("db");
+    $db = $this->di->get("db");
     $sql = "SELECT sum(score) as postscore from post_votes where post_id=?;";
-    $score = $db->executeFetchAll($sql, [$item->id]);
+    $score = $db->executeFetchAll($sql, [ $item->id ]);
     $sql = "select * from post2tag where post_id=?;";
-    $posttags = $db->executeFetchAll($sql, [$item->id]);
+    $posttags = $db->executeFetchAll($sql, [ $item->id ]);
     $sql = "SELECT sum(answer) as totalanswer from comments where post_id=?;";
-    $answer = $db->executeFetchAll($sql, [$item->id]);
+    $answer = $db->executeFetchAll($sql, [ $item->id ]);
     $urlToShowPost = url("post/show/$item->id");
     ?>
 
     <div class=posts>
         <div class=leftpost>
-            <div class=countvotes><?= $score[0]->postscore?:0?></div>
+            <div class=countvotes><?= $score[ 0 ]->postscore ?: 0?></div>
             <div class=countvotes>votes</div>
-            <div class=countanswers><?= $answer[0]->totalanswer?: 0?></div>
+            <div class=countanswers><?= $answer[ 0 ]->totalanswer ?: 0?></div>
             <div class=countvotes>answers</div>
         </div>
         <div class=rightpost>

view/home/index.php

Spacing +6 added lines, -6 removed lines

@@ -20,13 +20,13 @@ 
 endif;
 ?>
 <?php foreach ($posts as $item) :
-    $db =  $this->di->get("db");
+    $db = $this->di->get("db");
     $sql = "SELECT sum(score) as postscore from post_votes where post_id=?;";
-    $score = $db->executeFetchAll($sql, [$item->id]);
+    $score = $db->executeFetchAll($sql, [ $item->id ]);
     $sql = "select * from post2tag where post_id=?;";
-    $posttags = $db->executeFetchAll($sql, [$item->id]);
+    $posttags = $db->executeFetchAll($sql, [ $item->id ]);
     $sql = "SELECT sum(answer) as totalanswer from comments where post_id=?;";
-    $answer = $db->executeFetchAll($sql, [$item->id]);
+    $answer = $db->executeFetchAll($sql, [ $item->id ]);
     // var_dump($answer);
     // if (!$score) {
     //     $score = 0;
@@ -36,9 +36,9 @@ 
 
     <div class=posts>
         <div class=leftpost>
-            <div class=countvotes><?= $score[0]->postscore?: 0 ?></div>
+            <div class=countvotes><?= $score[ 0 ]->postscore ?: 0 ?></div>
             <div class=countvotes>votes</div>
-            <div class=countanswers><?= $answer[0]->totalanswer?: 0?></div>
+            <div class=countanswers><?= $answer[ 0 ]->totalanswer ?: 0?></div>
             <div class=countvotes>answers</div>
         </div>
         <div class=rightpost>