@@ -16,9 +16,9 @@ |
||
| 16 | 16 | { |
| 17 | 17 | $this->useDbEnv(); |
| 18 | 18 | |
| 19 | - $dsn = 'mysql:host='.$this->_host; |
|
| 20 | - $dsn .= (isset($this->_port)) ? ';port='.$this->_port : ''; |
|
| 21 | - $dsn .= ';dbname='.$this->_database; |
|
| 19 | + $dsn = 'mysql:host=' . $this->_host; |
|
| 20 | + $dsn .= (isset($this->_port)) ? ';port=' . $this->_port : ''; |
|
| 21 | + $dsn .= ';dbname=' . $this->_database; |
|
| 22 | 22 | |
| 23 | 23 | try { |
| 24 | 24 | $this->_pdo = new PDO($dsn, $this->_username, $this->_password); |
@@ -16,11 +16,11 @@ |
||
| 16 | 16 | { |
| 17 | 17 | $this->useDbEnv(); |
| 18 | 18 | |
| 19 | - $dsn = 'pgsql:host='.$this->_host; |
|
| 20 | - $dsn .= (isset($this->_port)) ? ';port='.$this->_port : ''; |
|
| 21 | - $dsn .= ';dbname='.$this->_database; |
|
| 22 | - $dsn .= ';user='.$this->_username; |
|
| 23 | - $dsn .= ';password='.$this->_password; |
|
| 19 | + $dsn = 'pgsql:host=' . $this->_host; |
|
| 20 | + $dsn .= (isset($this->_port)) ? ';port=' . $this->_port : ''; |
|
| 21 | + $dsn .= ';dbname=' . $this->_database; |
|
| 22 | + $dsn .= ';user=' . $this->_username; |
|
| 23 | + $dsn .= ';password=' . $this->_password; |
|
| 24 | 24 | |
| 25 | 25 | try { |
| 26 | 26 | $this->_pdo = new PDO($dsn); |
@@ -51,7 +51,7 @@ |
||
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | if (is_null($table)) { |
| 54 | - $this->setTable(get_class($this).'-table'); |
|
| 54 | + $this->setTable(get_class($this) . '-table'); |
|
| 55 | 55 | } else { |
| 56 | 56 | $this->setTable($table); |
| 57 | 57 | } |
@@ -73,7 +73,7 @@ discard block |
||
| 73 | 73 | */ |
| 74 | 74 | protected function loadDbEnv() |
| 75 | 75 | { |
| 76 | - $dotenv = new Dotenv(__DIR__.'/../..'); |
|
| 76 | + $dotenv = new Dotenv(__DIR__ . '/../..'); |
|
| 77 | 77 | $dotenv->required(['DB_HOST', 'DB_DATABASE', 'DB_USERNAME', 'DB_PASSWORD'])->notEmpty(); |
| 78 | 78 | $dotenv->required(['DB_PORT']); |
| 79 | 79 | $dotenv->load(); |
@@ -121,9 +121,9 @@ discard block |
||
| 121 | 121 | $sql = "INSERT INTO {$table} ("; |
| 122 | 122 | foreach ($record as $key => $value) { |
| 123 | 123 | if ($count > 1) { |
| 124 | - $sql = $sql."{$key}, "; |
|
| 124 | + $sql = $sql . "{$key}, "; |
|
| 125 | 125 | } else { |
| 126 | - $sql = $sql."{$key}) "; |
|
| 126 | + $sql = $sql . "{$key}) "; |
|
| 127 | 127 | } |
| 128 | 128 | $count--; |
| 129 | 129 | } |
@@ -133,9 +133,9 @@ discard block |
||
| 133 | 133 | $sql .= "VALUES ("; |
| 134 | 134 | foreach ($record as $key => $value) { |
| 135 | 135 | if ($count > 1) { |
| 136 | - $sql = $sql."{$value}, "; |
|
| 136 | + $sql = $sql . "{$value}, "; |
|
| 137 | 137 | } else { |
| 138 | - $sql = $sql."{$value}) "; |
|
| 138 | + $sql = $sql . "{$value}) "; |
|
| 139 | 139 | } |
| 140 | 140 | $count--; |
| 141 | 141 | } |
@@ -237,9 +237,9 @@ discard block |
||
| 237 | 237 | $sql = "UPDATE {$table} SET "; |
| 238 | 238 | foreach ($record as $key => $value) { |
| 239 | 239 | if ($count > 1) { |
| 240 | - $sql = $sql."{$key}={$value}, "; |
|
| 240 | + $sql = $sql . "{$key}={$value}, "; |
|
| 241 | 241 | } else { |
| 242 | - $sql = $sql."{$key}={$value} "; |
|
| 242 | + $sql = $sql . "{$key}={$value} "; |
|
| 243 | 243 | } |
| 244 | 244 | $count--; |
| 245 | 245 | } |