voku / simple-mysqli

src/voku/db/Helper.php

Spacing +23 added lines, -23 removed lines

@@ -25,7 +25,7 @@ 
         $configOrig = $dbConnection->getConfig();
         array_walk_recursive(
             $configOrig,
-            function ($k, $v) use (&$configTmp) {
+            function($k, $v) use (&$configTmp) {
                 $configTmp[] = $v;
                 $configTmp[] = $k;
             }
@@ -51,7 +51,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++;
@@ -79,7 +79,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++;
@@ -199,23 +199,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) {
             $cache = new Cache(null, null, false, $useCache);
-            $cacheKey = 'sql-phonetic-search-' . \md5($query);
+            $cacheKey = 'sql-phonetic-search-'.\md5($query);
 
             if (
                 $cache->getCacheIsReady()
@@ -290,7 +290,7 @@ 
             }
         }
 
-        return $MYSQL_CLIENT_VERSION_CACHE[$cacheKey] = (string) \mysqli_get_client_version($dbConnection->getLink());
+        return $MYSQL_CLIENT_VERSION_CACHE[$cacheKey] = (string)\mysqli_get_client_version($dbConnection->getLink());
     }
 
     /**
@@ -318,11 +318,11 @@ 
         if ($doctrineConnection) {
             $doctrineWrappedConnection = $doctrineConnection->getWrappedConnection();
             if ($doctrineWrappedConnection instanceof \Doctrine\DBAL\Driver\PDOConnection) {
-                return $MYSQL_SERVER_VERSION_CACHE[$cacheKey] = (string) $doctrineWrappedConnection->getServerVersion();
+                return $MYSQL_SERVER_VERSION_CACHE[$cacheKey] = (string)$doctrineWrappedConnection->getServerVersion();
             }
         }
 
-        return $MYSQL_SERVER_VERSION_CACHE[$cacheKey] = (string) \mysqli_get_server_version($dbConnection->getLink());
+        return $MYSQL_SERVER_VERSION_CACHE[$cacheKey] = (string)\mysqli_get_server_version($dbConnection->getLink());
     }
 
     /**
@@ -363,10 +363,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) {
@@ -412,17 +412,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);
 
@@ -441,11 +441,11 @@ 
                 foreach ($tmpArray as $fieldName => $value) {
                     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
                         }
@@ -456,10 +456,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);