ahmetertem / query_builder

src/qb.php

Indentation +5 added lines, -5 removed lines

@@ -169,10 +169,10 @@ 
             switch ($this->_write_field_types[$d]) {
             case 0:
               $t .= "'" . $this->_write_values[$d] . "'";
-              break;
-          default:
+                break;
+            default:
               $t .= $this->_write_values[$d];
-          }
+            }
             $updates[] = $t;
         }
         $update_fields = implode(", ", $updates);
@@ -195,10 +195,10 @@ 
             switch ($this->_write_field_types[$d]) {
             case 0:
               $values[] = "'" . $this->_write_values[$d] . "'";
-              break;
+                break;
             default:
               $values[] = $this->_write_values[$d];
-          }
+            }
         }
         $string = sprintf('insert into %1$s (%2$s) values(%3$s)', $table, $fields, implode(", ", $values));
         return $string;

Spacing +16 added lines, -16 removed lines

@@ -91,7 +91,7 @@ 
      */
     public function whereOr()
     {
-        $this->_conditions[] = '('.implode(' or ', func_get_args()).')';
+        $this->_conditions[] = '(' . implode(' or ', func_get_args()) . ')';
 
         return $this;
     }
@@ -169,7 +169,7 @@ 
         //
         $joins = null;
         foreach ($this->_joins as $join) {
-            $joins .= $join['type'].' JOIN '.$join['table'].' on '.$join['on'].' ';
+            $joins .= $join['type'] . ' JOIN ' . $join['table'] . ' on ' . $join['on'] . ' ';
         }
 
         //
@@ -177,7 +177,7 @@ 
         //
         $limit = null;
         if ($this->limit > 0) {
-            $limit = ' limit '.($this->limit_offset != -1 ? $this->limit_offset.', ' : null).$this->limit;
+            $limit = ' limit ' . ($this->limit_offset != -1 ? $this->limit_offset . ', ' : null) . $this->limit;
         }
 
         //
@@ -185,7 +185,7 @@ 
         //
         $group = null;
         if (count($this->_group_fields) > 0) {
-            $group = ' group by '.implode(', ', $this->_group_fields).' ';
+            $group = ' group by ' . implode(', ', $this->_group_fields) . ' ';
         }
 
         //
@@ -201,20 +201,20 @@ 
                     $pos = strpos($of[0], '.');
                     if ($pos !== false) {
                         $t = explode('.', $of[0]);
-                        $t[1] = '`'.$t[1].'`';
+                        $t[1] = '`' . $t[1] . '`';
                         $of[0] = implode('.', $t);
                         $order .= $of[0];
                     } else {
-                        $order .= '`'.$of[0].'`';
+                        $order .= '`' . $of[0] . '`';
                     }
-                    $order .= ' '.($of[1] ? 'asc' : 'desc');
+                    $order .= ' ' . ($of[1] ? 'asc' : 'desc');
                 } else {
                     $order .= $of[0];
                 }
                 ++$i;
             }
         }
-        $string = sprintf('select %1$s from %2$s%7$s%3$s%6$s%4$s%5$s', implode(', ', $_read_fields), implode(', ', $this->_table_names), count($this->_conditions) > 0 ? (' where '.implode(' and ', $this->_conditions)) : null, $order, $limit, $group, $joins);
+        $string = sprintf('select %1$s from %2$s%7$s%3$s%6$s%4$s%5$s', implode(', ', $_read_fields), implode(', ', $this->_table_names), count($this->_conditions) > 0 ? (' where ' . implode(' and ', $this->_conditions)) : null, $order, $limit, $group, $joins);
 
         return $string;
     }
@@ -229,10 +229,10 @@ 
         }
         $updates = array();
         for ($d = 0, $m = count($this->_write_fields); $d < $m; ++$d) {
-            $t = '`' . $this->_write_fields[$d].'`=';
+            $t = '`' . $this->_write_fields[$d] . '`=';
             switch ($this->_write_field_types[$d]) {
             case 0:
-              $t .= "'".$this->_write_values[$d]."'";
+              $t .= "'" . $this->_write_values[$d] . "'";
               break;
           default:
               $t .= $this->_write_values[$d];
@@ -242,9 +242,9 @@ 
         $update_fields = implode(', ', $updates);
         $limit = null;
         if ($this->limit > 0) {
-            $limit = ' limit '.($this->limit_offset != -1 ? $this->limit_offset.', ' : null).$this->limit;
+            $limit = ' limit ' . ($this->limit_offset != -1 ? $this->limit_offset . ', ' : null) . $this->limit;
         }
-        $where = count($this->_conditions) > 0 ? (' where '.implode(' and ', $this->_conditions)) : null;
+        $where = count($this->_conditions) > 0 ? (' where ' . implode(' and ', $this->_conditions)) : null;
         $string = sprintf('update %1$s set %2$s %3$s %4$s', $this->_table_names[0], $update_fields, $where, $limit);
 
         return $string;
@@ -259,12 +259,12 @@ 
             throw new \Exception('Specify at least 1 write field (set function)');
         }
         $table = $this->_table_names[0];
-        $fields = '`'.implode('`, `', $this->_write_fields).'`';
+        $fields = '`' . implode('`, `', $this->_write_fields) . '`';
         $values = array();
         for ($d = 0, $m = count($this->_write_fields); $d < $m; ++$d) {
             switch ($this->_write_field_types[$d]) {
             case 0:
-              $values[] = "'".$this->_write_values[$d]."'";
+              $values[] = "'" . $this->_write_values[$d] . "'";
               break;
             default:
               $values[] = $this->_write_values[$d];
@@ -281,10 +281,10 @@ 
             throw new \Exception('Specify at least 1 table name');
         }
         $table = $this->_table_names[0];
-        $where = count($this->_conditions) > 0 ? (' where '.implode(' and ', $this->_conditions)) : null;
+        $where = count($this->_conditions) > 0 ? (' where ' . implode(' and ', $this->_conditions)) : null;
         $limit = null;
         if ($this->limit > 0) {
-            $limit = ' limit '.($this->limit_offset != -1 ? $this->limit_offset.', ' : null).$this->limit;
+            $limit = ' limit ' . ($this->limit_offset != -1 ? $this->limit_offset . ', ' : null) . $this->limit;
         }
         $string = sprintf('delete from %1$s %2$s %3$s', $table, $where, $limit);