linpax / microphp-framework

db/drivers/PgsqlDriver.php

Spacing +9 added lines, -9 removed lines

@@ -81,7 +81,7 @@ 
     public function listTables()
     {
         return $this->conn->query(
-            'SELECT table_name FROM information_schema.tables WHERE table_schema = \'' . $this->tableSchema . '\';'
+            'SELECT table_name FROM information_schema.tables WHERE table_schema = \''.$this->tableSchema.'\';'
         )->fetchAll(\PDO::FETCH_COLUMN, 0);
     }
 
@@ -137,13 +137,13 @@ 
      */
     public function listFields($table)
     {
-        $sth = $this->conn->query('SELECT * FROM information_schema.columns WHERE table_name =\'' . $table . '\'');
+        $sth = $this->conn->query('SELECT * FROM information_schema.columns WHERE table_name =\''.$table.'\'');
         $result = [];
 
         foreach ($sth->fetchAll(\PDO::FETCH_ASSOC) as $row) {
             $result[] = [
                 'field' => $row['column_name'],
-                'type' => $row['data_type'] . (($max = $row['character_maximum_length']) ? '(' . $max . ')' : ''),
+                'type' => $row['data_type'].(($max = $row['character_maximum_length']) ? '('.$max.')' : ''),
                 'null' => $row['is_nullable'],
                 'default' => $row['column_default']
             ];
@@ -180,8 +180,8 @@ 
      */
     public function insert($table, array $line = [], $multi = false)
     {
-        $fields = '"' . implode('", "', array_keys($multi ? $line[0] : $line)) . '"';
-        $values = ':' . implode(', :', array_keys($multi ? $line[0] : $line));
+        $fields = '"'.implode('", "', array_keys($multi ? $line[0] : $line)).'"';
+        $values = ':'.implode(', :', array_keys($multi ? $line[0] : $line));
         $rows = $multi ? $line : [$line];
         $id = null;
 
@@ -190,9 +190,9 @@ 
 
             $dbh = null;
             foreach ($rows AS $row) {
-                $res = $this->conn->prepare('INSERT INTO ' . $table . ' (' . $fields . ') VALUES (' . $values . ');');
+                $res = $this->conn->prepare('INSERT INTO '.$table.' ('.$fields.') VALUES ('.$values.');');
                 $dbh = $res->execute($row);
-                die(var_dump($res->errorCode() . ': ' . print_r($res->errorInfo(), true)));
+                die(var_dump($res->errorCode().': '.print_r($res->errorInfo(), true)));
             }
 
             $id = $dbh ? $this->conn->lastInsertId() : false;
@@ -264,10 +264,10 @@ 
         $keys = [];
 
         foreach ($params AS $key => $val) {
-            $keys[] = '"' . $key . '"=\'' . $val . '\'';
+            $keys[] = '"'.$key.'"=\''.$val.'\'';
         }
 
-        $sth = $this->conn->prepare('SELECT * FROM ' . $table . ' WHERE ' . implode(' AND ', $keys) . ' LIMIT 1;');
+        $sth = $this->conn->prepare('SELECT * FROM '.$table.' WHERE '.implode(' AND ', $keys).' LIMIT 1;');
         /** @noinspection PdoApiUsageInspection */
         $sth->execute();
 

db/drivers/MysqlDriver.php

Spacing +3 added lines, -3 removed lines

@@ -181,7 +181,7 @@ 
      */
     public function insert($table, array $line = [], $multi = false)
     {
-        $fields = '`' . implode('`, `', array_keys($multi ? $line[0] : $line)) . '`';
+        $fields = '`'.implode('`, `', array_keys($multi ? $line[0] : $line)).'`';
 
         $values = ':'.implode(', :', array_keys($multi ? $line[0] : $line));
         $rows = $multi ? $line : [$line];
@@ -290,10 +290,10 @@ 
         $keys = [];
 
         foreach ($params AS $key => $val) {
-            $keys[] = '`' . $key . '`="' . $val . '""';
+            $keys[] = '`'.$key.'`="'.$val.'""';
         }
 
-        $sth = $this->conn->prepare('SELECT * FROM ' . $table . ' WHERE ' . implode(' AND ', $keys) . ' LIMIT 1;');
+        $sth = $this->conn->prepare('SELECT * FROM '.$table.' WHERE '.implode(' AND ', $keys).' LIMIT 1;');
         /** @noinspection PdoApiUsageInspection */
         $sth->execute();