ahmetertem / query_builder

src/qb.php

Indentation +23 added lines, -23 removed lines

@@ -134,9 +134,9 @@ 
 
     public function getSelect()
     {
-		if(count($this->_table_names) == 0) {
-			throw new exception('Specify at least 1 table name');
-		}
+        if(count($this->_table_names) == 0) {
+            throw new exception('Specify at least 1 table name');
+        }
         $_read_fields = $this->_read_fields;
         if (count($_read_fields) == 0) {
             $_read_fields[] = '*';
@@ -179,22 +179,22 @@ 
 
     public function getUpdate()
     {
-		if(count($this->_table_names) == 0) {
-			throw new exception('Specify at least 1 table name');
-		}
-		if(count($this->_write_fields) == 0) {
-			throw new exception('Specify at least 1 write field (set function)');
-		}
+        if(count($this->_table_names) == 0) {
+            throw new exception('Specify at least 1 table name');
+        }
+        if(count($this->_write_fields) == 0) {
+            throw new exception('Specify at least 1 write field (set function)');
+        }
         $updates = array();
         for ($d = 0, $m = count($this->_write_fields); $d < $m; ++$d) {
             $t = $this->_write_fields[$d].'=';
             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);
@@ -210,12 +210,12 @@ 
 
     public function getInsert()
     {
-		if(count($this->_table_names) == 0) {
-			throw new exception('Specify at least 1 table name');
-		}
-		if(count($this->_write_fields) == 0) {
-			throw new exception('Specify at least 1 write field (set function)');
-		}
+        if(count($this->_table_names) == 0) {
+            throw new exception('Specify at least 1 table name');
+        }
+        if(count($this->_write_fields) == 0) {
+            throw new exception('Specify at least 1 write field (set function)');
+        }
         $table = $this->_table_names[0];
         $fields = '`'.implode('`, `', $this->_write_fields).'`';
         $values = array();
@@ -223,10 +223,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));
 
@@ -235,9 +235,9 @@ 
 
     public function getDelete()
     {
-		if(count($this->_table_names) == 0) {
-			throw new exception('Specify at least 1 table name');
-		}
+        if(count($this->_table_names) == 0) {
+            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;
         $limit = null;

Spacing +21 added lines, -21 removed lines

@@ -90,7 +90,7 @@ 
      */
     public function whereOr()
     {
-        $this->_conditions[] = '('.implode(' or ', func_get_args()).')';
+        $this->_conditions[] = '(' . implode(' or ', func_get_args()) . ')';
 
         return $this;
     }
@@ -134,7 +134,7 @@ 
 
     public function getSelect()
     {
-		if(count($this->_table_names) == 0) {
+		if (count($this->_table_names) == 0) {
 			throw new exception('Specify at least 1 table name');
 		}
         $_read_fields = $this->_read_fields;
@@ -143,11 +143,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) {
@@ -159,38 +159,38 @@ 
                     $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;
     }
 
     public function getUpdate()
     {
-		if(count($this->_table_names) == 0) {
+		if (count($this->_table_names) == 0) {
 			throw new exception('Specify at least 1 table name');
 		}
-		if(count($this->_write_fields) == 0) {
+		if (count($this->_write_fields) == 0) {
 			throw new exception('Specify at least 1 write field (set function)');
 		}
         $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];
@@ -200,9 +200,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;
@@ -210,19 +210,19 @@ 
 
     public function getInsert()
     {
-		if(count($this->_table_names) == 0) {
+		if (count($this->_table_names) == 0) {
 			throw new exception('Specify at least 1 table name');
 		}
-		if(count($this->_write_fields) == 0) {
+		if (count($this->_write_fields) == 0) {
 			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];
@@ -235,14 +235,14 @@ 
 
     public function getDelete()
     {
-		if(count($this->_table_names) == 0) {
+		if (count($this->_table_names) == 0) {
 			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);