@@ -20,11 +20,11 @@ discard block |
||
20 | 20 | //For dates with times set, search on time, if the time is not set, search on date only. |
21 | 21 | //E.g. searching for all records posted on '2015-11-14' should return all records that day, not just the ones posted at 00:00:00 on that day |
22 | 22 | if ($value instanceof \DateTimeInterface) { |
23 | - if ($value->format('H:i:s') == '00:00:00') $value = $value->format('Y-m-d'); |
|
23 | + if ($value->format('H:i:s') == '00:00:00') $value = $value->format('Y-m-d'); |
|
24 | 24 | else $value = $value->format('Y-m-d H:i:s'); |
25 | 25 | } |
26 | 26 | if (is_object($value)) continue; |
27 | - if ($prependField){ |
|
27 | + if ($prependField) { |
|
28 | 28 | $sql[] = $this->quote($field) . ' = :' . $field; |
29 | 29 | } else { |
30 | 30 | $sql[] = ':' . $field; |
@@ -36,13 +36,13 @@ discard block |
||
36 | 36 | |
37 | 37 | public function insert($table, $data) { |
38 | 38 | $query = $this->buildSaveQuery($data); |
39 | - return new Query('INSERT INTO ' . $this->quote($table) . ' (' .implode(', ', array_keys($query['args'])).') VALUES ( ' . implode(', ', $query['sql']). ' )', $query['args']); |
|
39 | + return new Query('INSERT INTO ' . $this->quote($table) . ' (' . implode(', ', array_keys($query['args'])) . ') VALUES ( ' . implode(', ', $query['sql']) . ' )', $query['args']); |
|
40 | 40 | } |
41 | 41 | |
42 | 42 | public function update($table, array $primaryKey, $data) { |
43 | 43 | $query = $this->buildSaveQuery($data, true); |
44 | 44 | $where = []; |
45 | - foreach($primaryKey as $field) $where[] = $this->quote($field) . ' = :' . $field; |
|
46 | - return new Query('UPDATE ' . $this->quote($table) . ' SET ' . implode(', ', $query['sql']). ' WHERE '. implode(' AND ', $where), $query['args']); |
|
45 | + foreach ($primaryKey as $field) $where[] = $this->quote($field) . ' = :' . $field; |
|
46 | + return new Query('UPDATE ' . $this->quote($table) . ' SET ' . implode(', ', $query['sql']) . ' WHERE ' . implode(' AND ', $where), $query['args']); |
|
47 | 47 | } |
48 | 48 | } |