@@ -277,12 +277,12 @@ discard block |
||
| 277 | 277 | $this->socket |
| 278 | 278 | ); |
| 279 | 279 | } catch (\Exception $e) { |
| 280 | - $this->_debug->displayError('Error connecting to mysql server: ' . $e->getMessage(), true); |
|
| 280 | + $this->_debug->displayError('Error connecting to mysql server: '.$e->getMessage(), true); |
|
| 281 | 281 | } |
| 282 | 282 | mysqli_report(MYSQLI_REPORT_OFF); |
| 283 | 283 | |
| 284 | 284 | if (!$this->connected) { |
| 285 | - $this->_debug->displayError('Error connecting to mysql server: ' . mysqli_connect_error(), true); |
|
| 285 | + $this->_debug->displayError('Error connecting to mysql server: '.mysqli_connect_error(), true); |
|
| 286 | 286 | } else { |
| 287 | 287 | $this->set_charset($this->charset); |
| 288 | 288 | } |
@@ -376,7 +376,7 @@ discard block |
||
| 376 | 376 | static $firstInstance = null; |
| 377 | 377 | |
| 378 | 378 | if ( |
| 379 | - $hostname . $username . $password . $database . $port . $charset == '' |
|
| 379 | + $hostname.$username.$password.$database.$port.$charset == '' |
|
| 380 | 380 | && |
| 381 | 381 | null !== $firstInstance |
| 382 | 382 | ) { |
@@ -384,7 +384,7 @@ discard block |
||
| 384 | 384 | } |
| 385 | 385 | |
| 386 | 386 | $connection = md5( |
| 387 | - $hostname . $username . $password . $database . $port . $charset . (int)$exit_on_error . (int)$echo_on_error . $logger_class_name . $logger_level . (int)$session_to_db |
|
| 387 | + $hostname.$username.$password.$database.$port.$charset.(int)$exit_on_error.(int)$echo_on_error.$logger_class_name.$logger_level.(int)$session_to_db |
|
| 388 | 388 | ); |
| 389 | 389 | |
| 390 | 390 | if (!isset($instance[$connection])) { |
@@ -592,7 +592,7 @@ discard block |
||
| 592 | 592 | $var = $this->escape($var, false, false, null); |
| 593 | 593 | |
| 594 | 594 | if (is_string($var)) { |
| 595 | - $var = "'" . trim($var, "'") . "'"; |
|
| 595 | + $var = "'".trim($var, "'")."'"; |
|
| 596 | 596 | } |
| 597 | 597 | |
| 598 | 598 | return $var; |
@@ -760,10 +760,10 @@ discard block |
||
| 760 | 760 | |
| 761 | 761 | // exit if we have more then 3 "DB server has gone away"-errors |
| 762 | 762 | if ($reconnectCounter > 3) { |
| 763 | - $this->_debug->mailToAdmin('SQL-Fatal-Error', $errorMsg . ":\n<br />" . $sql, 5); |
|
| 763 | + $this->_debug->mailToAdmin('SQL-Fatal-Error', $errorMsg.":\n<br />".$sql, 5); |
|
| 764 | 764 | throw new \Exception($errorMsg); |
| 765 | 765 | } else { |
| 766 | - $this->_debug->mailToAdmin('SQL-Error', $errorMsg . ":\n<br />" . $sql); |
|
| 766 | + $this->_debug->mailToAdmin('SQL-Error', $errorMsg.":\n<br />".$sql); |
|
| 767 | 767 | |
| 768 | 768 | // reconnect |
| 769 | 769 | $reconnectCounter++; |
@@ -773,10 +773,10 @@ discard block |
||
| 773 | 773 | return $this->query($sql, $sqlParams); |
| 774 | 774 | } |
| 775 | 775 | } else { |
| 776 | - $this->_debug->mailToAdmin('SQL-Warning', $errorMsg . ":\n<br />" . $sql); |
|
| 776 | + $this->_debug->mailToAdmin('SQL-Warning', $errorMsg.":\n<br />".$sql); |
|
| 777 | 777 | |
| 778 | 778 | // this query returned an error, we must display it (only for dev) !!! |
| 779 | - $this->_debug->displayError($errorMsg . ' | ' . $sql); |
|
| 779 | + $this->_debug->displayError($errorMsg.' | '.$sql); |
|
| 780 | 780 | } |
| 781 | 781 | |
| 782 | 782 | return false; |
@@ -844,7 +844,7 @@ discard block |
||
| 844 | 844 | |
| 845 | 845 | if ($useCache === true) { |
| 846 | 846 | $cache = new Cache(null, null, false, $useCache); |
| 847 | - $cacheKey = 'sql-' . md5($query); |
|
| 847 | + $cacheKey = 'sql-'.md5($query); |
|
| 848 | 848 | |
| 849 | 849 | if ( |
| 850 | 850 | $cache->getCacheIsReady() === true |
@@ -914,9 +914,9 @@ discard block |
||
| 914 | 914 | |
| 915 | 915 | $return = mysqli_set_charset($this->link, $charset); |
| 916 | 916 | /** @noinspection PhpUsageOfSilenceOperatorInspection */ |
| 917 | - @mysqli_query($this->link, 'SET CHARACTER SET ' . $charset); |
|
| 917 | + @mysqli_query($this->link, 'SET CHARACTER SET '.$charset); |
|
| 918 | 918 | /** @noinspection PhpUsageOfSilenceOperatorInspection */ |
| 919 | - @mysqli_query($this->link, "SET NAMES '" . $charset . "'"); |
|
| 919 | + @mysqli_query($this->link, "SET NAMES '".$charset."'"); |
|
| 920 | 920 | |
| 921 | 921 | return $return; |
| 922 | 922 | } |
@@ -1003,10 +1003,10 @@ discard block |
||
| 1003 | 1003 | |
| 1004 | 1004 | if ($this->_debug->checkForDev() === true) { |
| 1005 | 1005 | echo "Info: maybe you have to increase your 'max_allowed_packet = 30M' in the config: 'my.conf' \n<br />"; |
| 1006 | - echo 'Error:' . $errorMsg; |
|
| 1006 | + echo 'Error:'.$errorMsg; |
|
| 1007 | 1007 | } |
| 1008 | 1008 | |
| 1009 | - $this->_debug->mailToAdmin('SQL-Error in mysqli_multi_query', $errorMsg . ":\n<br />" . $sql); |
|
| 1009 | + $this->_debug->mailToAdmin('SQL-Error in mysqli_multi_query', $errorMsg.":\n<br />".$sql); |
|
| 1010 | 1010 | } |
| 1011 | 1011 | |
| 1012 | 1012 | // return the result only if there was a "SELECT"-query |
@@ -1043,7 +1043,7 @@ discard block |
||
| 1043 | 1043 | |
| 1044 | 1044 | return false; |
| 1045 | 1045 | } elseif (mysqli_connect_errno()) { |
| 1046 | - $this->_debug->displayError('Error connecting to mysql server: ' . mysqli_connect_error(), true); |
|
| 1046 | + $this->_debug->displayError('Error connecting to mysql server: '.mysqli_connect_error(), true); |
|
| 1047 | 1047 | |
| 1048 | 1048 | return false; |
| 1049 | 1049 | } else { |
@@ -1152,7 +1152,7 @@ discard block |
||
| 1152 | 1152 | |
| 1153 | 1153 | $SET = $this->_parseArrayPair($data); |
| 1154 | 1154 | |
| 1155 | - $sql = 'INSERT INTO ' . $this->quote_string($table) . " SET $SET;"; |
|
| 1155 | + $sql = 'INSERT INTO '.$this->quote_string($table)." SET $SET;"; |
|
| 1156 | 1156 | |
| 1157 | 1157 | return $this->query($sql); |
| 1158 | 1158 | } |
@@ -1240,9 +1240,9 @@ discard block |
||
| 1240 | 1240 | } |
| 1241 | 1241 | |
| 1242 | 1242 | if ($_connector === 'NOT IN' || $_connector === 'IN') { |
| 1243 | - $_value = '(' . implode(',', $_value) . ')'; |
|
| 1243 | + $_value = '('.implode(',', $_value).')'; |
|
| 1244 | 1244 | } elseif ($_connector === 'NOT BETWEEN' || $_connector === 'BETWEEN') { |
| 1245 | - $_value = '(' . implode(' AND ', $_value) . ')'; |
|
| 1245 | + $_value = '('.implode(' AND ', $_value).')'; |
|
| 1246 | 1246 | } |
| 1247 | 1247 | |
| 1248 | 1248 | } else { |
@@ -1250,7 +1250,7 @@ discard block |
||
| 1250 | 1250 | } |
| 1251 | 1251 | |
| 1252 | 1252 | $quoteString = $this->quote_string(trim(str_ireplace($_connector, '', $_key))); |
| 1253 | - $pairs[] = ' ' . $quoteString . ' ' . $_connector . ' ' . $_value . " \n"; |
|
| 1253 | + $pairs[] = ' '.$quoteString.' '.$_connector.' '.$_value." \n"; |
|
| 1254 | 1254 | } |
| 1255 | 1255 | |
| 1256 | 1256 | $sql = implode($glue, $pairs); |
@@ -1268,7 +1268,7 @@ discard block |
||
| 1268 | 1268 | */ |
| 1269 | 1269 | public function quote_string($str) |
| 1270 | 1270 | { |
| 1271 | - return '`' . $this->escape($str, false) . '`'; |
|
| 1271 | + return '`'.$this->escape($str, false).'`'; |
|
| 1272 | 1272 | } |
| 1273 | 1273 | |
| 1274 | 1274 | /** |
@@ -1322,7 +1322,7 @@ discard block |
||
| 1322 | 1322 | } |
| 1323 | 1323 | $values = implode(',', $data); |
| 1324 | 1324 | |
| 1325 | - $sql = 'REPLACE INTO ' . $this->quote_string($table) . " ($columns) VALUES ($values);"; |
|
| 1325 | + $sql = 'REPLACE INTO '.$this->quote_string($table)." ($columns) VALUES ($values);"; |
|
| 1326 | 1326 | |
| 1327 | 1327 | return $this->query($sql); |
| 1328 | 1328 | } |
@@ -1362,7 +1362,7 @@ discard block |
||
| 1362 | 1362 | $WHERE = ''; |
| 1363 | 1363 | } |
| 1364 | 1364 | |
| 1365 | - $sql = 'UPDATE ' . $this->quote_string($table) . " SET $SET WHERE ($WHERE);"; |
|
| 1365 | + $sql = 'UPDATE '.$this->quote_string($table)." SET $SET WHERE ($WHERE);"; |
|
| 1366 | 1366 | |
| 1367 | 1367 | return $this->query($sql); |
| 1368 | 1368 | } |
@@ -1394,7 +1394,7 @@ discard block |
||
| 1394 | 1394 | $WHERE = ''; |
| 1395 | 1395 | } |
| 1396 | 1396 | |
| 1397 | - $sql = 'DELETE FROM ' . $this->quote_string($table) . " WHERE ($WHERE);"; |
|
| 1397 | + $sql = 'DELETE FROM '.$this->quote_string($table)." WHERE ($WHERE);"; |
|
| 1398 | 1398 | |
| 1399 | 1399 | return $this->query($sql); |
| 1400 | 1400 | } |
@@ -1424,7 +1424,7 @@ discard block |
||
| 1424 | 1424 | $WHERE = ''; |
| 1425 | 1425 | } |
| 1426 | 1426 | |
| 1427 | - $sql = 'SELECT * FROM ' . $this->quote_string($table) . " WHERE ($WHERE);"; |
|
| 1427 | + $sql = 'SELECT * FROM '.$this->quote_string($table)." WHERE ($WHERE);"; |
|
| 1428 | 1428 | |
| 1429 | 1429 | return $this->query($sql); |
| 1430 | 1430 | } |