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 +15 added lines, -15 removed lines

@@ -91,7 +91,7 @@ 
      */
     public function addOrCondition()
     {
-        $this->_conditions[] = '('.implode(' or ', func_get_args()).')';
+        $this->_conditions[] = '(' . implode(' or ', func_get_args()) . ')';
 
         return $this;
     }
@@ -141,11 +141,11 @@ 
         }
         $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;
         }
         $group = null;
         if (count($this->_group_fields) > 0) {
-            $group = ' group by '.implode(', ', $this->_group_fields).' ';
+            $group = ' group by ' . implode(', ', $this->_group_fields) . ' ';
         }
         $order = null;
         if (count($this->_order_fields) > 0) {
@@ -157,20 +157,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%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);
+        $string = sprintf('select %1$s from %2$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);
 
         return $string;
     }
@@ -179,10 +179,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];
@@ -192,9 +192,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;
@@ -203,12 +203,12 @@ 
     public function insert()
     {
         $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];
@@ -222,10 +222,10 @@ 
     public function delete()
     {
         $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);