@@ -7,7 +7,7 @@ |
||
7 | 7 | * |
8 | 8 | */ |
9 | 9 | |
10 | -Class TemplateParser { |
|
10 | +class TemplateParser { |
|
11 | 11 | |
12 | 12 | /** |
13 | 13 | * @param array $config [action, tabs, toArray] |
@@ -225,13 +225,13 @@ discard block |
||
225 | 225 | $orderBy = trim($orderBy); |
226 | 226 | $limit = trim($limit); |
227 | 227 | if ($where !== '' && stripos($where, 'WHERE') !== 0) { |
228 | - $where = "WHERE {$where}"; |
|
228 | + $where = "where {$where}"; |
|
229 | 229 | } |
230 | 230 | if ($orderBy !== '' && stripos($orderBy, 'ORDER BY') !== 0) { |
231 | 231 | $orderBy = "ORDER BY {$orderBy}"; |
232 | 232 | } |
233 | 233 | if ($limit !== '' && stripos($limit, 'LIMIT') !== 0) { |
234 | - $limit = "LIMIT {$limit}"; |
|
234 | + $limit = "limit {$limit}"; |
|
235 | 235 | } |
236 | 236 | |
237 | 237 | $out = $this->query("DELETE FROM {$from} {$where} {$orderBy} {$limit}"); |
@@ -272,16 +272,16 @@ discard block |
||
272 | 272 | $orderBy = trim($orderBy); |
273 | 273 | $limit = trim($limit); |
274 | 274 | if ($where !== '' && stripos($where, 'WHERE') !== 0) { |
275 | - $where = "WHERE {$where}"; |
|
275 | + $where = "where {$where}"; |
|
276 | 276 | } |
277 | 277 | if ($orderBy !== '' && stripos($orderBy, 'ORDER') !== 0) { |
278 | 278 | $orderBy = "ORDER BY {$orderBy}"; |
279 | 279 | } |
280 | 280 | if ($limit !== '' && stripos($limit, 'LIMIT') !== 0) { |
281 | - $limit = "LIMIT {$limit}"; |
|
281 | + $limit = "limit {$limit}"; |
|
282 | 282 | } |
283 | 283 | |
284 | - return $this->query("SELECT {$fields} FROM {$from} {$where} {$orderBy} {$limit}"); |
|
284 | + return $this->query("select {$fields} FROM {$from} {$where} {$orderBy} {$limit}"); |
|
285 | 285 | } |
286 | 286 | |
287 | 287 | /** |
@@ -349,10 +349,10 @@ discard block |
||
349 | 349 | $where = trim($where); |
350 | 350 | $limit = trim($limit); |
351 | 351 | if ($where !== '' && stripos($where, 'WHERE') !== 0) { |
352 | - $where = "WHERE {$where}"; |
|
352 | + $where = "where {$where}"; |
|
353 | 353 | } |
354 | 354 | if ($limit !== '' && stripos($limit, 'LIMIT') !== 0) { |
355 | - $limit = "LIMIT {$limit}"; |
|
355 | + $limit = "limit {$limit}"; |
|
356 | 356 | } |
357 | 357 | $this->query("INSERT INTO {$intotable} {$fields} SELECT {$fromfields} FROM {$fromtable} {$where} {$limit}"); |
358 | 358 | } |