ejessyp / flowerflow

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/TagController1.php

Spacing +2 added lines, -2 removed lines

@@ -85,10 +85,10 @@
     {
         $page = $this->di->get("page");
         $sql = "SELECT * from v_all WHERE find_in_set(?, tags);";
-        $posts = $this->db->executeFetchAll($sql, [$tagname]);
+        $posts = $this->db->executeFetchAll($sql, [ $tagname ]);
         var_dump($posts);
         $page->add("tag/show",
-            ["tagName" => $tagname,
+            [ "tagName" => $tagname,
             "items"  => $posts,
             ]);
 

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>

view/home/index1.php

Spacing +4 added lines, -4 removed lines

@@ -21,19 +21,19 @@
 ?>
 <?php foreach ($posts as $item) :
     $sql = "select * from v_post_votes where post_id=?;";
-    $db =  $this->di->get("db");
-    $score = $db->executeFetchAll($sql, [$item->id]);
+    $db = $this->di->get("db");
+    $score = $db->executeFetchAll($sql, [ $item->id ]);
     if (!$score) {
         $score = 0;
     } else {
-        $score = $score[0]-> postscore;
+        $score = $score[ 0 ]-> postscore;
     }?>
 
     <div class=posts>
         <div class=leftpost>
             <div class=countvotes><?= $score?></div>
             <div class=countvotes>votes</div>
-            <div class=countanswers><?= $item->answer?: 0?></div>
+            <div class=countanswers><?= $item->answer ?: 0?></div>
             <div class=countvotes>answers</div>
         </div>
         <div class=rightpost>