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

MIT

• Eric Stern

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 :placeholders. 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 SELECTs.