@@ 36-50 (lines=15) @@ | ||
33 | * @param LoggerInterface $logger Optional: PSR-3 Logger |
|
34 | * @param string $table Optional: Custom table name, default: `auth_logins` |
|
35 | */ |
|
36 | public function __construct( \PDO $pdo, LoggerInterface $logger = null, $table = null ) |
|
37 | { |
|
38 | ||
39 | $this->table = $table ?: $this->table; |
|
40 | $this->logger = $logger ?: new NullLogger; |
|
41 | ||
42 | ||
43 | // ------------------------------------------ |
|
44 | // 1. Prepare statement |
|
45 | // ------------------------------------------ |
|
46 | $sql = "DELETE FROM {$this->table} |
|
47 | WHERE user_id = :user_id"; |
|
48 | ||
49 | $this->stmt = $pdo->prepare($sql); |
|
50 | } |
|
51 | ||
52 | ||
53 | /** |
@@ 41-56 (lines=16) @@ | ||
38 | * @param LoggerInterface|null $logger Optional: PSR-3 Logger |
|
39 | * @param string $table Optional: Custom table name, default: `auth_logins` |
|
40 | */ |
|
41 | public function __construct( \PDO $pdo, Callable $verifier, LoggerInterface $logger = null, $table = null) |
|
42 | { |
|
43 | $this->verifier = $verifier; |
|
44 | $this->logger = $logger; |
|
45 | $this->table = $table ?: $this->table; |
|
46 | ||
47 | $sql = "SELECT |
|
48 | user_id, |
|
49 | token_hash |
|
50 | FROM {$this->table} |
|
51 | WHERE selector = :selector |
|
52 | AND valid_until >= NOW() |
|
53 | LIMIT 1"; |
|
54 | ||
55 | $this->stmt = $pdo->prepare( $sql ); |
|
56 | } |
|
57 | ||
58 | ||
59 | /** |