CruzerSoftwares / Dolphin

src/Dolphin/Save.php

Indentation +9 added lines, -9 removed lines

@@ -23,16 +23,16 @@
     }
 
     public function buildQueryStrSingleFromArr($row = array()){
-      $ar = [];
-      $query = "UPDATE ".$this->table." SET ";
-      foreach($row as $key => $val){
-          $ar[':'.$key] = $val;
-          if($key == 'id') continue;
-          $query.= $this->qb->quote($key)." =:".$key.",";
-      }
-      $query = rtrim($query, ",");
+        $ar = [];
+        $query = "UPDATE ".$this->table." SET ";
+        foreach($row as $key => $val){
+            $ar[':'.$key] = $val;
+            if($key == 'id') continue;
+            $query.= $this->qb->quote($key)." =:".$key.",";
+        }
+        $query = rtrim($query, ",");
 
-      return ['ar' => $ar, 'query' => $query];
+        return ['ar' => $ar, 'query' => $query];
     }
     public function createQuery($row){
         $ar = [];

Spacing +12 added lines, -12 removed lines

@@ -22,33 +22,33 @@ 
         $this->qb = new QueryBuilder();
     }
 
-    public function buildQueryStrSingleFromArr($row = array()){
+    public function buildQueryStrSingleFromArr($row = array()) {
       $ar = [];
       $query = "UPDATE ".$this->table." SET ";
-      foreach($row as $key => $val){
+      foreach ($row as $key => $val) {
           $ar[':'.$key] = $val;
-          if($key == 'id') continue;
-          $query.= $this->qb->quote($key)." =:".$key.",";
+          if ($key == 'id') continue;
+          $query .= $this->qb->quote($key)." =:".$key.",";
       }
       $query = rtrim($query, ",");
 
       return ['ar' => $ar, 'query' => $query];
     }
-    public function createQuery($row){
+    public function createQuery($row) {
         $ar = [];
-        if(isset($row) && isset($row->id) && $row->id > 0 ){
+        if (isset($row) && isset($row->id) && $row->id > 0) {
             $mixedData = $this->buildQueryStrSingleFromArr($row);
-            $query= $mixedData['query']." WHERE ".$this->qb->quote('id')."=:id";
+            $query = $mixedData['query']." WHERE ".$this->qb->quote('id')."=:id";
 
             return ['query' => $query, 'data' => $mixedData['ar']];
         }
 
         $queryVal = '';
         $query = "INSERT INTO ".$this->table." (";
-        foreach($row as $key => $val){
-            $query.= $this->qb->quote($key).", ";
+        foreach ($row as $key => $val) {
+            $query .= $this->qb->quote($key).", ";
             $ar[$key] = $val;
-            $queryVal.= ":".$key.", ";
+            $queryVal .= ":".$key.", ";
         }
 
         $query = rtrim($query, ", ").") VALUES (".$queryVal.rtrim($query, ", ").") ";
@@ -73,10 +73,10 @@ 
 
         list($query, $data) = $this->createQuery($row);
 
-        try{
+        try {
             $stmt = Connection::get()->prepare($this->qb->queryPrefix($query));
             $stmt->execute($data);
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
 

Braces +3 added lines, -1 removed lines

@@ -27,7 +27,9 @@
       $query = "UPDATE ".$this->table." SET ";
       foreach($row as $key => $val){
           $ar[':'.$key] = $val;
-          if($key == 'id') continue;
+          if($key == 'id') {
+              continue;
+          }
           $query.= $this->qb->quote($key)." =:".$key.",";
       }
       $query = rtrim($query, ",");