@@ -151,7 +151,7 @@ discard block |
||
151 | 151 | |
152 | 152 | $PDO = new PDO("sqlite:" . $this->SqliteDir . '/' . self::INDEXING_FILE); |
153 | 153 | $PDO->setAttribute(PDO::ATTR_ERRMODE, |
154 | - PDO::ERRMODE_EXCEPTION); |
|
154 | + PDO::ERRMODE_EXCEPTION); |
|
155 | 155 | |
156 | 156 | if ($createTable == true) { |
157 | 157 | $this->initIndexing($PDO); |
@@ -186,7 +186,7 @@ discard block |
||
186 | 186 | // look for keyword |
187 | 187 | $stm = $this->indexing->prepare("SELECT * FROM `balancing` WHERE `keyword`=:keyword LIMIT 1"); |
188 | 188 | $stm->execute([ |
189 | - ':keyword' => $keyword, |
|
189 | + ':keyword' => $keyword, |
|
190 | 190 | ]); |
191 | 191 | $row = $stm->fetch(PDO::FETCH_ASSOC); |
192 | 192 | if (isset($row[ 'db' ]) && $row[ 'db' ] != '') { |
@@ -198,8 +198,8 @@ discard block |
||
198 | 198 | $db = $this->currentDB; |
199 | 199 | $stm = $this->indexing->prepare("INSERT INTO `balancing` (`keyword`,`db`) VALUES(:keyword, :db)"); |
200 | 200 | $stm->execute([ |
201 | - ':keyword' => $keyword, |
|
202 | - ':db' => $db, |
|
201 | + ':keyword' => $keyword, |
|
202 | + ':db' => $db, |
|
203 | 203 | ]); |
204 | 204 | } |
205 | 205 | |
@@ -271,22 +271,22 @@ discard block |
||
271 | 271 | $sql = "INSERT OR REPLACE INTO `caching` (`keyword`,`object`,`exp`) values(:keyword,:object,:exp)"; |
272 | 272 | try { |
273 | 273 | $stm = $this->getDb($item->getKey()) |
274 | - ->prepare($sql); |
|
274 | + ->prepare($sql); |
|
275 | 275 | $stm->execute([ |
276 | - ':keyword' => $item->getKey(), |
|
277 | - ':object' => $this->encode($this->driverPreWrap($item)), |
|
278 | - ':exp' => $item->getExpirationDate()->getTimestamp(), |
|
276 | + ':keyword' => $item->getKey(), |
|
277 | + ':object' => $this->encode($this->driverPreWrap($item)), |
|
278 | + ':exp' => $item->getExpirationDate()->getTimestamp(), |
|
279 | 279 | ]); |
280 | 280 | |
281 | 281 | return true; |
282 | 282 | } catch (\PDOException $e) { |
283 | 283 | try { |
284 | 284 | $stm = $this->getDb($item->getKey(), true) |
285 | - ->prepare($sql); |
|
285 | + ->prepare($sql); |
|
286 | 286 | $stm->execute([ |
287 | - ':keyword' => $item->getKey(), |
|
288 | - ':object' => $this->encode($this->driverPreWrap($item)), |
|
289 | - ':exp' => $item->getExpirationDate()->getTimestamp(), |
|
287 | + ':keyword' => $item->getKey(), |
|
288 | + ':object' => $this->encode($this->driverPreWrap($item)), |
|
289 | + ':exp' => $item->getExpirationDate()->getTimestamp(), |
|
290 | 290 | ]); |
291 | 291 | } catch (PDOException $e) { |
292 | 292 | return false; |
@@ -309,17 +309,17 @@ discard block |
||
309 | 309 | $sql = "SELECT * FROM `caching` WHERE `keyword`=:keyword LIMIT 1"; |
310 | 310 | try { |
311 | 311 | $stm = $this->getDb($item->getKey()) |
312 | - ->prepare($sql); |
|
312 | + ->prepare($sql); |
|
313 | 313 | $stm->execute([ |
314 | - ':keyword' => $item->getKey(), |
|
314 | + ':keyword' => $item->getKey(), |
|
315 | 315 | ]); |
316 | 316 | $row = $stm->fetch(PDO::FETCH_ASSOC); |
317 | 317 | } catch (PDOException $e) { |
318 | 318 | try { |
319 | 319 | $stm = $this->getDb($item->getKey(), true) |
320 | - ->prepare($sql); |
|
320 | + ->prepare($sql); |
|
321 | 321 | $stm->execute([ |
322 | - ':keyword' => $item->getKey(), |
|
322 | + ':keyword' => $item->getKey(), |
|
323 | 323 | ]); |
324 | 324 | $row = $stm->fetch(PDO::FETCH_ASSOC); |
325 | 325 | } catch (PDOException $e) { |
@@ -347,11 +347,11 @@ discard block |
||
347 | 347 | if ($item instanceof Item) { |
348 | 348 | try { |
349 | 349 | $stm = $this->getDb($item->getKey()) |
350 | - ->prepare("DELETE FROM `caching` WHERE (`exp` <= :U) OR (`keyword`=:keyword) "); |
|
350 | + ->prepare("DELETE FROM `caching` WHERE (`exp` <= :U) OR (`keyword`=:keyword) "); |
|
351 | 351 | |
352 | 352 | return $stm->execute([ |
353 | - ':keyword' => $item->getKey(), |
|
354 | - ':U' => time(), |
|
353 | + ':keyword' => $item->getKey(), |
|
354 | + ':U' => time(), |
|
355 | 355 | ]); |
356 | 356 | } catch (PDOException $e) { |
357 | 357 | return false; |