@@ -21,12 +21,12 @@ |
||
21 | 21 | trait SqlTrait |
22 | 22 | { |
23 | 23 | /** |
24 | - * Fetch data from filter table. |
|
25 | - * |
|
26 | - * @param string $ip An IP address. |
|
27 | - * |
|
28 | - * @return array |
|
29 | - */ |
|
24 | + * Fetch data from filter table. |
|
25 | + * |
|
26 | + * @param string $ip An IP address. |
|
27 | + * |
|
28 | + * @return array |
|
29 | + */ |
|
30 | 30 | protected function doFetchFromFilterTable(string $ip): array |
31 | 31 | { |
32 | 32 | $results = []; |
@@ -234,14 +234,14 @@ discard block |
||
234 | 234 | protected function update(string $table, array $data, array $where) |
235 | 235 | { |
236 | 236 | $placeholder = []; |
237 | - foreach($data as $k => $v) { |
|
237 | + foreach ($data as $k => $v) { |
|
238 | 238 | $placeholder[] = "$k = :$k"; |
239 | 239 | } |
240 | 240 | |
241 | 241 | $dataPlaceholder = implode(', ', $placeholder); |
242 | 242 | |
243 | 243 | $placeholder = []; |
244 | - foreach($where as $k => $v) { |
|
244 | + foreach ($where as $k => $v) { |
|
245 | 245 | $placeholder[] = "$k = :$k"; |
246 | 246 | } |
247 | 247 | |
@@ -253,7 +253,7 @@ discard block |
||
253 | 253 | |
254 | 254 | $bind = array_merge($data, $where); |
255 | 255 | |
256 | - foreach($bind as $k => $v) { |
|
256 | + foreach ($bind as $k => $v) { |
|
257 | 257 | |
258 | 258 | // @codeCoverageIgnoreStart |
259 | 259 | |
@@ -281,7 +281,7 @@ discard block |
||
281 | 281 | |
282 | 282 | // @codeCoverageIgnoreStart |
283 | 283 | |
284 | - } catch(Exception $e) { |
|
284 | + } catch (Exception $e) { |
|
285 | 285 | throw $e->getMessage(); |
286 | 286 | } |
287 | 287 | |
@@ -301,7 +301,7 @@ discard block |
||
301 | 301 | { |
302 | 302 | $placeholderField = []; |
303 | 303 | $placeholderValue = []; |
304 | - foreach($data as $k => $v) { |
|
304 | + foreach ($data as $k => $v) { |
|
305 | 305 | $placeholderField[] = "`$k`"; |
306 | 306 | $placeholderValue[] = ":$k"; |
307 | 307 | } |
@@ -313,7 +313,7 @@ discard block |
||
313 | 313 | $sql = 'INSERT INTO ' . $table . ' (' . $dataPlaceholderField . ') VALUES (' . $dataPlaceholderValue . ')'; |
314 | 314 | $query = $this->db->prepare($sql); |
315 | 315 | |
316 | - foreach($data as $k => $v) { |
|
316 | + foreach ($data as $k => $v) { |
|
317 | 317 | |
318 | 318 | // @codeCoverageIgnoreStart |
319 | 319 | |
@@ -341,7 +341,7 @@ discard block |
||
341 | 341 | |
342 | 342 | // @codeCoverageIgnoreStart |
343 | 343 | |
344 | - } catch(Exception $e) { |
|
344 | + } catch (Exception $e) { |
|
345 | 345 | return false; |
346 | 346 | } |
347 | 347 | |
@@ -360,7 +360,7 @@ discard block |
||
360 | 360 | { |
361 | 361 | |
362 | 362 | $placeholder = []; |
363 | - foreach($where as $k => $v) { |
|
363 | + foreach ($where as $k => $v) { |
|
364 | 364 | $placeholder[] = "`$k` = :$k"; |
365 | 365 | } |
366 | 366 | |
@@ -371,7 +371,7 @@ discard block |
||
371 | 371 | $sql = 'DELETE FROM ' . $table . ' WHERE ' . $dataPlaceholder; |
372 | 372 | $query = $this->db->prepare($sql); |
373 | 373 | |
374 | - foreach($where as $k => $v) { |
|
374 | + foreach ($where as $k => $v) { |
|
375 | 375 | |
376 | 376 | // @codeCoverageIgnoreStart |
377 | 377 | |
@@ -394,7 +394,7 @@ discard block |
||
394 | 394 | |
395 | 395 | // @codeCoverageIgnoreStart |
396 | 396 | |
397 | - } catch(Exception $e) { |
|
397 | + } catch (Exception $e) { |
|
398 | 398 | return false; |
399 | 399 | } |
400 | 400 |