@@ -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 |