voku / simple-mysqli

src/voku/db/ActiveRecord.php

Doc Comments +1 added lines, -1 removed lines

@@ -659,7 +659,7 @@
    * @param array     $param          <p>
    *                                  The param will be bind to the $sql query.
    *                                  </p>
-   * @param null|self $obj            <p>
+   * @param null|\self $obj            <p>
    *                                  The object, if find record in database, we will assign the attributes into
    *                                  this object.
    *                                  </p>

Spacing +10 added lines, -10 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(
         [
-            'operator' => 'INSERT INTO ' . $this->table,
+            'operator' => 'INSERT INTO '.$this->table,
             'target'   => new ActiveRecordExpressionsWrap(['target' => \array_keys($this->dirty)]),
         ]
     );
@@ -794,7 +794,7 @@ 
         null === $active_record->{$sql_string_part}
     ) {
 
-      $sql_string_part = \strtoupper($sql_string_part) . ' ' . $active_record->table . '.*';
+      $sql_string_part = \strtoupper($sql_string_part).' '.$active_record->table.'.*';
 
     } elseif (
         (
@@ -806,15 +806,15 @@ 
         null === $active_record->{$sql_string_part}
     ) {
 
-      $sql_string_part = \strtoupper($sql_string_part) . ' ' . $active_record->table;
+      $sql_string_part = \strtoupper($sql_string_part).' '.$active_record->table;
 
     } elseif ('delete' === $sql_string_part) {
 
-      $sql_string_part = \strtoupper($sql_string_part) . ' ';
+      $sql_string_part = \strtoupper($sql_string_part).' ';
 
     } else {
 
-      $sql_string_part = (null !== $active_record->{$sql_string_part}) ? $active_record->{$sql_string_part} . ' ' : '';
+      $sql_string_part = (null !== $active_record->{$sql_string_part}) ? $active_record->{$sql_string_part}.' ' : '';
 
     }
   }
@@ -928,10 +928,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;
     }
 
@@ -952,7 +952,7 @@ 
     $value = $this->_filterParam($value);
     $expression = new ActiveRecordExpressions(
         [
-            'source'   => ('where' === strtolower($name) ? $this->table . '.' : '') . $field,
+            'source'   => ('where' === strtolower($name) ? $this->table.'.' : '').$field,
             'operator' => $operator,
             'target'   => \is_array($value)
                 ? new ActiveRecordExpressionsWrap(
@@ -986,7 +986,7 @@ 
     $this->join = new ActiveRecordExpressions(
         [
             'source'   => $this->join ?: '',
-            'operator' => $type . ' JOIN',
+            'operator' => $type.' JOIN',
             'target'   => new ActiveRecordExpressions(
                 ['source' => $table, 'operator' => 'ON', 'target' => $on]
             ),

src/voku/db/DB.php

Doc Comments +2 added lines, -2 removed lines

@@ -995,7 +995,7 @@ 
    * @param string    $query    <p>sql-query</p>
    * @param bool      $useCache <p>use cache?</p>
    * @param int       $cacheTTL <p>cache-ttl in seconds</p>
-   * @param self|null $db       optional <p>the database connection</p>
+   * @param null|\self $db       optional <p>the database connection</p>
    *
    * @return mixed "array" by "<b>SELECT</b>"-queries<br />
    *               "int" (insert_id) by "<b>INSERT</b>"-queries<br />
@@ -1741,7 +1741,7 @@ 
    *
    * @param mixed $var
    *
-   * @return mixed
+   * @return string
    */
   public function secure($var)
   {

Spacing +33 added lines, -33 removed lines

@@ -1,6 +1,6 @@ 
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace voku\db;
 
@@ -448,9 +448,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 {
@@ -497,7 +497,7 @@ 
           $valueInner = "''";
         }
 
-        $sql .= ' ' . $_glueHelperInner . ' ' . $quoteString . ' ' . $_connector . ' ' . $valueInner . " \n";
+        $sql .= ' '.$_glueHelperInner.' '.$quoteString.' '.$_connector.' '.$valueInner." \n";
         $tmpCounter++;
       }
 
@@ -704,7 +704,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);
     }
@@ -712,7 +712,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);
     }
@@ -753,10 +753,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);
   }
@@ -829,8 +829,8 @@ 
         $nameTmp = \substr($name, 1);
       }
 
-      $parseKeyInner = $nameTmp . '-' . $PARSE_KEY_CACHE;
-      $sql = \str_replace(':' . $nameTmp, $parseKeyInner, $sql);
+      $parseKeyInner = $nameTmp.'-'.$PARSE_KEY_CACHE;
+      $sql = \str_replace(':'.$nameTmp, $parseKeyInner, $sql);
     }
 
     foreach ($params as $name => $value) {
@@ -839,7 +839,7 @@ 
         $nameTmp = \substr($name, 1);
       }
 
-      $parseKeyInner = $nameTmp . '-' . $PARSE_KEY_CACHE;
+      $parseKeyInner = $nameTmp.'-'.$PARSE_KEY_CACHE;
       $sqlBefore = $sql;
       $secureParamValue = $this->secure($params[$name]);
 
@@ -1015,7 +1015,7 @@ 
 
     if ($useCache === true) {
       $cache = new Cache(null, null, false, $useCache);
-      $cacheKey = 'sql-' . \md5($query);
+      $cacheKey = 'sql-'.\md5($query);
 
       if (
           $cache->getCacheIsReady() === true
@@ -1126,7 +1126,7 @@ 
     static $firstInstance = null;
 
     if (
-        $hostname . $username . $password . $database . $port . $charset == '3306utf8'
+        $hostname.$username.$password.$database.$port.$charset == '3306utf8'
         &&
         null !== $firstInstance
     ) {
@@ -1140,7 +1140,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
@@ -1148,7 +1148,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])) {
@@ -1239,10 +1239,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);
   }
@@ -1553,11 +1553,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++;
@@ -1571,7 +1571,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) {
@@ -1579,7 +1579,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;
   }
@@ -1602,7 +1602,7 @@ 
         )
     );
 
-    return '`' . $str . '`';
+    return '`'.$str.'`';
   }
 
   /**
@@ -1673,10 +1673,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);
   }
@@ -1772,7 +1772,7 @@ 
     $var = $this->escape($var, false, false, null);
 
     if (\is_string($var)) {
-      $var = "'" . \trim($var, "'") . "'";
+      $var = "'".\trim($var, "'")."'";
     }
 
     return $var;
@@ -1809,10 +1809,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);
   }
@@ -1854,9 +1854,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;
   }
@@ -1990,7 +1990,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();
@@ -2043,10 +2043,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);
   }
@@ -2060,7 +2060,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
            &&

src/voku/db/ActiveRecordExpressionsWrap.php

Spacing +1 added lines, -1 removed lines

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