voku / simple-mysqli

src/voku/db/DB.php

Spacing +25 added lines, -25 removed lines

@@ -282,12 +282,12 @@ 
           $this->socket
       );
     } catch (\Exception $e) {
-      $this->_debug->displayError('Error connecting to mysql server: ' . $e->getMessage(), true);
+      $this->_debug->displayError('Error connecting to mysql server: '.$e->getMessage(), true);
     }
     \mysqli_report(MYSQLI_REPORT_OFF);
 
     if (!$this->connected) {
-      $this->_debug->displayError('Error connecting to mysql server: ' . \mysqli_connect_error(), true);
+      $this->_debug->displayError('Error connecting to mysql server: '.\mysqli_connect_error(), true);
     } else {
       $this->set_charset($this->charset);
     }
@@ -382,7 +382,7 @@ 
     static $firstInstance = null;
 
     if (
-        $hostname . $username . $password . $database . $port . $charset == ''
+        $hostname.$username.$password.$database.$port.$charset == ''
         &&
         null !== $firstInstance
     ) {
@@ -390,7 +390,7 @@ 
     }
 
     $connection = md5(
-        $hostname . $username . $password . $database . $port . $charset . (int)$exit_on_error . (int)$echo_on_error . $logger_class_name . $logger_level . (int)$session_to_db
+        $hostname.$username.$password.$database.$port.$charset.(int)$exit_on_error.(int)$echo_on_error.$logger_class_name.$logger_level.(int)$session_to_db
     );
 
     if (!isset($instance[$connection])) {
@@ -598,7 +598,7 @@ 
     $var = $this->escape($var, false, false, null);
 
     if (is_string($var)) {
-      $var = "'" . trim($var, "'") . "'";
+      $var = "'".trim($var, "'")."'";
     }
 
     return $var;
@@ -770,10 +770,10 @@ 
 
       // exit if we have more then 3 "DB server has gone away"-errors
       if ($reconnectCounter > 3) {
-        $this->_debug->mailToAdmin('SQL-Fatal-Error', $errorMsg . ":\n<br />" . $sql, 5);
+        $this->_debug->mailToAdmin('SQL-Fatal-Error', $errorMsg.":\n<br />".$sql, 5);
         throw new \Exception($errorMsg);
       } else {
-        $this->_debug->mailToAdmin('SQL-Error', $errorMsg . ":\n<br />" . $sql);
+        $this->_debug->mailToAdmin('SQL-Error', $errorMsg.":\n<br />".$sql);
 
         // reconnect
         $reconnectCounter++;
@@ -783,10 +783,10 @@ 
         return $this->query($sql, $sqlParams);
       }
     } else {
-      $this->_debug->mailToAdmin('SQL-Warning', $errorMsg . ":\n<br />" . $sql);
+      $this->_debug->mailToAdmin('SQL-Warning', $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;
@@ -854,7 +854,7 @@ 
 
     if ($useCache === true) {
       $cache = new Cache(null, null, false, $useCache);
-      $cacheKey = 'sql-' . md5($query);
+      $cacheKey = 'sql-'.md5($query);
 
       if (
           $cache->getCacheIsReady() === true
@@ -969,9 +969,9 @@ 
 
     $return = mysqli_set_charset($this->link, $charset);
     /** @noinspection PhpUsageOfSilenceOperatorInspection */
-    @\mysqli_query($this->link, 'SET CHARACTER SET ' . $charset);
+    @\mysqli_query($this->link, 'SET CHARACTER SET '.$charset);
     /** @noinspection PhpUsageOfSilenceOperatorInspection */
-    @\mysqli_query($this->link, "SET NAMES '" . $charset . "'");
+    @\mysqli_query($this->link, "SET NAMES '".$charset."'");
 
     return $return;
   }
@@ -1058,10 +1058,10 @@ 
 
       if ($this->_debug->checkForDev() === true) {
         echo "Info: maybe you have to increase your 'max_allowed_packet = 30M' in the config: 'my.conf' \n<br />";
-        echo 'Error:' . $errorMsg;
+        echo 'Error:'.$errorMsg;
       }
 
-      $this->_debug->mailToAdmin('SQL-Error in mysqli_multi_query', $errorMsg . ":\n<br />" . $sql);
+      $this->_debug->mailToAdmin('SQL-Error in mysqli_multi_query', $errorMsg.":\n<br />".$sql);
     }
 
     // return the result only if there was a "SELECT"-query
@@ -1098,7 +1098,7 @@ 
 
       return false;
     } elseif (\mysqli_connect_errno()) {
-      $this->_debug->displayError('Error connecting to mysql server: ' . \mysqli_connect_error(), true);
+      $this->_debug->displayError('Error connecting to mysql server: '.\mysqli_connect_error(), true);
 
       return false;
     } else {
@@ -1207,7 +1207,7 @@ 
 
     $SET = $this->_parseArrayPair($data);
 
-    $sql = 'INSERT INTO ' . $this->quote_string($table) . " SET $SET;";
+    $sql = 'INSERT INTO '.$this->quote_string($table)." SET $SET;";
 
     return $this->query($sql);
   }
@@ -1295,9 +1295,9 @@ 
           }
 
           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).')';
           }
 
         } else {
@@ -1305,7 +1305,7 @@ 
         }
 
         $quoteString = $this->quote_string(trim(str_ireplace($_connector, '', $_key)));
-        $pairs[] = ' ' . $quoteString . ' ' . $_connector . ' ' . $_value . " \n";
+        $pairs[] = ' '.$quoteString.' '.$_connector.' '.$_value." \n";
       }
 
       $sql = implode($glue, $pairs);
@@ -1323,7 +1323,7 @@ 
    */
   public function quote_string($str)
   {
-    $str= str_replace(
+    $str = str_replace(
         '`',
         '``',
         trim(
@@ -1332,7 +1332,7 @@ 
         )
     );
 
-    return '`' . $str . '`';
+    return '`'.$str.'`';
   }
 
   /**
@@ -1386,7 +1386,7 @@ 
     }
     $values = implode(',', $data);
 
-    $sql = 'REPLACE INTO ' . $this->quote_string($table) . " ($columns) VALUES ($values);";
+    $sql = 'REPLACE INTO '.$this->quote_string($table)." ($columns) VALUES ($values);";
 
     return $this->query($sql);
   }
@@ -1426,7 +1426,7 @@ 
       $WHERE = '';
     }
 
-    $sql = 'UPDATE ' . $this->quote_string($table) . " SET $SET WHERE ($WHERE);";
+    $sql = 'UPDATE '.$this->quote_string($table)." SET $SET WHERE ($WHERE);";
 
     return $this->query($sql);
   }
@@ -1458,7 +1458,7 @@ 
       $WHERE = '';
     }
 
-    $sql = 'DELETE FROM ' . $this->quote_string($table) . " WHERE ($WHERE);";
+    $sql = 'DELETE FROM '.$this->quote_string($table)." WHERE ($WHERE);";
 
     return $this->query($sql);
   }
@@ -1488,7 +1488,7 @@ 
       $WHERE = '';
     }
 
-    $sql = 'SELECT * FROM ' . $this->quote_string($table) . " WHERE ($WHERE);";
+    $sql = 'SELECT * FROM '.$this->quote_string($table)." WHERE ($WHERE);";
 
     return $this->query($sql);
   }