PHPackages kalmanolah/php-query-filters - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Utility & Helpers](/categories/utility) 4. / 5. kalmanolah/php-query-filters AbandonedArchivedLibrary[Utility & Helpers](/categories/utility) kalmanolah/php-query-filters ============================ Utilities for easing query filtering by arbitrary criteria. 127PHP Since Oct 10Pushed 9y ago1 watchersCompare [ Source](https://github.com/kalmanolah/php-query-filters)[ Packagist](https://packagist.org/packages/kalmanolah/php-query-filters)[ RSS](/packages/kalmanolah-php-query-filters/feed)WikiDiscussions master Synced 1mo ago READMEChangelogDependenciesVersions (1)Used By (0) php-query-filters ================= [](#php-query-filters) php-query-filters is a library containing tools which allow for easy filtering of queries. This is useful for people trying to create REST APIs which should allow users to filter data by arbitrary criteria. Currently supported are: - Abstract: - Float transformer - Integer transformer - Doctrine ORM QueryBuilder-based queries: - Automatic joins - GT/GTE filters - LT/LTE filters - EQ/NE filters - NULL/NOT NULL filters - LIKE filters - OR filters - DateTime transformer - MongoDB array-based queries: - GT/GTE filters - LT/LTE filters - EQ/NE filters - NULL/NOT NULL filters - LIKE filters (with $regex) - GEONEAR filters (point + radius) - OR filters (with $or) - MongoId transformer - MongoDate transformer Installing ---------- [](#installing) Include the library in your project with composer: ``` $ composer require kalmanolah/php-query-filters ``` Usage ----- [](#usage) Filtering Doctrine ORM QueryBuilder queries: ``` use KalmanOlah\QueryFilter\FilterSet; use KalmanOlah\QueryFilter\Transformer as Transformer; use KalmanOlah\QueryFilter\Doctrine\ORM\Filter as DoctrineORMFilter; use KalmanOlah\QueryFilter\Doctrine\ORM\Transformer as DoctrineORMTransformer; // Initialize the filter set $filterSet = (new FilterSet()) // Register filters ->registerFilter(new DoctrineORMFilter\EqualsFilter()) ->registerFilter(new DoctrineORMFilter\NotEqualsFilter()) ->registerFilter(new DoctrineORMFilter\LikeFilter()) ->registerFilter(new DoctrineORMFilter\FalseFilter()) ->registerFilter(new DoctrineORMFilter\TrueFilter()) ->registerFilter(new DoctrineORMFilter\GreaterThanFilter()) ->registerFilter(new DoctrineORMFilter\GreaterThanOrEqualToFilter()) ->registerFilter(new DoctrineORMFilter\LessThanFilter()) ->registerFilter(new DoctrineORMFilter\LessThanOrEqualToFilter()) ->registerFilter(new DoctrineORMFilter\NullFilter()) ->registerFilter(new DoctrineORMFilter\NotNullFilter()) ->registerFilter(new DoctrineORMFilter\OrFilter()) // Register transformers ->registerTransformer(new Transformer\FloatTransformer()) ->registerTransformer(new Transformer\IntegerTransformer()) ->registerTransformer(new DoctrineORMTransformer\DateTimeTransformer()); // Create a query $qb = $entityManager->createQueryBuilder() ->select('u') ->from('MyLibrary:User', 'u'); // Get some filters from somewhere (generally your REST API GET params) // eg: GET /api/users?filter[]=foo,bar&filter[]=bar,baz $filters = [ '*,or 1,2,3', // Wrap filters with index 1, 2 and 3 in OR statement 'profile.firstName,eq John', // LEFT JOIN u.profile p, WHERE p.firstName = 'John' 'username,like adm', // WHERE u.username LIKE '%adm%' 'enabled,true', // WHERE u.enabled = TRUE 'lastLogin,gte:dt 2015-03-03', // WHERE u.lastLogin >= '2016-03-03 00:00:00' 'karma,lt:f 3.6', // WHERE u.karma < 3.6 ]; // Apply filters to the query $filterSet->applyQueryFilters($qb, $filters); // Get the query result as you normally would $result = $qb->getQuery()->getResult(); ``` Filtering MongoDB array queries: ``` use KalmanOlah\QueryFilter\FilterSet; use KalmanOlah\QueryFilter\Transformer as Transformer; use KalmanOlah\QueryFilter\MongoDB\Filter as MongoDBFilter; use KalmanOlah\QueryFilter\MongoDB\Transformer as MongoDBTransformer; // Initialize the filter set $filterSet = (new FilterSet()) // Register filters ->registerFilter(new MongoDBFilter\EqualsFilter()) ->registerFilter(new MongoDBFilter\NotEqualsFilter()) ->registerFilter(new MongoDBFilter\LikeFilter()) ->registerFilter(new MongoDBFilter\FalseFilter()) ->registerFilter(new MongoDBFilter\TrueFilter()) ->registerFilter(new MongoDBFilter\GreaterThanFilter()) ->registerFilter(new MongoDBFilter\GreaterThanOrEqualToFilter()) ->registerFilter(new MongoDBFilter\LessThanFilter()) ->registerFilter(new MongoDBFilter\LessThanOrEqualToFilter()) ->registerFilter(new MongoDBFilter\NullFilter()) ->registerFilter(new MongoDBFilter\NotNullFilter()) ->registerFilter(new MongoDBFilter\GeoNearFilter()) ->registerFilter(new MongoDBFilter\OrFilter()) // Register transformers ->registerTransformer(new Transformer\FloatTransformer()) ->registerTransformer(new Transformer\IntegerTransformer()) ->registerTransformer(new MongoDBTransformer\MongoIdTransformer()) ->registerTransformer(new MongoDBTransformer\MongoDateTransformer()); // Create a query (Note: the $and key is currently required) $query = [ '$and' => [], ]; // Get some filters from somewhere (generally your REST API GET params) // eg: GET /api/users?filter[]=foo,bar&filter[]=bar,baz $filters = [ '*,or 1,2,3', // Wrap filters with index 1, 2 and 3 in OR statement 'profile.firstName,eq John', // ['profile.firstName' => ['$eq' => 'John']] 'username,like adm', // ['username' => ['$regex' => /adm/i]] 'enabled,true', // ['enabled' => ['$eq' => true]] 'lastLogin,gte:dt 2015-03-03', // ['lastLogin' => ['$gte' => ISODate('2015-03-03T00:00:00Z')]] 'id,ne:id 123412341234123412341234', // ['id' => ['$ne' => ObjectId('123412341234')]] 'karma,lt:f 3.6', // ['karma' => ['$lt' => 3.6]] 'location,geo_near 4.4500,51.1333,300', // ['location' => ['$near' => ...]] ]; // Apply filters to the query $filterSet->applyQueryFilters($query, $filters); // Get the query result as you normally would $mongo = new MongoDB\Client("mongodb://localhost:27017"); $result = $mongo->mydb->user->find($query); ``` Testing ------- [](#testing) Run the tests after you've ran a composer install: ``` $ ./scripts/run_tests ``` License ------- [](#license) See [LICENSE](LICENSE) ### Health Score 21 — LowBetter than 19% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity9 Limited adoption so far Community7 Small or concentrated contributor base Maturity41 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Community Maintainers ![](https://www.gravatar.com/avatar/53788c71dda78e08e20ca386cfd582e55a21ab113b646d645c37db1b5244a44e?d=identicon)[kalmanolah](/maintainers/kalmanolah) --- Top Contributors [![kalmanolah](https://avatars.githubusercontent.com/u/1028495?v=4)](https://github.com/kalmanolah "kalmanolah (6 commits)") ### Embed Badge ![Health badge](/badges/kalmanolah-php-query-filters/health.svg) ``` [![Health](https://phpackages.com/badges/kalmanolah-php-query-filters/health.svg)](https://phpackages.com/packages/kalmanolah-php-query-filters) ``` ### Alternatives [barracudanetworks/forkdaemon-php A library to make setup and management of forking daemons in PHP easy. 3863.8k2](/packages/barracudanetworks-forkdaemon-php) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)