Skip to content

Latest commit

 

History

History
23 lines (17 loc) · 665 Bytes

readme.md

File metadata and controls

23 lines (17 loc) · 665 Bytes
Raw

Doctrine DBAL query filter

Turn a uri query string into SQL search

Usage

$conn = Doctrine\DBAL\DriverManager::getConnection(['driver' => 'pdo_sqlite', 'path' => ':memory:']);
$query = $conn->createQueryBuilder()->from('tbl')->select('*');

parse_str('pid=1&cat[]=games&cat[]=books&updated_at_gte=today', $params);

$filter = (new Codin\DBAL\QueryFilter())
    ->match('pid', 'product_id')
    ->range('updated_at')
    ->contains('cat', 'category')
;
$filter->build($query, $params);

echo $query->getSQL()."\n";
// SELECT * FROM tbl
// WHERE (product_id = :product_id) AND (updated_at >= :updated_at_gte) AND (category in (:category0, :category1))