@@ -81,7 +81,7 @@ discard block |
||
| 81 | 81 | public function listTables() |
| 82 | 82 | { |
| 83 | 83 | return $this->conn->query( |
| 84 | - 'SELECT table_name FROM information_schema.tables WHERE table_schema = \'' . $this->tableSchema . '\';' |
|
| 84 | + 'SELECT table_name FROM information_schema.tables WHERE table_schema = \''.$this->tableSchema.'\';' |
|
| 85 | 85 | )->fetchAll(\PDO::FETCH_COLUMN, 0); |
| 86 | 86 | } |
| 87 | 87 | |
@@ -137,13 +137,13 @@ discard block |
||
| 137 | 137 | */ |
| 138 | 138 | public function listFields($table) |
| 139 | 139 | { |
| 140 | - $sth = $this->conn->query('SELECT * FROM information_schema.columns WHERE table_name =\'' . $table . '\''); |
|
| 140 | + $sth = $this->conn->query('SELECT * FROM information_schema.columns WHERE table_name =\''.$table.'\''); |
|
| 141 | 141 | $result = []; |
| 142 | 142 | |
| 143 | 143 | foreach ($sth->fetchAll(\PDO::FETCH_ASSOC) as $row) { |
| 144 | 144 | $result[] = [ |
| 145 | 145 | 'field' => $row['column_name'], |
| 146 | - 'type' => $row['data_type'] . (($max = $row['character_maximum_length']) ? '(' . $max . ')' : ''), |
|
| 146 | + 'type' => $row['data_type'].(($max = $row['character_maximum_length']) ? '('.$max.')' : ''), |
|
| 147 | 147 | 'null' => $row['is_nullable'], |
| 148 | 148 | 'default' => $row['column_default'] |
| 149 | 149 | ]; |
@@ -180,8 +180,8 @@ discard block |
||
| 180 | 180 | */ |
| 181 | 181 | public function insert($table, array $line = [], $multi = false) |
| 182 | 182 | { |
| 183 | - $fields = '"' . implode('", "', array_keys($multi ? $line[0] : $line)) . '"'; |
|
| 184 | - $values = ':' . implode(', :', array_keys($multi ? $line[0] : $line)); |
|
| 183 | + $fields = '"'.implode('", "', array_keys($multi ? $line[0] : $line)).'"'; |
|
| 184 | + $values = ':'.implode(', :', array_keys($multi ? $line[0] : $line)); |
|
| 185 | 185 | $rows = $multi ? $line : [$line]; |
| 186 | 186 | $id = null; |
| 187 | 187 | |
@@ -190,7 +190,7 @@ discard block |
||
| 190 | 190 | |
| 191 | 191 | $dbh = null; |
| 192 | 192 | foreach ($rows AS $row) { |
| 193 | - $res = $this->conn->prepare('INSERT INTO ' . $table . ' (' . $fields . ') VALUES (' . $values . ');'); |
|
| 193 | + $res = $this->conn->prepare('INSERT INTO '.$table.' ('.$fields.') VALUES ('.$values.');'); |
|
| 194 | 194 | $dbh = $res->execute($row); |
| 195 | 195 | } |
| 196 | 196 | |