brunobmorais / php-database

src/CrudBuilder.php

Spacing +16 added lines, -16 removed lines

@@ -187,7 +187,7 @@ 
     protected function orderBy(string $parameter, ?string $order = null): self

     {

         try {

-            $query = "ORDER BY {$parameter} ".($order ?? 'ASC');

+            $query = "ORDER BY {$parameter} " . ($order ?? 'ASC');

             $this->add($query, "orderBy");

             return $this;

         } catch (\PDOException $e) {

@@ -203,7 +203,7 @@ 
     protected function addOrderBy(string $parameter, ?string $order = null): self

     {

         try {

-            $query = ", {$parameter} ".($order ?? 'ASC')." ";

+            $query = ", {$parameter} " . ($order ?? 'ASC') . " ";

             $this->add($query, "addOrderBy");

             return $this;

         } catch (\PDOException $e) {

@@ -218,7 +218,7 @@ 
     protected function limit(string $texto): self

     {

         $query = "LIMIT {$texto}";

-        $this->add($query,"limit");

+        $this->add($query, "limit");

         return $this;

     }

 

@@ -230,7 +230,7 @@ 
     {

         try {

             $query = "OFFSET {$texto}";

-            $this->add($query,"offset");

+            $this->add($query, "offset");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -245,7 +245,7 @@ 
     {

         try {

             $query = "GROUP BY {$texto}";

-            $this->add($query,"groupBy");

+            $this->add($query, "groupBy");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -260,7 +260,7 @@ 
     {

         try {

             $query = "HAVING {$texto}";

-            $this->add($query,"having");

+            $this->add($query, "having");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -275,7 +275,7 @@ 
     {

         try {

             $query = "AND {$texto}";

-            $this->add($query,"andHaving");

+            $this->add($query, "andHaving");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -290,7 +290,7 @@ 
     {

         try {

             $query = "OR {$codition}";

-            $this->add($query,"orHaving");

+            $this->add($query, "orHaving");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -307,7 +307,7 @@ 
     {

         try {

             $query = "INNER JOIN {$table} AS {$alias} ON $codition";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -324,7 +324,7 @@ 
     {

         try {

             $query = "LEFT JOIN {$table} AS {$alias} ON {$codition}";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -341,7 +341,7 @@ 
     {

         try {

             $query = "RIGHT JOIN {$table} AS {$alias} ON $codition";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -354,13 +354,13 @@ 
     protected function executeQuery(): self

     {

         try {

-            foreach ($this->sqlPartsSelect as $key => $part){

+            foreach ($this->sqlPartsSelect as $key => $part) {

                 if (is_array($part)) {

-                    foreach ($part as $item){

-                        $this->setQuery($this->getQuery().$item);

+                    foreach ($part as $item) {

+                        $this->setQuery($this->getQuery() . $item);

                     }

                 } else {

-                    $this->setQuery($this->getQuery().$part);

+                    $this->setQuery($this->getQuery() . $part);

                 }

 

             }

@@ -394,7 +394,7 @@ 
      */

     private function add(string $query, string $type, array $params = []): void

     {

-        $query = $query." ";

+        $query = $query . " ";

         try {

             if (is_array($this->sqlPartsSelect[$type])) {

                 $this->sqlPartsSelect[$type][] = $query;

src/Crud.php

Spacing +4 added lines, -4 removed lines

@@ -27,7 +27,7 @@ 
      */

     public function select(string $fields = '*', string $add = '', ?array $values = null, bool $returnModel = false, bool $debug = false)

     {

-        if (strlen($add) > 0) {

+        if (strlen($add)>0) {

             $add = ' ' . $add;

         }

 

@@ -66,7 +66,7 @@ 
         $numparams = substr($numparams, 1);

         $sql = "INSERT INTO {$this->getTableName()} ({$fields}) VALUES ({$numparams})";

         if ($debug) {

-            echo $sql.'<pre>'.print_r($values).'</pre>';

+            echo $sql . '<pre>' . print_r($values) . '</pre>';

             return;

         }

         $result = $this->executeSQL($sql, $values);

@@ -145,7 +145,7 @@ 
             $sql .= " WHERE $where";

         }

         if ($debug) {

-            echo $sql.'<pre>'.print_r($values).'</pre>';

+            echo $sql . '<pre>' . print_r($values) . '</pre>';

             return;

         }

         $result = $this->executeSQL($sql, $values);

@@ -217,7 +217,7 @@ 
             $sql .= " WHERE $where";

         }

         if ($debug) {

-            echo $sql.'<pre>'.print_r($values).'</pre>';

+            echo $sql . '<pre>' . print_r($values) . '</pre>';

             return;

         }

         $result = $this->executeSQL($sql, $values);