voku / simple-mysqli

src/voku/db/Prepare.php

Spacing +10 added lines, -10 removed lines

@@ -1,6 +1,6 @@ 
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db;
 
@@ -82,7 +82,7 @@ 
 
     foreach ($this->_boundParams as $param) {
       $arguments[0] .= $param['type'];
-      $arguments[] =& $param['value'];
+      $arguments[] = & $param['value'];
     }
 
     return $arguments;
@@ -105,7 +105,7 @@ 
     $value = $this->_db->escape($value);
 
     if ($type === 's') {
-      $valueForSqlWithBoundParameters = "'" . $value . "'";
+      $valueForSqlWithBoundParameters = "'".$value."'";
     } elseif ($type === 'i') {
       $valueForSqlWithBoundParameters = (int)$value;
     } elseif ($type === 'd') {
@@ -182,7 +182,7 @@ 
     // debug_backtrace returns arguments by reference, see comments at http://php.net/manual/de/function.func-get-args.php
     $trace = \debug_backtrace(DEBUG_BACKTRACE_PROVIDE_OBJECT, 1);
 
-    $args =& $trace[0]['args'];
+    $args = & $trace[0]['args'];
     $types = \str_split($types);
 
     $args_count = \count($args) - 1;
@@ -196,7 +196,7 @@ 
 
     $arg = 1;
     foreach ($types as $typeInner) {
-      $val =& $args[$arg];
+      $val = & $args[$arg];
       $this->_boundParams[] = [
           'type'  => $typeInner,
           'value' => &$val,
@@ -332,7 +332,7 @@ 
     $bool = parent::prepare($query);
 
     if ($bool === false) {
-      $this->_debug->displayError('Can not prepare query: ' . $query . ' | ' . $this->error, false);
+      $this->_debug->displayError('Can not prepare query: '.$query.' | '.$this->error, false);
     }
 
     return $bool;
@@ -420,11 +420,11 @@ 
 
       // exit if we have more then 3 "DB server has gone away"-errors
       if ($RECONNECT_COUNTER > 3) {
-        $this->_debug->mailToAdmin('DB-Fatal-Error', $errorMsg . ":\n<br />" . $sql, 5);
+        $this->_debug->mailToAdmin('DB-Fatal-Error', $errorMsg.":\n<br />".$sql, 5);
         throw new DBGoneAwayException($errorMsg);
       }
 
-      $this->_debug->mailToAdmin('DB-Error', $errorMsg . ":\n<br />" . $sql);
+      $this->_debug->mailToAdmin('DB-Error', $errorMsg.":\n<br />".$sql);
 
       // reconnect
       $RECONNECT_COUNTER++;
@@ -434,10 +434,10 @@ 
       return $this->execute();
     }
 
-    $this->_debug->mailToAdmin('SQL-Error', $errorMsg . ":\n<br />" . $sql);
+    $this->_debug->mailToAdmin('SQL-Error', $errorMsg.":\n<br />".$sql);
 
     // this query returned an error, we must display it (only for dev) !!!
-    $this->_debug->displayError($errorMsg . ' | ' . $sql);
+    $this->_debug->displayError($errorMsg.' | '.$sql);
 
     return false;
   }

src/voku/db/Helper.php

Spacing +20 added lines, -20 removed lines

@@ -1,6 +1,6 @@ 
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db;
 
@@ -31,7 +31,7 @@ 
     $optimized = 0;
     if (!empty($tables)) {
       foreach ($tables as $table) {
-        $optimize = 'OPTIMIZE TABLE ' . $dbConnection->quote_string($table);
+        $optimize = 'OPTIMIZE TABLE '.$dbConnection->quote_string($table);
         $result = $dbConnection->query($optimize);
         if ($result) {
           $optimized++;
@@ -59,7 +59,7 @@ 
     $optimized = 0;
     if (!empty($tables)) {
       foreach ($tables as $table) {
-        $optimize = 'REPAIR TABLE ' . $dbConnection->quote_string($table);
+        $optimize = 'REPAIR TABLE '.$dbConnection->quote_string($table);
         $result = $dbConnection->query($optimize);
         if ($result) {
           $optimized++;
@@ -176,23 +176,23 @@ 
 
     $whereSQL = $dbConnection->_parseArrayPair($whereArray, 'AND');
     if ($whereSQL) {
-      $whereSQL = 'AND ' . $whereSQL;
+      $whereSQL = 'AND '.$whereSQL;
     }
 
     if ($databaseName) {
-      $databaseName = $dbConnection->quote_string(trim($databaseName)) . '.';
+      $databaseName = $dbConnection->quote_string(trim($databaseName)).'.';
     }
 
     // get the row
-    $query = 'SELECT ' . $dbConnection->quote_string($searchFieldName) . ', ' . $dbConnection->quote_string($idFieldName) . ' 
-      FROM ' . $databaseName . $dbConnection->quote_string($table) . '
+    $query = 'SELECT '.$dbConnection->quote_string($searchFieldName).', '.$dbConnection->quote_string($idFieldName).' 
+      FROM ' . $databaseName.$dbConnection->quote_string($table).'
       WHERE 1 = 1
-      ' . $whereSQL . '
+      ' . $whereSQL.'
     ';
 
     if ($useCache === true) {
       $cache = new Cache(null, null, false, $useCache);
-      $cacheKey = 'sql-phonetic-search-' . \md5($query);
+      $cacheKey = 'sql-phonetic-search-'.\md5($query);
 
       if (
           $cache->getCacheIsReady() === true
@@ -322,10 +322,10 @@ 
     }
 
     if ($databaseName) {
-      $databaseName = $dbConnection->quote_string(trim($databaseName)) . '.';
+      $databaseName = $dbConnection->quote_string(trim($databaseName)).'.';
     }
 
-    $sql = 'SHOW COLUMNS FROM ' . $databaseName . $dbConnection->escape($table);
+    $sql = 'SHOW COLUMNS FROM '.$databaseName.$dbConnection->escape($table);
     $result = $dbConnection->query($sql);
 
     if ($result && $result->num_rows > 0) {
@@ -371,17 +371,17 @@ 
 
     $whereSQL = $dbConnection->_parseArrayPair($whereArray, 'AND');
     if ($whereSQL) {
-      $whereSQL = 'AND ' . $whereSQL;
+      $whereSQL = 'AND '.$whereSQL;
     }
 
     if ($databaseName) {
-      $databaseName = $dbConnection->quote_string(trim($databaseName)) . '.';
+      $databaseName = $dbConnection->quote_string(trim($databaseName)).'.';
     }
 
     // get the row
-    $query = 'SELECT * FROM ' . $databaseName . $dbConnection->quote_string($table) . '
+    $query = 'SELECT * FROM '.$databaseName.$dbConnection->quote_string($table).'
       WHERE 1 = 1
-      ' . $whereSQL . '
+      ' . $whereSQL.'
     ';
     $result = $dbConnection->query($query);
 
@@ -401,11 +401,11 @@ 
 
           if (!\in_array($fieldName, $ignoreArray, true)) {
             if (\array_key_exists($fieldName, $updateArray)) {
-              $insert_keys .= ',' . $fieldName;
+              $insert_keys .= ','.$fieldName;
               $insert_values .= ',?';
               $bindings[] = $updateArray[$fieldName]; // INFO: do not escape non selected data
             } else {
-              $insert_keys .= ',' . $fieldName;
+              $insert_keys .= ','.$fieldName;
               $insert_values .= ',?';
               $bindings[] = $value; // INFO: do not escape non selected data
             }
@@ -416,10 +416,10 @@ 
         $insert_values = ltrim($insert_values, ',');
 
         // insert the "copied" row
-        $new_query = 'INSERT INTO ' . $databaseName . $dbConnection->quote_string($table) . ' 
-          (' . $insert_keys . ')
+        $new_query = 'INSERT INTO '.$databaseName.$dbConnection->quote_string($table).' 
+          (' . $insert_keys.')
           VALUES 
-          (' . $insert_values . ')
+          (' . $insert_values.')
         ';
 
         return $dbConnection->query($new_query, $bindings);

src/voku/db/ActiveRecord.php

Spacing +10 added lines, -10 removed lines

@@ -1,6 +1,6 @@ 
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db;
 
@@ -583,7 +583,7 @@ 
     $value = $this->_filterParam($this->dirty);
     $this->insert = new ActiveRecordExpressions(
         [
-            'operator' => 'INSERT INTO ' . $this->table,
+            'operator' => 'INSERT INTO '.$this->table,
             'target'   => new ActiveRecordExpressionsWrap(['target' => \array_keys($this->dirty)]),
         ]
     );
@@ -794,7 +794,7 @@ 
         null === $o->{$n}
     ) {
 
-      $n = \strtoupper($n) . ' ' . $o->table . '.*';
+      $n = \strtoupper($n).' '.$o->table.'.*';
 
     } elseif (
         (
@@ -806,15 +806,15 @@ 
         null === $o->{$n}
     ) {
 
-      $n = \strtoupper($n) . ' ' . $o->table;
+      $n = \strtoupper($n).' '.$o->table;
 
     } elseif ('delete' === $n) {
 
-      $n = \strtoupper($n) . ' ';
+      $n = \strtoupper($n).' ';
 
     } else {
 
-      $n = (null !== $o->{$n}) ? $o->{$n} . ' ' : '';
+      $n = (null !== $o->{$n}) ? $o->{$n}.' ' : '';
 
     }
   }
@@ -927,10 +927,10 @@ 
   {
     if (\is_array($value)) {
       foreach ($value as $key => $val) {
-        $this->params[$value[$key] = self::PREFIX . ++self::$count] = $val;
+        $this->params[$value[$key] = self::PREFIX.++self::$count] = $val;
       }
     } elseif (\is_string($value)) {
-      $this->params[$ph = self::PREFIX . ++self::$count] = $value;
+      $this->params[$ph = self::PREFIX.++self::$count] = $value;
       $value = $ph;
     }
 
@@ -951,7 +951,7 @@ 
     $value = $this->_filterParam($value);
     $exp = new ActiveRecordExpressions(
         [
-            'source'   => ('where' == $name ? $this->table . '.' : '') . $field,
+            'source'   => ('where' == $name ? $this->table.'.' : '').$field,
             'operator' => $operator,
             'target'   => \is_array($value)
                 ? new ActiveRecordExpressionsWrap(
@@ -984,7 +984,7 @@ 
     $this->join = new ActiveRecordExpressions(
         [
             'source'   => $this->join ?: '',
-            'operator' => $type . ' JOIN',
+            'operator' => $type.' JOIN',
             'target'   => new ActiveRecordExpressions(
                 ['source' => $table, 'operator' => 'ON', 'target' => $on]
             ),