brunobmorais / php-database

src/DatalayerTrait.php

Braces +19 added lines, -10 removed lines

@@ -34,8 +34,9 @@ 
      */

     private function getInstance(): ?PDO

     {

-        if (strpos($_SERVER['SERVER_NAME'], "homologacao") && !strpos($this->database, "Homologacao") )

-            $this->database .= "Homologacao";

+        if (strpos($_SERVER['SERVER_NAME'], "homologacao") && !strpos($this->database, "Homologacao") ) {

+                    $this->database .= "Homologacao";

+        }

 

         if (!isset($this->instance)) {

             $this->instance = Connect::getInstance($this->database);

@@ -340,18 +341,26 @@ 
             $indexed = $params == array_values($params);

             foreach($params as $k=>$v) {

                 if (is_object($v)) {

-                    if ($v instanceof \DateTime) $v = $v->format('Y-m-d H:i:s');

-                    else continue;

+                    if ($v instanceof \DateTime) {

+                        $v = $v->format('Y-m-d H:i:s');

+                    } else {

+                        continue;

+                    }

+                } elseif (is_string($v)) {

+                    $v="'$v'";

+                } elseif ($v === null) {

+                    $v='NULL';

+                } elseif (is_array($v)) {

+                    $v = implode(',', $v);

                 }

-                elseif (is_string($v)) $v="'$v'";

-                elseif ($v === null) $v='NULL';

-                elseif (is_array($v)) $v = implode(',', $v);

 

                 if ($indexed) {

                     $sql_string = preg_replace('/\?/', $v, $sql_string, 1);

-                }

-                else {

-                    if ($k[0] != ':') $k = ':'.$k; //add leading colon if it was left out

+                } else {

+                    if ($k[0] != ':') {

+                        $k = ':'.$k;

+                    }

+                    //add leading colon if it was left out

                     $sql_string = str_replace($k,$v,$sql_string);

                 }

             }

src/Crud.php

Braces +3 added lines, -2 removed lines

@@ -62,8 +62,9 @@
             $query = "INSERT INTO $this->tableName";

             $values = [];

             $dataColumns = array_keys($params);

-            if (isset ($dataColumns[0]))

-                $query .= ' (`' . implode('`, `', $dataColumns) . '`) ';

+            if (isset ($dataColumns[0])) {

+                            $query .= ' (`' . implode('`, `', $dataColumns) . '`) ';

+            }

             $query .= ' VALUES (';

 

             foreach ($dataColumns as $index => $column) {