@@ -57,10 +57,10 @@ discard block |
||
| 57 | 57 | public function __construct($dbPath) |
| 58 | 58 | { |
| 59 | 59 | if (!file_exists($dbPath) || !is_readable($dbPath)) { |
| 60 | - throw new \Exception("Database with path '" . $dbPath ."' doesn't exist or isn't readable!"); |
|
| 60 | + throw new \Exception("Database with path '".$dbPath."' doesn't exist or isn't readable!"); |
|
| 61 | 61 | } |
| 62 | 62 | |
| 63 | - $this->db = new \PDO('sqlite:' . $dbPath); |
|
| 63 | + $this->db = new \PDO('sqlite:'.$dbPath); |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | /** |
@@ -281,7 +281,7 @@ discard block |
||
| 281 | 281 | return false; |
| 282 | 282 | } |
| 283 | 283 | |
| 284 | - $q = "UPDATE `" . $thisTable . "` SET rating=? WHERE id=?"; |
|
| 284 | + $q = "UPDATE `".$thisTable."` SET rating=? WHERE id=?"; |
|
| 285 | 285 | |
| 286 | 286 | $res = $this->db->prepare($q); |
| 287 | 287 | $ret = $res->execute(array( |
@@ -322,10 +322,10 @@ discard block |
||
| 322 | 322 | } |
| 323 | 323 | |
| 324 | 324 | if (!is_null($objectId)) { |
| 325 | - $query = 'SELECT * FROM `' . $tableName . '` WHERE id=?'; |
|
| 325 | + $query = 'SELECT * FROM `'.$tableName.'` WHERE id=?'; |
|
| 326 | 326 | $params = [$objectId]; |
| 327 | 327 | } else { |
| 328 | - $query = 'SELECT * FROM ' . $tableName; |
|
| 328 | + $query = 'SELECT * FROM '.$tableName; |
|
| 329 | 329 | $params = []; |
| 330 | 330 | } |
| 331 | 331 | |
@@ -560,13 +560,13 @@ discard block |
||
| 560 | 560 | if ($field != null && $field != null) { |
| 561 | 561 | $q = " |
| 562 | 562 | SELECT id, 'video' as type FROM VideoTable |
| 563 | - WHERE `" . $field . "` LIKE ? |
|
| 563 | + WHERE `" . $field."` LIKE ? |
|
| 564 | 564 | UNION ALL |
| 565 | 565 | SELECT id, 'photo' FROM PhotoTable |
| 566 | - WHERE `" . $field . "` LIKE ?"; |
|
| 566 | + WHERE `" . $field."` LIKE ?"; |
|
| 567 | 567 | |
| 568 | 568 | $res = $this->db->prepare($q); |
| 569 | - $res->execute(['%' . $value . '%', '%' . $value . '%']); |
|
| 569 | + $res->execute(['%'.$value.'%', '%'.$value.'%']); |
|
| 570 | 570 | } else { |
| 571 | 571 | $q = " |
| 572 | 572 | SELECT id, 'video' as type FROM VideoTable |