firehed / simpledb
0.0.2
2018-02-19 22:45 UTC
Requires (Dev)
- phpstan/phpstan: ^0.9.2
- phpunit/phpunit: ^7.0
- squizlabs/php_codesniffer: ^3.2
This package is auto-updated.
Last update: 2024-10-29 05:16:32 UTC
README
A very simple PDO wrapper
Detailed documentation is coming Soon™.
API
Firehed\SimpleDb\SimpleDb
public function __construct(PDO $pdo)
Constructor
public function select(string $query, array $params = []): Generator
Pass in any SELECT query, with colon-prefixed :placeholder
s.
For each of those placeholders, ensure $params
has a matching key, including the colon.
The value can be any scalar type, or an array of scalar types which will automatically be expanded when matched with an IN()
clause.
Automatic IN
support was the primary motivation behind this library.
public function selectOne(string $query, array $params = []): array
Same as above, but you get either the first row directly or a NoResultError
will be thrown.
Nice for primary/unique key SELECT
s.