@@ -23,16 +23,16 @@ |
||
| 23 | 23 | } |
| 24 | 24 | |
| 25 | 25 | public function buildQueryStrSingleFromArr($row = array()){ |
| 26 | - $ar = []; |
|
| 27 | - $query = "UPDATE ".$this->table." SET "; |
|
| 28 | - foreach($row as $key => $val){ |
|
| 29 | - $ar[':'.$key] = $val; |
|
| 30 | - if($key == 'id') continue; |
|
| 31 | - $query.= $this->qb->quote($key)." =:".$key.","; |
|
| 32 | - } |
|
| 33 | - $query = rtrim($query, ","); |
|
| 26 | + $ar = []; |
|
| 27 | + $query = "UPDATE ".$this->table." SET "; |
|
| 28 | + foreach($row as $key => $val){ |
|
| 29 | + $ar[':'.$key] = $val; |
|
| 30 | + if($key == 'id') continue; |
|
| 31 | + $query.= $this->qb->quote($key)." =:".$key.","; |
|
| 32 | + } |
|
| 33 | + $query = rtrim($query, ","); |
|
| 34 | 34 | |
| 35 | - return ['ar' => $ar, 'query' => $query]; |
|
| 35 | + return ['ar' => $ar, 'query' => $query]; |
|
| 36 | 36 | } |
| 37 | 37 | public function createQuery($row){ |
| 38 | 38 | $ar = []; |
@@ -27,7 +27,9 @@ |
||
| 27 | 27 | $query = "UPDATE ".$this->table." SET "; |
| 28 | 28 | foreach($row as $key => $val){ |
| 29 | 29 | $ar[':'.$key] = $val; |
| 30 | - if($key == 'id') continue; |
|
| 30 | + if($key == 'id') { |
|
| 31 | + continue; |
|
| 32 | + } |
|
| 31 | 33 | $query.= $this->qb->quote($key)." =:".$key.","; |
| 32 | 34 | } |
| 33 | 35 | $query = rtrim($query, ","); |