ejessyp / flowerflow

htdocs/cimage/img.php

Spacing +63 added lines, -63 removed lines

@@ -11,7 +11,7 @@ 
 /**
  * Custom exception handler.
  */
-set_exception_handler(function ($exception) {
+set_exception_handler(function($exception) {
     errorPage(
         "<p><b>img.php: Uncaught exception:</b> <p>"
         . $exception->getMessage()
@@ -28,7 +28,7 @@ 
  * Get configuration options from file, if the file exists, else use $config
  * if its defined or create an empty $config.
  */
-$configFile = __DIR__.'/'.basename(__FILE__, '.php').'_config.php';
+$configFile = __DIR__ . '/' . basename(__FILE__, '.php') . '_config.php';
 
 if (is_file($configFile)) {
     $config = require $configFile;
@@ -47,11 +47,11 @@ 
  * Setup the autoloader, but not when using a bundle.
  */
 if (!defined("CIMAGE_BUNDLE")) {
-    if (!isset($config["autoloader"])) {
+    if (!isset($config[ "autoloader" ])) {
         die("CImage: Missing autoloader.");
     }
 
-    require $config["autoloader"];
+    require $config[ "autoloader" ];
 }
 
 
@@ -88,7 +88,7 @@ 
 }
 
 // Specific settings for each mode
-if ($mode == 'strict') {
+if ($mode=='strict') {
 
     error_reporting(0);
     ini_set('display_errors', 0);
@@ -97,7 +97,7 @@ 
     $status = false;
     $verboseFile = false;
 
-} elseif ($mode == 'production') {
+} elseif ($mode=='production') {
 
     error_reporting(-1);
     ini_set('display_errors', 0);
@@ -106,14 +106,14 @@ 
     $status = false;
     $verboseFile = false;
 
-} elseif ($mode == 'development') {
+} elseif ($mode=='development') {
 
     error_reporting(-1);
     ini_set('display_errors', 1);
     ini_set('log_errors', 0);
     $verboseFile = false;
 
-} elseif ($mode == 'test') {
+} elseif ($mode=='test') {
 
     error_reporting(-1);
     ini_set('display_errors', 1);
@@ -155,20 +155,20 @@ 
 if ($pwd) {
     switch ($pwdType) {
         case 'md5':
-            $passwordMatch = ($pwdConfig === md5($pwd));
+            $passwordMatch = ($pwdConfig===md5($pwd));
             break;
         case 'hash':
             $passwordMatch = password_verify($pwd, $pwdConfig);
             break;
         case 'text':
-            $passwordMatch = ($pwdConfig === $pwd);
+            $passwordMatch = ($pwdConfig===$pwd);
             break;
         default:
             $passwordMatch = false;
     }
 }
 
-if ($pwdAlways && $passwordMatch !== true) {
+if ($pwdAlways && $passwordMatch!==true) {
     errorPage("Password required and does not match or exists.", 403);
 }
 
@@ -184,19 +184,19 @@ 
 $allowHotlinking = getConfig('allow_hotlinking', true);
 $hotlinkingWhitelist = getConfig('hotlinking_whitelist', array());
 
-$serverName  = isset($_SERVER['SERVER_NAME']) ? $_SERVER['SERVER_NAME'] : null;
-$referer     = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : null;
+$serverName  = isset($_SERVER[ 'SERVER_NAME' ]) ? $_SERVER[ 'SERVER_NAME' ] : null;
+$referer     = isset($_SERVER[ 'HTTP_REFERER' ]) ? $_SERVER[ 'HTTP_REFERER' ] : null;
 $refererHost = parse_url($referer, PHP_URL_HOST);
 
 if (!$allowHotlinking) {
     if ($passwordMatch) {
         ; // Always allow when password match
         verbose("Hotlinking since passwordmatch");
-    } elseif ($passwordMatch === false) {
+    } elseif ($passwordMatch===false) {
         errorPage("Hotlinking/leeching not allowed when password missmatch.", 403);
     } elseif (!$referer) {
         errorPage("Hotlinking/leeching not allowed and referer is missing.", 403);
-    } elseif (strcmp($serverName, $refererHost) == 0) {
+    } elseif (strcmp($serverName, $refererHost)==0) {
         ; // Allow when serverName matches refererHost
         verbose("Hotlinking disallowed but serverName matches refererHost.");
     } elseif (!empty($hotlinkingWhitelist)) {
@@ -283,7 +283,7 @@ 
  */
 $allowRemote = getConfig('remote_allow', false);
 
-if ($allowRemote && $passwordMatch !== false) {
+if ($allowRemote && $passwordMatch!==false) {
     $cacheRemote = $cache->getPathToSubdir("remote");
     
     $pattern = getConfig('remote_pattern', null);
@@ -307,10 +307,10 @@ 
 verbose("shortcut = $shortcut");
 
 if (isset($shortcut)
-    && isset($shortcutConfig[$shortcut])) {
+    && isset($shortcutConfig[ $shortcut ])) {
 
-    parse_str($shortcutConfig[$shortcut], $get);
-    verbose("shortcut-constant = {$shortcutConfig[$shortcut]}");
+    parse_str($shortcutConfig[ $shortcut ], $get);
+    verbose("shortcut-constant = {$shortcutConfig[ $shortcut ]}");
     $_GET = array_merge($_GET, $get);
 }
 
@@ -345,7 +345,7 @@ 
 preg_match($validFilename, $srcImage)
     or errorPage('Source filename contains invalid characters.', 404);
 
-if ($dummyEnabled && $srcImage === $dummyFilename) {
+if ($dummyEnabled && $srcImage===$dummyFilename) {
 
     // Prepare to create a dummy image and use it as the source image.
     $dummyImage = true;
@@ -368,7 +368,7 @@ 
         preg_match($validFilename, $srcImage)
             or errorPage('Source (alt) filename contains invalid characters.', 404);
 
-        if ($dummyEnabled && $srcImage === $dummyFilename) {
+        if ($dummyEnabled && $srcImage===$dummyFilename) {
             // Check if src-alt is the dummy image
             $dummyImage = true;
         }
@@ -388,7 +388,7 @@ 
     // Check that the image is a file below the directory 'image_path'.
     $imageDir = realpath($imagePath);
 
-    substr_compare($imageDir, $pathToImage, 0, strlen($imageDir)) == 0
+    substr_compare($imageDir, $pathToImage, 0, strlen($imageDir))==0
         or errorPage(
             'Security constraint: Source image is not below the directory "image_path"
             as specified in the config file img_config.php.',
@@ -404,7 +404,7 @@ 
  * Manage size constants from config file, use constants to replace values
  * for width and height.
  */
-$sizeConstant = getConfig('size_constant', function () {
+$sizeConstant = getConfig('size_constant', function() {
 
     // Set sizes to map constant to value, easier to use with width or height
     $sizes = array(
@@ -418,7 +418,7 @@ 
     $gridColumns     = 24;
 
     for ($i = 1; $i <= $gridColumns; $i++) {
-        $sizes['c' . $i] = ($gridColumnWidth + $gridGutterWidth) * $i - $gridGutterWidth;
+        $sizes[ 'c' . $i ] = ($gridColumnWidth + $gridGutterWidth)*$i - $gridGutterWidth;
     }
 
     return $sizes;
@@ -435,12 +435,12 @@ 
 $maxWidth     = getConfig('max_width', 2000);
 
 // Check to replace predefined size
-if (isset($sizes[$newWidth])) {
-    $newWidth = $sizes[$newWidth];
+if (isset($sizes[ $newWidth ])) {
+    $newWidth = $sizes[ $newWidth ];
 }
 
 // Support width as % of original width
-if ($newWidth && $newWidth[strlen($newWidth)-1] == '%') {
+if ($newWidth && $newWidth[ strlen($newWidth) - 1 ]=='%') {
     is_numeric(substr($newWidth, 0, -1))
         or errorPage('Width % not numeric.', 404);
 } else {
@@ -460,12 +460,12 @@ 
 $maxHeight = getConfig('max_height', 2000);
 
 // Check to replace predefined size
-if (isset($sizes[$newHeight])) {
-    $newHeight = $sizes[$newHeight];
+if (isset($sizes[ $newHeight ])) {
+    $newHeight = $sizes[ $newHeight ];
 }
 
 // height
-if ($newHeight && $newHeight[strlen($newHeight)-1] == '%') {
+if ($newHeight && $newHeight[ strlen($newHeight) - 1 ]=='%') {
     is_numeric(substr($newHeight, 0, -1))
         or errorPage('Height % out of range.', 404);
 } else {
@@ -482,7 +482,7 @@ 
  * aspect-ratio, ar - affecting the resulting image width, height and resize options
  */
 $aspectRatio         = get(array('aspect-ratio', 'ar'));
-$aspectRatioConstant = getConfig('aspect_ratio_constant', function () {
+$aspectRatioConstant = getConfig('aspect_ratio_constant', function() {
     return array(
         '3:1'    => 3/1,
         '3:2'    => 3/2,
@@ -496,15 +496,15 @@ 
 
 // Check to replace predefined aspect ratio
 $aspectRatios = call_user_func($aspectRatioConstant);
-$negateAspectRatio = ($aspectRatio && $aspectRatio[0] == '!') ? true : false;
+$negateAspectRatio = ($aspectRatio && $aspectRatio[ 0 ]=='!') ? true : false;
 $aspectRatio = $negateAspectRatio ? substr($aspectRatio, 1) : $aspectRatio;
 
-if (isset($aspectRatios[$aspectRatio])) {
-    $aspectRatio = $aspectRatios[$aspectRatio];
+if (isset($aspectRatios[ $aspectRatio ])) {
+    $aspectRatio = $aspectRatios[ $aspectRatio ];
 }
 
 if ($negateAspectRatio) {
-    $aspectRatio = 1 / $aspectRatio;
+    $aspectRatio = 1/$aspectRatio;
 }
 
 is_null($aspectRatio)
@@ -565,10 +565,10 @@ 
 
 verbose("fill-to-fit = $fillToFit");
 
-if ($fillToFit !== null) {
+if ($fillToFit!==null) {
 
     if (!empty($fillToFit)) {
-        $bgColor   = $fillToFit;
+        $bgColor = $fillToFit;
         verbose("fillToFit changed bgColor to = $bgColor");
     }
 
@@ -611,7 +611,7 @@ 
 $useOriginal = getDefined(array('skip-original', 'so'), false, true);
 $useOriginalDefault = getConfig('skip_original', false);
 
-if ($useOriginalDefault === true) {
+if ($useOriginalDefault===true) {
     verbose("skip original is default ON");
     $useOriginal = false;
 }
@@ -755,13 +755,13 @@ 
 $filters = array();
 $filter = get(array('filter', 'f'));
 if ($filter) {
-    $filters[] = $filter;
+    $filters[ ] = $filter;
 }
 
 for ($i = 0; $i < 10; $i++) {
     $filter = get(array("filter{$i}", "f{$i}"));
     if ($filter) {
-        $filters[] = $filter;
+        $filters[ ] = $filter;
     }
 }
 
@@ -778,7 +778,7 @@ 
 
 verbose("outputformat = $outputFormat");
 
-if ($outputFormat == 'ascii') {
+if ($outputFormat=='ascii') {
     $defaultOptions = getConfig(
         'ascii-options',
         array(
@@ -791,25 +791,25 @@ 
     $options = get('ascii');
     $options = explode(',', $options);
 
-    if (isset($options[0]) && !empty($options[0])) {
-        $defaultOptions['characterSet'] = $options[0];
+    if (isset($options[ 0 ]) && !empty($options[ 0 ])) {
+        $defaultOptions[ 'characterSet' ] = $options[ 0 ];
     }
 
-    if (isset($options[1]) && !empty($options[1])) {
-        $defaultOptions['scale'] = $options[1];
+    if (isset($options[ 1 ]) && !empty($options[ 1 ])) {
+        $defaultOptions[ 'scale' ] = $options[ 1 ];
     }
 
-    if (isset($options[2]) && !empty($options[2])) {
-        $defaultOptions['luminanceStrategy'] = $options[2];
+    if (isset($options[ 2 ]) && !empty($options[ 2 ])) {
+        $defaultOptions[ 'luminanceStrategy' ] = $options[ 2 ];
     }
 
     if (count($options) > 3) {
         // Last option is custom character string
-        unset($options[0]);
-        unset($options[1]);
-        unset($options[2]);
+        unset($options[ 0 ]);
+        unset($options[ 1 ]);
+        unset($options[ 2 ]);
         $characterString = implode($options);
-        $defaultOptions['customCharacterSet'] = $characterString;
+        $defaultOptions[ 'customCharacterSet' ] = $characterString;
     }
 
     $img->setAsciiOptions($defaultOptions);
@@ -923,7 +923,7 @@ 
 /**
  * Prepare a dummy image and use it as source image.
  */
-if ($dummyImage === true) {
+if ($dummyImage===true) {
     $dummyDir = $cache->getPathToSubdir("dummy");
 
     $img->setSaveFolder($dummyDir)
@@ -983,7 +983,7 @@ 
 if ($status) {
     $text  = "img.php version = " . CIMAGE_VERSION . "\n";
     $text .= "PHP version = " . PHP_VERSION . "\n";
-    $text .= "Running on: " . $_SERVER['SERVER_SOFTWARE'] . "\n";
+    $text .= "Running on: " . $_SERVER[ 'SERVER_SOFTWARE' ] . "\n";
     $text .= "Allow remote images = $allowRemote\n";
 
     $res = $cache->getStatusOfSubdir("");
@@ -1015,10 +1015,10 @@ 
     $no = extension_loaded('gd') ? null : 'NOT';
     $text .= "Extension gd is $no loaded.<br>";
 
-    $text .= checkExternalCommand("PNG LOSSY", $postProcessing["png_lossy"], $postProcessing["png_lossy_cmd"]);
-    $text .= checkExternalCommand("PNG FILTER", $postProcessing["png_filter"], $postProcessing["png_filter_cmd"]);
-    $text .= checkExternalCommand("PNG DEFLATE", $postProcessing["png_deflate"], $postProcessing["png_deflate_cmd"]);
-    $text .= checkExternalCommand("JPEG OPTIMIZE", $postProcessing["jpeg_optimize"], $postProcessing["jpeg_optimize_cmd"]);
+    $text .= checkExternalCommand("PNG LOSSY", $postProcessing[ "png_lossy" ], $postProcessing[ "png_lossy_cmd" ]);
+    $text .= checkExternalCommand("PNG FILTER", $postProcessing[ "png_filter" ], $postProcessing[ "png_filter_cmd" ]);
+    $text .= checkExternalCommand("PNG DEFLATE", $postProcessing[ "png_deflate" ], $postProcessing[ "png_deflate_cmd" ]);
+    $text .= checkExternalCommand("JPEG OPTIMIZE", $postProcessing[ "jpeg_optimize" ], $postProcessing[ "jpeg_optimize_cmd" ]);
 
     if (!$no) {
         $text .= print_r(gd_info(), 1);
@@ -1101,12 +1101,12 @@ 
  */
 if ($verbose) {
     $query = array();
-    parse_str($_SERVER['QUERY_STRING'], $query);
-    unset($query['verbose']);
-    unset($query['v']);
-    unset($query['nocache']);
-    unset($query['nc']);
-    unset($query['json']);
+    parse_str($_SERVER[ 'QUERY_STRING' ], $query);
+    unset($query[ 'verbose' ]);
+    unset($query[ 'v' ]);
+    unset($query[ 'nocache' ]);
+    unset($query[ 'nc' ]);
+    unset($query[ 'json' ]);
     $url1 = '?' . htmlentities(urldecode(http_build_query($query)));
     $url2 = '?' . urldecode(http_build_query($query));
     echo <<<EOD

view/user/login.php

Spacing +2 added lines, -2 removed lines

@@ -10,9 +10,9 @@
 //echo showEnvironment(get_defined_vars(), get_defined_functions());
 
 // Prepare classes
-$classes[] = "article";
+$classes[ ] = "article";
 if (isset($class)) {
-    $classes[] = $class;
+    $classes[ ] = $class;
 }
 ?>
 <article <?= classList($classes) ?>>

view/user/index.php

Spacing +6 added lines, -6 removed lines

@@ -19,19 +19,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>
@@ -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 +8 added lines, -8 removed lines

@@ -24,20 +24,20 @@ 
 ?>
 <?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;
     };
-    $urlToShowPost = url("post/show/$item->id");?>
+    $urlToShowPost = url("post/show/$item->id"); ?>
 
     <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>
@@ -64,14 +64,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/post/view-all.php

Spacing +4 added lines, -4 removed lines

@@ -36,19 +36,19 @@
 ?>
 <?php foreach ($items 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>

view/post/show.php

Spacing +10 added lines, -10 removed lines

@@ -25,7 +25,7 @@ 
         <div><?= Markdown::defaultTransform($post->content) ?></div>
         <div>
             <?php foreach (explode(",", $post->tags) as $tag) :
-                $urlToShowTag = url("tags/show/$tag");?>
+                $urlToShowTag = url("tags/show/$tag"); ?>
             <a class=onetag href="<?= $urlToShowTag ?>"><?= $tag ?></a>
             <?php endforeach; ?>
         </div>
@@ -66,32 +66,32 @@ 
     $urlToReply = url("comment/reply/$answer->id/$post->id");
     $urlToAccept = url("comment/accept/$answer->id/$post->id");
     // get the score for each answer
-    $db =  $this->di->get("db");
+    $db = $this->di->get("db");
     $sql = "select * from v_comments_user where comment_reply_id=?;";
-    $replys= $db->executeFetchAll($sql, [$answer->id]);
+    $replys = $db->executeFetchAll($sql, [ $answer->id ]);
     $sql = "select * from v_comment_votes where comment_id=?;";
-    $commentscore= $db->executeFetchAll($sql, [$answer->id]);
+    $commentscore = $db->executeFetchAll($sql, [ $answer->id ]);
     // Set the accepted button according the status of answer and owner
     // var_dump($status, $answer->accepted);
     if ($isOwner) {
         if ($answer->accepted==0) {
-            $acceptAns="check";
+            $acceptAns = "check";
         } elseif ($answer->accepted==1) {
-            $acceptAns="accepted";
+            $acceptAns = "accepted";
         }
     } else {
         if ($answer->accepted==1) {
-            $acceptAns="accepted";
+            $acceptAns = "accepted";
         } elseif ($answer->accepted==0) {
-            $acceptAns="NoShowAcceptButton";
+            $acceptAns = "NoShowAcceptButton";
         }
     }
     if (!$commentscore) {
         $commentscore = 0;
     } else {
-        $commentscore = $commentscore[0]-> commentscore;
+        $commentscore = $commentscore[ 0 ]-> commentscore;
     }
-    $urlToComment =url("comment/$answer->id");
+    $urlToComment = url("comment/$answer->id");
     // var_dump($acceptAns);?>
 <div class=posts>
     <div class=leftpost>

view/tag/show.php

Spacing +1 added lines, -1 removed lines

@@ -22,7 +22,7 @@
 endif;
 ?>
 <?php foreach ($items as $item) :
-    $urlToShow = url("post/show/$item->id");?>
+    $urlToShow = url("post/show/$item->id"); ?>
 
     <div class=posts>
         <div class=leftpost>

view/home/index.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>

src/Post/PostController.php

Indentation +1 added lines, -1 removed lines

@@ -196,7 +196,7 @@
         }
         $page->add("post/show",
             ["post"  => $posts[0],
-             "postscore"  => $postscore,
+                "postscore"  => $postscore,
             "answers"  => $answers,
             "comments0"  => $comments0,
             "isOwner"  => $isOwner,

Spacing +16 added lines, -16 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,31 +171,31 @@ 
         $orderBy = $request->getGet("orderby") ?: "created";
         $order = $request->getGet("order") ?: "asc";
         $sql = "SELECT * from v_all_user WHERE id=?;";
-        $posts = $this->db->executeFetchAll($sql, [$postid]);
+        $posts = $this->db->executeFetchAll($sql, [ $postid ]);
 
         $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 ]);
 
         $sql = "select * from v_post_votes where post_id=?;";
-        $postscore = $this->db->executeFetchAll($sql, [$postid]);
+        $postscore = $this->db->executeFetchAll($sql, [ $postid ]);
         // var_dump($answers);
         if (!$postscore) {
             $postscore = 0;
         } else {
-            $postscore = $postscore[0]-> postscore;
+            $postscore = $postscore[ 0 ]-> postscore;
         }
         // 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],
+            [ "post"  => $posts[ 0 ],
              "postscore"  => $postscore,
             "answers"  => $answers,
             "comments0"  => $comments0,
@@ -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");