voku / simple-mysqli

src/voku/db/Result.php

Doc Comments +1 added lines, -1 removed lines

@@ -229,7 +229,7 @@
    * fetchObject
    *
    * @param string     $class
-   * @param null|array $params
+   * @param string $params
    * @param bool       $reset
    *
    * @return object|false false on error

src/voku/db/DB.php

Doc Comments +3 added lines, -3 removed lines

@@ -795,7 +795,7 @@ 
   /**
    * Escape
    *
-   * @param mixed $var boolean: convert into "integer"<br />
+   * @param string $var boolean: convert into "integer"<br />
    *                   int: convert into "integer"<br />
    *                   float: convert into "float" and replace "," with "."<br />
    *                   array: run escape() for every key => value<br />
@@ -804,7 +804,7 @@ 
    * @param bool  $html_entity_decode
    * @param bool  $array_to_string
    *
-   * @return array|bool|float|int|string
+   * @return string
    */
   public function escape($var = '', $stripe_non_utf8 = true, $html_entity_decode = true, $array_to_string = false)
   {
@@ -923,7 +923,7 @@ 
   /**
    * Returns the auto generated id used in the last query.
    *
-   * @return int|string
+   * @return integer
    */
   public function insert_id()
   {

Spacing +36 added lines, -36 removed lines

@@ -295,12 +295,12 @@ 
           $this->socket
       );
     } catch (\Exception $e) {
-      $this->_displayError('Error connecting to mysql server: ' . $e->getMessage(), true);
+      $this->_displayError('Error connecting to mysql server: '.$e->getMessage(), true);
     }
     mysqli_report(MYSQLI_REPORT_OFF);
 
     if (!$this->link) {
-      $this->_displayError('Error connecting to mysql server: ' . mysqli_connect_error(), true);
+      $this->_displayError('Error connecting to mysql server: '.mysqli_connect_error(), true);
     } else {
       $this->set_charset($this->charset);
       $this->connected = true;
@@ -334,9 +334,9 @@ 
     $this->logger(
         array(
             '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>',
         )
     );
 
@@ -349,11 +349,11 @@ 
         $box_bg = $this->css_mysql_box_bg;
 
         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>
         ';
@@ -566,7 +566,7 @@ 
     static $firstInstance = null;
 
     if (
-        $hostname . $username . $password . $database . $port . $charset == ''
+        $hostname.$username.$password.$database.$port.$charset == ''
         &&
         null !== $firstInstance
     ) {
@@ -574,7 +574,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])) {
@@ -751,7 +751,7 @@ 
       // "string"
 
       if (!in_array($var, $this->mysqlDefaultTimeFunctions, true)) {
-        $var = "'" . trim($this->escape(trim(trim((string)$var), "'")), "'") . "'";
+        $var = "'".trim($this->escape(trim(trim((string)$var), "'")), "'")."'";
       }
 
     } elseif (is_float($var)) {
@@ -771,7 +771,7 @@ 
       // "DateTime"-object
 
       try {
-        $var = "'" . $this->escape($var->format('Y-m-d H:i:s'), false, false) . "'";
+        $var = "'".$this->escape($var->format('Y-m-d H:i:s'), false, false)."'";
       } catch (\Exception $e) {
         $var = null;
       }
@@ -780,7 +780,7 @@ 
 
       // fallback ...
 
-      $var = "'" . trim($this->escape(trim(trim((string)$var), "'")), "'") . "'";
+      $var = "'".trim($this->escape(trim(trim((string)$var), "'")), "'")."'";
 
     }
 
@@ -896,13 +896,13 @@ 
       return false;
     }
 
-    $info = 'time => ' . round($duration, 5) . ' - ' . 'results => ' . $results . ' - ' . 'SQL => ' . UTF8::htmlentities($sql);
+    $info = 'time => '.round($duration, 5).' - '.'results => '.$results.' - '.'SQL => '.UTF8::htmlentities($sql);
     $fileInfo = $this->getFileAndLineFromSql();
 
     $this->logger(
         array(
             'debug',
-            '<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',
         )
     );
@@ -946,10 +946,10 @@ 
 
       // exit if we have more then 3 "DB server has gone away"-errors
       if ($reconnectCounter > 3) {
-        $this->mailToAdmin('SQL-Fatal-Error', $errorMsg . ":\n<br />" . $sql, 5);
+        $this->mailToAdmin('SQL-Fatal-Error', $errorMsg.":\n<br />".$sql, 5);
         throw new \Exception($errorMsg);
       } else {
-        $this->mailToAdmin('SQL-Error', $errorMsg . ":\n<br />" . $sql);
+        $this->mailToAdmin('SQL-Error', $errorMsg.":\n<br />".$sql);
 
         // reconnect
         $reconnectCounter++;
@@ -959,10 +959,10 @@ 
         $this->query($sql, $sqlParams);
       }
     } else {
-      $this->mailToAdmin('SQL-Warning', $errorMsg . ":\n<br />" . $sql);
+      $this->mailToAdmin('SQL-Warning', $errorMsg.":\n<br />".$sql);
 
       // this query returned an error, we must display it (only for dev) !!!
-      $this->_displayError($errorMsg . ' | ' . $sql);
+      $this->_displayError($errorMsg.' | '.$sql);
     }
   }
 
@@ -983,21 +983,21 @@ 
         $this->logger(
             array(
                 'debug',
-                $subject . ' | ' . $htmlBody,
+                $subject.' | '.$htmlBody,
             )
         );
       } elseif ($priority > 3) {
         $this->logger(
             array(
                 'error',
-                $subject . ' | ' . $htmlBody,
+                $subject.' | '.$htmlBody,
             )
         );
       } elseif ($priority < 3) {
         $this->logger(
             array(
                 'info',
-                $subject . ' | ' . $htmlBody,
+                $subject.' | '.$htmlBody,
             )
         );
       }
@@ -1068,7 +1068,7 @@ 
 
     if ($useCache === true) {
       $cache = new Cache(null, null, false, $useCache);
-      $cacheKey = 'sql-' . md5($query);
+      $cacheKey = 'sql-'.md5($query);
 
       if (
           $cache->getCacheIsReady() === true
@@ -1130,9 +1130,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 == 'utf8' ? 'utf8mb4' : $charset) . "'");
+    @mysqli_query($this->link, "SET NAMES '".($charset == 'utf8' ? 'utf8mb4' : $charset)."'");
 
     return $return;
   }
@@ -1223,10 +1223,10 @@ 
 
       if ($this->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->mailToAdmin('SQL-Error in mysqli_multi_query', $errorMsg . ":\n<br />" . $sql);
+      $this->mailToAdmin('SQL-Error in mysqli_multi_query', $errorMsg.":\n<br />".$sql);
     }
 
     // return the result only if there was a "SELECT"-query
@@ -1263,7 +1263,7 @@ 
 
       return false;
     } elseif (mysqli_connect_errno()) {
-      $this->_displayError('Error connecting to mysql server: ' . mysqli_connect_error(), true);
+      $this->_displayError('Error connecting to mysql server: '.mysqli_connect_error(), true);
 
       return false;
     } else {
@@ -1372,7 +1372,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);
   }
@@ -1466,7 +1466,7 @@ 
             /** @noinspection AlterInForeachInspection */
             $_value[$oldKey] = $this->secure($oldValue);
           }
-          $_value = '(' . implode(',', $_value) . ')';
+          $_value = '('.implode(',', $_value).')';
         } elseif (
             is_array($_value)
             &&
@@ -1480,13 +1480,13 @@ 
             /** @noinspection AlterInForeachInspection */
             $_value[$oldKey] = $this->secure($oldValue);
           }
-          $_value = '(' . implode(' AND ', $_value) . ')';
+          $_value = '('.implode(' AND ', $_value).')';
         } else {
           $_value = $this->secure($_value);
         }
 
         $quoteString = $this->quote_string(trim(str_ireplace($_connector, '', $_key)));
-        $pairs[] = ' ' . $quoteString . ' ' . $_connector . ' ' . $_value . " \n";
+        $pairs[] = ' '.$quoteString.' '.$_connector.' '.$_value." \n";
       }
 
       $sql = implode($glue, $pairs);
@@ -1504,7 +1504,7 @@ 
    */
   public function quote_string($str)
   {
-    return '`' . $this->escape($str, false, false) . '`';
+    return '`'.$this->escape($str, false, false).'`';
   }
 
   /**
@@ -1558,7 +1558,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);
   }
@@ -1598,7 +1598,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);
   }
@@ -1630,7 +1630,7 @@ 
       $WHERE = '';
     }
 
-    $sql = 'DELETE FROM ' . $this->quote_string($table) . " WHERE ($WHERE);";
+    $sql = 'DELETE FROM '.$this->quote_string($table)." WHERE ($WHERE);";
 
     return $this->query($sql);
   }
@@ -1660,7 +1660,7 @@ 
       $WHERE = '';
     }
 
-    $sql = 'SELECT * FROM ' . $this->quote_string($table) . " WHERE ($WHERE);";
+    $sql = 'SELECT * FROM '.$this->quote_string($table)." WHERE ($WHERE);";
 
     return $this->query($sql);
   }