@@ -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 | } |