@@ -340,7 +340,7 @@ |
||
| 340 | 340 | * Fetch as object. |
| 341 | 341 | * |
| 342 | 342 | * @param string $class |
| 343 | - * @param null|array $params |
|
| 343 | + * @param string $params |
|
| 344 | 344 | * @param bool $reset |
| 345 | 345 | * |
| 346 | 346 | * @return object|false <p><strong>false</strong> on error</p> |
@@ -282,12 +282,12 @@ discard block |
||
| 282 | 282 | $this->socket |
| 283 | 283 | ); |
| 284 | 284 | } catch (\Exception $e) { |
| 285 | - $this->_debug->displayError('Error connecting to mysql server: ' . $e->getMessage(), true); |
|
| 285 | + $this->_debug->displayError('Error connecting to mysql server: '.$e->getMessage(), true); |
|
| 286 | 286 | } |
| 287 | 287 | \mysqli_report(MYSQLI_REPORT_OFF); |
| 288 | 288 | |
| 289 | 289 | if (!$this->connected) { |
| 290 | - $this->_debug->displayError('Error connecting to mysql server: ' . \mysqli_connect_error(), true); |
|
| 290 | + $this->_debug->displayError('Error connecting to mysql server: '.\mysqli_connect_error(), true); |
|
| 291 | 291 | } else { |
| 292 | 292 | $this->set_charset($this->charset); |
| 293 | 293 | } |
@@ -382,7 +382,7 @@ discard block |
||
| 382 | 382 | static $firstInstance = null; |
| 383 | 383 | |
| 384 | 384 | if ( |
| 385 | - $hostname . $username . $password . $database . $port . $charset == '' |
|
| 385 | + $hostname.$username.$password.$database.$port.$charset == '' |
|
| 386 | 386 | && |
| 387 | 387 | null !== $firstInstance |
| 388 | 388 | ) { |
@@ -390,7 +390,7 @@ discard block |
||
| 390 | 390 | } |
| 391 | 391 | |
| 392 | 392 | $connection = md5( |
| 393 | - $hostname . $username . $password . $database . $port . $charset . (int)$exit_on_error . (int)$echo_on_error . $logger_class_name . $logger_level . (int)$session_to_db |
|
| 393 | + $hostname.$username.$password.$database.$port.$charset.(int)$exit_on_error.(int)$echo_on_error.$logger_class_name.$logger_level.(int)$session_to_db |
|
| 394 | 394 | ); |
| 395 | 395 | |
| 396 | 396 | if (!isset($instance[$connection])) { |
@@ -600,7 +600,7 @@ discard block |
||
| 600 | 600 | $var = $this->escape($var, false, false, null); |
| 601 | 601 | |
| 602 | 602 | if (is_string($var)) { |
| 603 | - $var = "'" . trim($var, "'") . "'"; |
|
| 603 | + $var = "'".trim($var, "'")."'"; |
|
| 604 | 604 | } |
| 605 | 605 | |
| 606 | 606 | return $var; |
@@ -786,11 +786,11 @@ discard block |
||
| 786 | 786 | |
| 787 | 787 | // exit if we have more then 3 "DB server has gone away"-errors |
| 788 | 788 | if ($RECONNECT_COUNTER > 3) { |
| 789 | - $this->_debug->mailToAdmin('SQL-Fatal-Error', $errorMsg . ":\n<br />" . $sql, 5); |
|
| 789 | + $this->_debug->mailToAdmin('SQL-Fatal-Error', $errorMsg.":\n<br />".$sql, 5); |
|
| 790 | 790 | throw new \Exception($errorMsg); |
| 791 | 791 | } |
| 792 | 792 | |
| 793 | - $this->_debug->mailToAdmin('SQL-Error', $errorMsg . ":\n<br />" . $sql); |
|
| 793 | + $this->_debug->mailToAdmin('SQL-Error', $errorMsg.":\n<br />".$sql); |
|
| 794 | 794 | |
| 795 | 795 | // reconnect |
| 796 | 796 | $RECONNECT_COUNTER++; |
@@ -800,10 +800,10 @@ discard block |
||
| 800 | 800 | return $this->query($sql, $sqlParams); |
| 801 | 801 | } |
| 802 | 802 | |
| 803 | - $this->_debug->mailToAdmin('SQL-Warning', $errorMsg . ":\n<br />" . $sql); |
|
| 803 | + $this->_debug->mailToAdmin('SQL-Warning', $errorMsg.":\n<br />".$sql); |
|
| 804 | 804 | |
| 805 | 805 | // this query returned an error, we must display it (only for dev) !!! |
| 806 | - $this->_debug->displayError($errorMsg . ' | ' . $sql); |
|
| 806 | + $this->_debug->displayError($errorMsg.' | '.$sql); |
|
| 807 | 807 | |
| 808 | 808 | return false; |
| 809 | 809 | } |
@@ -872,7 +872,7 @@ discard block |
||
| 872 | 872 | |
| 873 | 873 | if ($useCache === true) { |
| 874 | 874 | $cache = new Cache(null, null, false, $useCache); |
| 875 | - $cacheKey = 'sql-' . md5($query); |
|
| 875 | + $cacheKey = 'sql-'.md5($query); |
|
| 876 | 876 | |
| 877 | 877 | if ( |
| 878 | 878 | $cache->getCacheIsReady() === true |
@@ -987,9 +987,9 @@ discard block |
||
| 987 | 987 | |
| 988 | 988 | $return = mysqli_set_charset($this->link, $charset); |
| 989 | 989 | /** @noinspection PhpUsageOfSilenceOperatorInspection */ |
| 990 | - @\mysqli_query($this->link, 'SET CHARACTER SET ' . $charset); |
|
| 990 | + @\mysqli_query($this->link, 'SET CHARACTER SET '.$charset); |
|
| 991 | 991 | /** @noinspection PhpUsageOfSilenceOperatorInspection */ |
| 992 | - @\mysqli_query($this->link, "SET NAMES '" . $charset . "'"); |
|
| 992 | + @\mysqli_query($this->link, "SET NAMES '".$charset."'"); |
|
| 993 | 993 | |
| 994 | 994 | return $return; |
| 995 | 995 | } |
@@ -1076,10 +1076,10 @@ discard block |
||
| 1076 | 1076 | |
| 1077 | 1077 | if ($this->_debug->checkForDev() === true) { |
| 1078 | 1078 | echo "Info: maybe you have to increase your 'max_allowed_packet = 30M' in the config: 'my.conf' \n<br />"; |
| 1079 | - echo 'Error:' . $errorMsg; |
|
| 1079 | + echo 'Error:'.$errorMsg; |
|
| 1080 | 1080 | } |
| 1081 | 1081 | |
| 1082 | - $this->_debug->mailToAdmin('SQL-Error in mysqli_multi_query', $errorMsg . ":\n<br />" . $sql); |
|
| 1082 | + $this->_debug->mailToAdmin('SQL-Error in mysqli_multi_query', $errorMsg.":\n<br />".$sql); |
|
| 1083 | 1083 | } |
| 1084 | 1084 | |
| 1085 | 1085 | // return the result only if there was a "SELECT"-query |
@@ -1118,7 +1118,7 @@ discard block |
||
| 1118 | 1118 | } |
| 1119 | 1119 | |
| 1120 | 1120 | if (\mysqli_connect_errno()) { |
| 1121 | - $this->_debug->displayError('Error connecting to mysql server: ' . \mysqli_connect_error(), true); |
|
| 1121 | + $this->_debug->displayError('Error connecting to mysql server: '.\mysqli_connect_error(), true); |
|
| 1122 | 1122 | |
| 1123 | 1123 | return false; |
| 1124 | 1124 | } |
@@ -1229,10 +1229,10 @@ discard block |
||
| 1229 | 1229 | $SET = $this->_parseArrayPair($data); |
| 1230 | 1230 | |
| 1231 | 1231 | if ($database) { |
| 1232 | - $database = $this->quote_string(trim($database)) . '.'; |
|
| 1232 | + $database = $this->quote_string(trim($database)).'.'; |
|
| 1233 | 1233 | } |
| 1234 | 1234 | |
| 1235 | - $sql = 'INSERT INTO ' . $database . $this->quote_string($table) . " SET $SET;"; |
|
| 1235 | + $sql = 'INSERT INTO '.$database.$this->quote_string($table)." SET $SET;"; |
|
| 1236 | 1236 | |
| 1237 | 1237 | return $this->query($sql); |
| 1238 | 1238 | } |
@@ -1329,9 +1329,9 @@ discard block |
||
| 1329 | 1329 | } |
| 1330 | 1330 | |
| 1331 | 1331 | if ($_connector === 'NOT IN' || $_connector === 'IN') { |
| 1332 | - $_value = '(' . implode(',', $_value) . ')'; |
|
| 1332 | + $_value = '('.implode(',', $_value).')'; |
|
| 1333 | 1333 | } elseif ($_connector === 'NOT BETWEEN' || $_connector === 'BETWEEN') { |
| 1334 | - $_value = '(' . implode(' AND ', $_value) . ')'; |
|
| 1334 | + $_value = '('.implode(' AND ', $_value).')'; |
|
| 1335 | 1335 | } |
| 1336 | 1336 | |
| 1337 | 1337 | } else { |
@@ -1376,7 +1376,7 @@ discard block |
||
| 1376 | 1376 | $_glueHelperInner = 'AND ('; // inner-loop "OR"-query glue |
| 1377 | 1377 | } |
| 1378 | 1378 | |
| 1379 | - $sql .= ' ' . $_glueHelperInner . ' ' . $quoteString . ' ' . $_connector . ' ' . $valueInner . " \n"; |
|
| 1379 | + $sql .= ' '.$_glueHelperInner.' '.$quoteString.' '.$_connector.' '.$valueInner." \n"; |
|
| 1380 | 1380 | $tmpCounter++; |
| 1381 | 1381 | } |
| 1382 | 1382 | |
@@ -1409,7 +1409,7 @@ discard block |
||
| 1409 | 1409 | ) |
| 1410 | 1410 | ); |
| 1411 | 1411 | |
| 1412 | - return '`' . $str . '`'; |
|
| 1412 | + return '`'.$str.'`'; |
|
| 1413 | 1413 | } |
| 1414 | 1414 | |
| 1415 | 1415 | /** |
@@ -1465,10 +1465,10 @@ discard block |
||
| 1465 | 1465 | $values = implode(',', $data); |
| 1466 | 1466 | |
| 1467 | 1467 | if ($database) { |
| 1468 | - $database = $this->quote_string(trim($database)) . '.'; |
|
| 1468 | + $database = $this->quote_string(trim($database)).'.'; |
|
| 1469 | 1469 | } |
| 1470 | 1470 | |
| 1471 | - $sql = 'REPLACE INTO ' . $database . $this->quote_string($table) . " ($columns) VALUES ($values);"; |
|
| 1471 | + $sql = 'REPLACE INTO '.$database.$this->quote_string($table)." ($columns) VALUES ($values);"; |
|
| 1472 | 1472 | |
| 1473 | 1473 | return $this->query($sql); |
| 1474 | 1474 | } |
@@ -1511,10 +1511,10 @@ discard block |
||
| 1511 | 1511 | } |
| 1512 | 1512 | |
| 1513 | 1513 | if ($database) { |
| 1514 | - $database = $this->quote_string(trim($database)) . '.'; |
|
| 1514 | + $database = $this->quote_string(trim($database)).'.'; |
|
| 1515 | 1515 | } |
| 1516 | 1516 | |
| 1517 | - $sql = 'UPDATE ' . $database . $this->quote_string($table) . " SET $SET WHERE ($WHERE);"; |
|
| 1517 | + $sql = 'UPDATE '.$database.$this->quote_string($table)." SET $SET WHERE ($WHERE);"; |
|
| 1518 | 1518 | |
| 1519 | 1519 | return $this->query($sql); |
| 1520 | 1520 | } |
@@ -1548,10 +1548,10 @@ discard block |
||
| 1548 | 1548 | } |
| 1549 | 1549 | |
| 1550 | 1550 | if ($database) { |
| 1551 | - $database = $this->quote_string(trim($database)) . '.'; |
|
| 1551 | + $database = $this->quote_string(trim($database)).'.'; |
|
| 1552 | 1552 | } |
| 1553 | 1553 | |
| 1554 | - $sql = 'DELETE FROM ' . $database . $this->quote_string($table) . " WHERE ($WHERE);"; |
|
| 1554 | + $sql = 'DELETE FROM '.$database.$this->quote_string($table)." WHERE ($WHERE);"; |
|
| 1555 | 1555 | |
| 1556 | 1556 | return $this->query($sql); |
| 1557 | 1557 | } |
@@ -1585,10 +1585,10 @@ discard block |
||
| 1585 | 1585 | } |
| 1586 | 1586 | |
| 1587 | 1587 | if ($database) { |
| 1588 | - $database = $this->quote_string(trim($database)) . '.'; |
|
| 1588 | + $database = $this->quote_string(trim($database)).'.'; |
|
| 1589 | 1589 | } |
| 1590 | 1590 | |
| 1591 | - $sql = 'SELECT * FROM ' . $database . $this->quote_string($table) . " WHERE ($WHERE);"; |
|
| 1591 | + $sql = 'SELECT * FROM '.$database.$this->quote_string($table)." WHERE ($WHERE);"; |
|
| 1592 | 1592 | |
| 1593 | 1593 | return $this->query($sql); |
| 1594 | 1594 | } |