voku / simple-mysqli

src/voku/db/DB.php

Doc Comments +1 added lines, -1 removed lines

@@ -249,7 +249,7 @@
    * @param string      $username
    * @param string      $password
    * @param string      $database
-   * @param int|string  $port             <p>default is (int)3306</p>
+   * @param integer  $port             <p>default is (int)3306</p>
    * @param string      $charset          <p>default is 'utf8' or 'utf8mb4' (if supported)</p>
    * @param bool|string $exit_on_error    <p>Throw a 'Exception' when a query failed, otherwise it will return 'false'.
    *                                      Use a empty string "" or false to disable it.</p>

Spacing +33 added lines, -33 removed lines

@@ -1,6 +1,6 @@ 
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db;
 
@@ -436,9 +436,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 {
@@ -487,7 +487,7 @@ 
           $valueInner = "''";
         }
 
-        $sql .= ' ' . $_glueHelperInner . ' ' . $quoteString . ' ' . $_connector . ' ' . $valueInner . " \n";
+        $sql .= ' '.$_glueHelperInner.' '.$quoteString.' '.$_connector.' '.$valueInner." \n";
         $tmpCounter++;
       }
 
@@ -690,7 +690,7 @@ 
       );
 
     } catch (\Exception $e) {
-      $error = 'Error connecting to mysql server: ' . $e->getMessage();
+      $error = 'Error connecting to mysql server: '.$e->getMessage();
       $this->_debug->displayError($error, true);
       throw new DBConnectException($error, 100, $e);
     }
@@ -698,7 +698,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, true);
       throw new DBConnectException($error, 101);
     }
@@ -739,10 +739,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);
   }
@@ -812,8 +812,8 @@ 
         $nameTmp = substr($name, 1);
       }
 
-      $parseKeyInner = $nameTmp . '-' . $parseKey;
-      $sql = str_replace(':' . $nameTmp, $parseKeyInner, $sql);
+      $parseKeyInner = $nameTmp.'-'.$parseKey;
+      $sql = str_replace(':'.$nameTmp, $parseKeyInner, $sql);
     }
 
     foreach ($params as $name => $value) {
@@ -822,7 +822,7 @@ 
         $nameTmp = substr($name, 1);
       }
 
-      $parseKeyInner = $nameTmp . '-' . $parseKey;
+      $parseKeyInner = $nameTmp.'-'.$parseKey;
       $sqlBefore = $sql;
       $secureParamValue = $this->secure($params[$name]);
 
@@ -1010,7 +1010,7 @@ 
 
     if ($useCache === true) {
       $cache = new Cache(null, null, false, $useCache);
-      $cacheKey = 'sql-' . md5($query);
+      $cacheKey = 'sql-'.md5($query);
 
       if (
           $cache->getCacheIsReady() === true
@@ -1120,7 +1120,7 @@ 
     static $firstInstance = null;
 
     if (
-        $hostname . $username . $password . $database . $port . $charset == ''
+        $hostname.$username.$password.$database.$port.$charset == ''
         &&
         null !== $firstInstance
     ) {
@@ -1130,7 +1130,7 @@ 
     $extra_config_string = '';
     if (\is_array($extra_config) === true) {
       foreach ($extra_config as $extra_config_key => $extra_config_value) {
-        $extra_config_string .= $extra_config_key . (string)$extra_config_value;
+        $extra_config_string .= $extra_config_key.(string)$extra_config_value;
       }
     } else {
       // only for backward compatibility
@@ -1138,7 +1138,7 @@ 
     }
 
     $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])) {
@@ -1225,10 +1225,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);
   }
@@ -1541,11 +1541,11 @@ 
 
       // 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++;
@@ -1559,7 +1559,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) {
@@ -1567,7 +1567,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;
   }
@@ -1590,7 +1590,7 @@ 
         )
     );
 
-    return '`' . $str . '`';
+    return '`'.$str.'`';
   }
 
   /**
@@ -1661,10 +1661,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);
   }
@@ -1762,7 +1762,7 @@ 
     $var = $this->escape($var, false, false, null);
 
     if (\is_string($var)) {
-      $var = "'" . trim($var, "'") . "'";
+      $var = "'".trim($var, "'")."'";
     }
 
     return $var;
@@ -1799,10 +1799,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);
   }
@@ -1844,9 +1844,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;
   }
@@ -1980,7 +1980,7 @@ 
       $result = call_user_func($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();
@@ -2033,10 +2033,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);
   }
@@ -2050,7 +2050,7 @@ 
    */
   public function table_exists($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
            &&

src/voku/db/ActiveRecord.php

Doc Comments +1 added lines, -1 removed lines

@@ -822,7 +822,7 @@
   /**
    * Helper function to build SQL with sql parts.
    *
-   * @param array $sqls <p>The SQL part will be build.</p>
+   * @param string[] $sqls <p>The SQL part will be build.</p>
    *
    * @return string
    */

Spacing +11 added lines, -11 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(
         array(
-            'operator' => 'INSERT INTO ' . $this->table,
+            'operator' => 'INSERT INTO '.$this->table,
             'target'   => new ActiveRecordExpressionsWrap(array('target' => array_keys($this->dirty))),
         )
     );
@@ -786,7 +786,7 @@ 
    * @param int          $i <p>The index of $n in $sql array.</p>
    * @param ActiveRecord $o <p>The reference to $this.</p>
    */
-  private function _buildSqlCallback(string &$n, $i, ActiveRecord $o)
+  private function _buildSqlCallback(string & $n, $i, ActiveRecord $o)
   {
     if (
         'select' === $n
@@ -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(
         array(
-            '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(
         array(
             'source'   => $this->join ?: '',
-            'operator' => $type . ' JOIN',
+            'operator' => $type.' JOIN',
             'target'   => new ActiveRecordExpressions(
                 array('source' => $table, 'operator' => 'ON', 'target' => $on)
             ),

src/voku/db/Prepare.php

Doc Comments +1 added lines, -1 removed lines

@@ -173,7 +173,7 @@
    * @param mixed  $v34
    * @param mixed  $v35
    *
-   * @return mixed
+   * @return boolean
    */
   public function bind_param_debug(string $types, &$v1 = null, &$v2 = null, &$v3 = null, &$v4 = null, &$v5 = null, &$v6 = null, &$v7 = null, &$v8 = null, &$v9 = null, &$v10 = null, &$v11 = null, &$v12 = null, &$v13 = null, &$v14 = null, &$v15 = null, &$v16 = null, &$v17 = null, &$v18 = null, &$v19 = null, &$v20 = null, &$v21 = null, &$v22 = null, &$v23 = null, &$v24 = null, &$v25 = null, &$v26 = null, &$v27 = null, &$v28 = null, &$v29 = null, &$v30 = null, &$v31 = null, &$v32 = null, &$v33 = null, &$v34 = null, &$v35 = null)
   {

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[] = array(
           '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/exceptions/QueryException.php

Spacing +1 added lines, -1 removed lines

@@ -1,6 +1,6 @@
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db\exceptions;
 

src/voku/db/exceptions/FetchingException.php

Spacing +1 added lines, -1 removed lines

@@ -1,6 +1,6 @@
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db\exceptions;
 

src/voku/db/exceptions/DBConnectException.php

Spacing +1 added lines, -1 removed lines

@@ -1,6 +1,6 @@
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db\exceptions;
 

src/voku/db/exceptions/DBGoneAwayException.php

Spacing +1 added lines, -1 removed lines

@@ -1,6 +1,6 @@
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db\exceptions;
 

src/voku/db/exceptions/ActiveRecordException.php

Spacing +1 added lines, -1 removed lines

@@ -1,6 +1,6 @@
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db\exceptions;
 

src/voku/db/Debug.php

Spacing +12 added lines, -12 removed lines

@@ -1,6 +1,6 @@ 
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db;
 
@@ -139,9 +139,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>',
         )
     );
 
@@ -153,11 +153,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>
         ';
@@ -295,21 +295,21 @@ 
     // get extra info
     $infoExtra = \mysqli_info($this->_db->getLink());
     if ($infoExtra) {
-      $infoExtra = ' | info => ' . $infoExtra;
+      $infoExtra = ' | info => '.$infoExtra;
     }
 
     //
     // 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(
         array(
             $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',
         )
     );
@@ -375,21 +375,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,
             )
         );
       }