voku / simple-mysqli

src/voku/db/Prepare.php

Spacing +11 added lines, -11 removed lines

@@ -102,11 +102,11 @@ 
         $value = $this->_db->escape($value);
 
         if ($type === 's') {
-            $valueForSqlWithBoundParameters = "'" . $value . "'";
+            $valueForSqlWithBoundParameters = "'".$value."'";
         } elseif ($type === 'i') {
-            $valueForSqlWithBoundParameters = (int) $value;
+            $valueForSqlWithBoundParameters = (int)$value;
         } elseif ($type === 'd') {
-            $valueForSqlWithBoundParameters = (float) $value;
+            $valueForSqlWithBoundParameters = (float)$value;
         } else {
             $valueForSqlWithBoundParameters = $value;
         }
@@ -205,7 +205,7 @@ 
 
             // "INSERT" || "REPLACE"
             if (\preg_match('/^\s*"?(INSERT|REPLACE)\s+/i', $this->_sql)) {
-                $insert_id = (int) $this->insert_id;
+                $insert_id = (int)$this->insert_id;
                 $this->_debug->logQuery($this->_sql_with_bound_parameters, $query_duration, $insert_id);
 
                 return $insert_id;
@@ -213,7 +213,7 @@ 
 
             // "UPDATE" || "DELETE"
             if (\preg_match('/^\s*"?(UPDATE|DELETE)\s+/i', $this->_sql)) {
-                $affected_rows = (int) $this->affected_rows;
+                $affected_rows = (int)$this->affected_rows;
                 $this->_debug->logQuery($this->_sql_with_bound_parameters, $query_duration, $affected_rows);
 
                 return $affected_rows;
@@ -222,7 +222,7 @@ 
             // "SELECT"
             if (\preg_match('/^\s*"?(SELECT)\s+/i', $this->_sql)) {
                 $result = $this->get_result();
-                $num_rows = (int) $result->num_rows;
+                $num_rows = (int)$result->num_rows;
                 $this->_debug->logQuery($this->_sql_with_bound_parameters, $query_duration, $num_rows);
 
                 return new Result($this->_sql_with_bound_parameters, $result);
@@ -295,7 +295,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;
@@ -383,12 +383,12 @@ 
 
             // 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++;
@@ -398,10 +398,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/Result.php

Spacing +9 added lines, -9 removed lines

@@ -148,7 +148,7 @@ 
             &&
             !$result instanceof \Doctrine\DBAL\Statement
         ) {
-            throw new \InvalidArgumentException('$result must be ' . \mysqli_result::class . ' or ' . \Doctrine\DBAL\Statement::class . ' !');
+            throw new \InvalidArgumentException('$result must be '.\mysqli_result::class.' or '.\Doctrine\DBAL\Statement::class.' !');
         }
 
         $this->_result = $result;
@@ -178,7 +178,7 @@ 
 
             $this->num_rows = $this->_result->rowCount();
         } else {
-            $this->num_rows = (int) $this->_result->num_rows;
+            $this->num_rows = (int)$this->_result->num_rows;
         }
 
         $this->current_row = 0;
@@ -219,7 +219,7 @@ 
      */
     public function __toString()
     {
-        return (string) $this->num_rows;
+        return (string)$this->num_rows;
     }
 
     /**
@@ -832,8 +832,8 @@ 
     {
         if ($as_array) {
             return \array_map(
-                function ($object) {
-                    return (array) $object;
+                function($object) {
+                    return (array)$object;
                 },
                 $this->fetch_fields()
             );
@@ -997,7 +997,7 @@ 
         }
 
         return \array_map(
-            function ($values) use ($keys) {
+            function($values) use ($keys) {
                 return \array_combine($keys, $values);
             },
             $rows
@@ -1133,7 +1133,7 @@ 
                     $fieldTmp->{$metadataTmpKey} = $metadataTmpValue;
                 }
 
-                $typeNativeTmp = 'MYSQL_TYPE_' . $metadataTmp['native_type'];
+                $typeNativeTmp = 'MYSQL_TYPE_'.$metadataTmp['native_type'];
                 $typeTmp = $THIS_CLASS_TMP->getConstant($typeNativeTmp);
                 if ($typeTmp) {
                     $fieldTmp->type = $typeTmp;
@@ -1492,11 +1492,11 @@ 
             if (\abs($offset) > $this->num_rows) {
                 $offset = 0;
             } else {
-                $offset = $this->num_rows - (int) \abs($offset);
+                $offset = $this->num_rows - (int)\abs($offset);
             }
         }
 
-        $length = $length !== null ? (int) $length : $this->num_rows;
+        $length = $length !== null ? (int)$length : $this->num_rows;
         $n = 0;
         for ($i = $offset; $i < $this->num_rows && $n < $length; $i++) {
             if ($preserve_keys) {

src/voku/db/Helper.php

Spacing +22 added lines, -22 removed lines

@@ -29,7 +29,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++;
@@ -57,7 +57,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++;
@@ -177,23 +177,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
@@ -268,7 +268,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());
     }
 
     /**
@@ -296,11 +296,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());
     }
 
     /**
@@ -341,10 +341,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) {
@@ -390,17 +390,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);
 
@@ -419,11 +419,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
                         }
@@ -434,10 +434,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/Debug.php

Spacing +18 added lines, -18 removed lines

@@ -86,7 +86,7 @@ 
         } else {
 
             // for testing with dev-address
-            $noDev = isset($_GET['noDev']) ? (int) $_GET['noDev'] : 0;
+            $noDev = isset($_GET['noDev']) ? (int)$_GET['noDev'] : 0;
             $remoteIpAddress = $_SERVER['REMOTE_ADDR'] ?? false;
 
             if (
@@ -137,9 +137,9 @@ 
         $this->logger(
             [
                 'error',
-                '<strong>' . \date(
+                '<strong>'.\date(
                     'd. m. Y G:i:s'
-                ) . ' (' . $fileInfo['file'] . ' line: ' . $fileInfo['line'] . ') (sql-error):</strong> ' . $error . '<br>',
+                ).' ('.$fileInfo['file'].' line: '.$fileInfo['line'].') (sql-error):</strong> '.$error.'<br>',
             ]
         );
 
@@ -155,16 +155,16 @@ 
 
             if (\PHP_SAPI === 'cli') {
                 echo "\n";
-                echo 'file:line -> ' . $fileInfo['file'] . ':' . $fileInfo['line'] . "\n";
-                echo 'error: ' . \str_replace(["\r\n", "\n", "\r"], '', $error);
+                echo 'file:line -> '.$fileInfo['file'].':'.$fileInfo['line']."\n";
+                echo 'error: '.\str_replace(["\r\n", "\n", "\r"], '', $error);
                 echo "\n";
             } else {
                 echo '
-        <div class="OBJ-mysql-box" style="border: ' . $box_border . '; background: ' . $box_bg . '; padding: 10px; margin: 10px;">
+        <div class="OBJ-mysql-box" style="border: ' . $box_border.'; background: '.$box_bg.'; padding: 10px; margin: 10px;">
           <b style="font-size: 14px;">MYSQL Error:</b>
           <code style="display: block;">
-            file:line -> ' . $fileInfo['file'] . ':' . $fileInfo['line'] . '
-            ' . $error . '
+            file:line -> ' . $fileInfo['file'].':'.$fileInfo['line'].'
+            ' . $error.'
           </code>
         </div>
         ';
@@ -304,7 +304,7 @@ 
             /** @noinspection PhpUsageOfSilenceOperatorInspection */
             $infoExtra = @\mysqli_info($tmpLink);
             if ($infoExtra) {
-                $infoExtra = ' | info => ' . $infoExtra;
+                $infoExtra = ' | info => '.$infoExtra;
             }
         }
 
@@ -312,14 +312,14 @@ 
         // logging
         //
 
-        $info = 'time => ' . \round($duration, 5) . ' | results => ' . (int) $results . $infoExtra . ' | SQL => ' . UTF8::htmlentities($sql);
+        $info = 'time => '.\round($duration, 5).' | results => '.(int)$results.$infoExtra.' | SQL => '.UTF8::htmlentities($sql);
 
         $fileInfo = $this->getFileAndLineFromSql();
 
         return $this->logger(
             [
                 $logLevel,
-                '<strong>' . \date('d. m. Y G:i:s') . ' (' . $fileInfo['file'] . ' line: ' . $fileInfo['line'] . '):</strong> ' . $info . '<br>',
+                '<strong>'.\date('d. m. Y G:i:s').' ('.$fileInfo['file'].' line: '.$fileInfo['line'].'):</strong> '.$info.'<br>',
                 'sql',
             ]
         );
@@ -384,21 +384,21 @@ 
                 $this->logger(
                     [
                         'debug',
-                        $subject . ' | ' . $htmlBody,
+                        $subject.' | '.$htmlBody,
                     ]
                 );
             } elseif ($priority > 3) {
                 $this->logger(
                     [
                         'error',
-                        $subject . ' | ' . $htmlBody,
+                        $subject.' | '.$htmlBody,
                     ]
                 );
             } elseif ($priority < 3) {
                 $this->logger(
                     [
                         'info',
-                        $subject . ' | ' . $htmlBody,
+                        $subject.' | '.$htmlBody,
                     ]
                 );
             }
@@ -410,7 +410,7 @@ 
      */
     public function setEchoOnError($echo_on_error)
     {
-        $this->echo_on_error = (bool) $echo_on_error;
+        $this->echo_on_error = (bool)$echo_on_error;
     }
 
     /**
@@ -418,7 +418,7 @@ 
      */
     public function setExitOnError($exit_on_error)
     {
-        $this->exit_on_error = (bool) $exit_on_error;
+        $this->exit_on_error = (bool)$exit_on_error;
     }
 
     /**
@@ -426,7 +426,7 @@ 
      */
     public function setLoggerClassName($logger_class_name)
     {
-        $this->logger_class_name = (string) $logger_class_name;
+        $this->logger_class_name = (string)$logger_class_name;
     }
 
     /**
@@ -434,6 +434,6 @@ 
      */
     public function setLoggerLevel($logger_level)
     {
-        $this->logger_level = (string) $logger_level;
+        $this->logger_level = (string)$logger_level;
     }
 }

src/voku/db/DB.php

Spacing +50 added lines, -50 removed lines

@@ -297,10 +297,10 @@ 
         }
 
         if ($port) {
-            $this->port = (int) $port;
+            $this->port = (int)$port;
         } else {
             /** @noinspection PhpUsageOfSilenceOperatorInspection */
-            $this->port = (int) @\ini_get('mysqli.default_port');
+            $this->port = (int)@\ini_get('mysqli.default_port');
         }
 
         // fallback
@@ -429,18 +429,18 @@ 
                 }
 
                 if ($_connector === 'NOT IN' || $_connector === 'IN') {
-                    $_value = '(' . \implode(',', $_value) . ')';
+                    $_value = '('.\implode(',', $_value).')';
                 } elseif ($_connector === 'NOT BETWEEN' || $_connector === 'BETWEEN') {
-                    $_value = '(' . \implode(' AND ', $_value) . ')';
+                    $_value = '('.\implode(' AND ', $_value).')';
                 } elseif ($firstKey && $firstValue) {
                     if (\strpos($firstKey, ' +') !== false) {
                         $firstKey = \str_replace(' +', '', $firstKey);
-                        $_value = $firstKey . ' + ' . $firstValue;
+                        $_value = $firstKey.' + '.$firstValue;
                     }
 
                     if (\strpos($firstKey, ' -') !== false) {
                         $firstKey = \str_replace(' -', '', $firstKey);
-                        $_value = $firstKey . ' - ' . $firstValue;
+                        $_value = $firstKey.' - '.$firstValue;
                     }
                 }
             } else {
@@ -460,7 +460,7 @@ 
                 )
             );
 
-            $_value = (array) $_value;
+            $_value = (array)$_value;
 
             if (!$_glueHelper) {
                 $_glueHelper = $glue;
@@ -484,7 +484,7 @@ 
                     $valueInner = "''";
                 }
 
-                $sql .= ' ' . $_glueHelperInner . ' ' . $quoteString . ' ' . $_connector . ' ' . $valueInner . " \n";
+                $sql .= ' '.$_glueHelperInner.' '.$quoteString.' '.$_connector.' '.$valueInner." \n";
                 $tmpCounter++;
             }
 
@@ -535,7 +535,7 @@ 
             unset($params[$key]);
 
             $sql = \substr_replace($sql, $replacement, $offset, 1);
-            $offset = \strpos($sql, '?', $offset + \strlen((string) $replacement));
+            $offset = \strpos($sql, '?', $offset + \strlen((string)$replacement));
         }
 
         return ['sql' => $sql, 'params' => $params];
@@ -571,7 +571,7 @@ 
 
             // add ":" if needed
             if (\strpos($name, ':') !== 0) {
-                $nameTmp = ':' . $name;
+                $nameTmp = ':'.$name;
             } else {
                 $nameTmp = $name;
             }
@@ -579,7 +579,7 @@ 
             if ($offset === null) {
                 $offset = \strpos($sql, $nameTmp);
             } else {
-                $offset = \strpos($sql, $nameTmp, $offset + \strlen((string) $replacement));
+                $offset = \strpos($sql, $nameTmp, $offset + \strlen((string)$replacement));
             }
 
             if ($offset === false) {
@@ -611,7 +611,7 @@ 
             return \mysqli_affected_rows($this->mysqli_link);
         }
 
-        return (int) $this->affected_rows;
+        return (int)$this->affected_rows;
     }
 
     /**
@@ -763,7 +763,7 @@ 
                 $this->connected = $this->doctrine_connection->isConnected();
 
                 if (!$this->connected) {
-                    $error = 'Error connecting to mysql server: ' . $this->doctrine_connection->errorInfo();
+                    $error = 'Error connecting to mysql server: '.$this->doctrine_connection->errorInfo();
                     $this->debug->displayError($error, false);
 
                     throw new DBConnectException($error, 101);
@@ -780,7 +780,7 @@ 
                 $this->connected = $this->doctrine_connection->isConnected();
 
                 if (!$this->connected) {
-                    $error = 'Error connecting to mysql server: ' . $this->doctrine_connection->errorInfo();
+                    $error = 'Error connecting to mysql server: '.$this->doctrine_connection->errorInfo();
                     $this->debug->displayError($error, false);
 
                     throw new DBConnectException($error, 101);
@@ -840,10 +840,10 @@ 
                 $this->database,
                 $this->port,
                 $this->socket,
-                (int) $flags
+                (int)$flags
             );
         } catch (\Exception $e) {
-            $error = 'Error connecting to mysql server: ' . $e->getMessage();
+            $error = 'Error connecting to mysql server: '.$e->getMessage();
             $this->debug->displayError($error, false);
 
             throw new DBConnectException($error, 100, $e);
@@ -852,7 +852,7 @@ 
 
         $errno = \mysqli_connect_errno();
         if (!$this->connected || $errno) {
-            $error = 'Error connecting to mysql server: ' . \mysqli_connect_error() . ' (' . $errno . ')';
+            $error = 'Error connecting to mysql server: '.\mysqli_connect_error().' ('.$errno.')';
             $this->debug->displayError($error, false);
 
             throw new DBConnectException($error, 101);
@@ -894,10 +894,10 @@ 
         }
 
         if ($databaseName) {
-            $databaseName = $this->quote_string(\trim($databaseName)) . '.';
+            $databaseName = $this->quote_string(\trim($databaseName)).'.';
         }
 
-        $sql = 'DELETE FROM ' . $databaseName . $this->quote_string($table) . " WHERE (${WHERE})";
+        $sql = 'DELETE FROM '.$databaseName.$this->quote_string($table)." WHERE (${WHERE})";
 
         return $this->query($sql);
     }
@@ -988,14 +988,14 @@ 
                 $var = $var->format('Y-m-d H:i:s');
                 $type = 'string';
             } elseif (\method_exists($var, '__toString')) {
-                $var = (string) $var;
+                $var = (string)$var;
                 $type = 'string';
             }
         }
 
         switch ($type) {
             case 'boolean':
-                $var = (int) $var;
+                $var = (int)$var;
 
                 break;
 
@@ -1036,7 +1036,7 @@ 
                     }
                 } else {
                     $varCleaned = [];
-                    foreach ((array) $var as $key => $value) {
+                    foreach ((array)$var as $key => $value) {
                         $key = $this->escape($key, $stripe_non_utf8, $html_entity_decode);
                         $value = $this->escape($value, $stripe_non_utf8, $html_entity_decode);
 
@@ -1099,7 +1099,7 @@ 
 
         if ($useCache === true) {
             $cache = new Cache(null, null, false, $useCache);
-            $cacheKey = 'sql-' . \md5($query);
+            $cacheKey = 'sql-'.\md5($query);
 
             if (
                 $cache->getCacheIsReady() === true
@@ -1270,7 +1270,7 @@ 
         }
 
         if (
-            '' . $hostname . $username . $password . $database . $port . $charset === '' . $port . $charset
+            ''.$hostname.$username.$password.$database.$port.$charset === ''.$port.$charset
             &&
             $firstInstance instanceof self
         ) {
@@ -1286,13 +1286,13 @@ 
             if (\is_object($extra_config_value)) {
                 $extra_config_value_tmp = \spl_object_hash($extra_config_value);
             } else {
-                $extra_config_value_tmp = (string) $extra_config_value;
+                $extra_config_value_tmp = (string)$extra_config_value;
             }
-            $extra_config_string .= $extra_config_key . $extra_config_value_tmp;
+            $extra_config_string .= $extra_config_key.$extra_config_value_tmp;
         }
 
         $connection = \md5(
-            $hostname . $username . $password . $database . $port . $charset . (int) $exit_on_error . (int) $echo_on_error . $logger_class_name . $logger_level . $extra_config_string
+            $hostname.$username.$password.$database.$port.$charset.(int)$exit_on_error.(int)$echo_on_error.$logger_class_name.$logger_level.$extra_config_string
         );
 
         if (!isset($instance[$connection])) {
@@ -1431,10 +1431,10 @@ 
         $SET = $this->_parseArrayPair($data);
 
         if ($databaseName) {
-            $databaseName = $this->quote_string(\trim($databaseName)) . '.';
+            $databaseName = $this->quote_string(\trim($databaseName)).'.';
         }
 
-        $sql = 'INSERT INTO ' . $databaseName . $this->quote_string($table) . " SET ${SET}";
+        $sql = 'INSERT INTO '.$databaseName.$this->quote_string($table)." SET ${SET}";
 
         return $this->query($sql);
     }
@@ -1939,12 +1939,12 @@ 
 
             // exit if we have more then 3 "DB server has gone away"-errors
             if ($RECONNECT_COUNTER > 3) {
-                $this->debug->mailToAdmin('DB-Fatal-Error', $errorMessage . '(' . $errorNumber . ') ' . ":\n<br />" . $sql, 5);
+                $this->debug->mailToAdmin('DB-Fatal-Error', $errorMessage.'('.$errorNumber.') '.":\n<br />".$sql, 5);
 
                 throw new DBGoneAwayException($errorMessage);
             }
 
-            $this->debug->mailToAdmin('DB-Error', $errorMessage . '(' . $errorNumber . ') ' . ":\n<br />" . $sql);
+            $this->debug->mailToAdmin('DB-Error', $errorMessage.'('.$errorNumber.') '.":\n<br />".$sql);
 
             // reconnect
             $RECONNECT_COUNTER++;
@@ -1958,7 +1958,7 @@ 
             return false;
         }
 
-        $this->debug->mailToAdmin('SQL-Error', $errorMessage . '(' . $errorNumber . ') ' . ":\n<br />" . $sql);
+        $this->debug->mailToAdmin('SQL-Error', $errorMessage.'('.$errorNumber.') '.":\n<br />".$sql);
 
         $force_exception_after_error = null; // auto
         if ($this->in_transaction === true) {
@@ -1966,7 +1966,7 @@ 
         }
         // this query returned an error, we must display it (only for dev) !!!
 
-        $this->debug->displayError($errorMessage . '(' . $errorNumber . ') ' . ' | ' . $sql, $force_exception_after_error);
+        $this->debug->displayError($errorMessage.'('.$errorNumber.') '.' | '.$sql, $force_exception_after_error);
 
         return false;
     }
@@ -1984,12 +1984,12 @@ 
             '`',
             '``',
             \trim(
-                (string) $this->escape($str, false),
+                (string)$this->escape($str, false),
                 '`'
             )
         );
 
-        return '`' . $str . '`';
+        return '`'.$str.'`';
     }
 
     /**
@@ -2059,10 +2059,10 @@ 
         $values = \implode(',', $data);
 
         if ($databaseName) {
-            $databaseName = $this->quote_string(\trim($databaseName)) . '.';
+            $databaseName = $this->quote_string(\trim($databaseName)).'.';
         }
 
-        $sql = 'REPLACE INTO ' . $databaseName . $this->quote_string($table) . " (${columns}) VALUES (${values})";
+        $sql = 'REPLACE INTO '.$databaseName.$this->quote_string($table)." (${columns}) VALUES (${values})";
 
         return $this->query($sql);
     }
@@ -2154,7 +2154,7 @@ 
                 }
             } else {
                 $varCleaned = [];
-                foreach ((array) $var as $key => $value) {
+                foreach ((array)$var as $key => $value) {
                     $key = $this->escape($key, false, false, $convert_array);
                     $value = $this->secure($value);
 
@@ -2201,7 +2201,7 @@ 
         $var = $this->escape($var, false, false, null);
 
         if (\is_string($var)) {
-            $var = "'" . \trim($var, "'") . "'";
+            $var = "'".\trim($var, "'")."'";
         }
 
         return $var;
@@ -2238,10 +2238,10 @@ 
         }
 
         if ($databaseName) {
-            $databaseName = $this->quote_string(\trim($databaseName)) . '.';
+            $databaseName = $this->quote_string(\trim($databaseName)).'.';
         }
 
-        $sql = 'SELECT * FROM ' . $databaseName . $this->quote_string($table) . " WHERE (${WHERE})";
+        $sql = 'SELECT * FROM '.$databaseName.$this->quote_string($table)." WHERE (${WHERE})";
 
         return $this->query($sql);
     }
@@ -2283,7 +2283,7 @@ 
     public function setConfigExtra(array $extra_config)
     {
         if (isset($extra_config['session_to_db'])) {
-            $this->session_to_db = (bool) $extra_config['session_to_db'];
+            $this->session_to_db = (bool)$extra_config['session_to_db'];
         }
 
         if (isset($extra_config['doctrine'])) {
@@ -2342,14 +2342,14 @@ 
             $return = \mysqli_set_charset($this->mysqli_link, $charset);
 
             /** @noinspection PhpUsageOfSilenceOperatorInspection */
-            @\mysqli_query($this->mysqli_link, 'SET CHARACTER SET ' . $charset);
+            @\mysqli_query($this->mysqli_link, 'SET CHARACTER SET '.$charset);
             /** @noinspection PhpUsageOfSilenceOperatorInspection */
-            @\mysqli_query($this->mysqli_link, "SET NAMES '" . $charset . "'");
+            @\mysqli_query($this->mysqli_link, "SET NAMES '".$charset."'");
         } elseif ($this->isDoctrinePDOConnection() === true) {
             $doctrineWrappedConnection = $this->getDoctrinePDOConnection();
 
-            $doctrineWrappedConnection->exec('SET CHARACTER SET ' . $charset);
-            $doctrineWrappedConnection->exec("SET NAMES '" . $charset . "'");
+            $doctrineWrappedConnection->exec('SET CHARACTER SET '.$charset);
+            $doctrineWrappedConnection->exec("SET NAMES '".$charset."'");
 
             $return = true;
         } else {
@@ -2490,7 +2490,7 @@ 
      */
     public function table_exists(string $table): bool
     {
-        $check = $this->query('SELECT 1 FROM ' . $this->quote_string($table));
+        $check = $this->query('SELECT 1 FROM '.$this->quote_string($table));
 
         return $check !== false
                &&
@@ -2520,7 +2520,7 @@ 
             $result = $callback($this);
             if ($result === false) {
                 /** @noinspection ThrowRawExceptionInspection */
-                throw new \Exception('call_user_func [' . $callback . '] === false');
+                throw new \Exception('call_user_func ['.$callback.'] === false');
             }
 
             return $this->commit();
@@ -2577,10 +2577,10 @@ 
         }
 
         if ($databaseName) {
-            $databaseName = $this->quote_string(\trim($databaseName)) . '.';
+            $databaseName = $this->quote_string(\trim($databaseName)).'.';
         }
 
-        $sql = 'UPDATE ' . $databaseName . $this->quote_string($table) . " SET ${SET} WHERE (${WHERE})";
+        $sql = 'UPDATE '.$databaseName.$this->quote_string($table)." SET ${SET} WHERE (${WHERE})";
 
         return $this->query($sql);
     }