Download the PHP package adnanmula/criteria without Composer
On this page you can find all versions of the php package adnanmula/criteria. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Please rate this library. Is it a good library?
Informations about the package criteria
Criteria
A powerful PHP library for building dynamic database queries with a fluent interface, specifically optimized for PostgreSQL.
Table of Contents
- Requirements
- Installation
- Usage
- Creating a Criteria Object
- Using with Doctrine DBAL
- Filter Operators
- Filter Fields
- Filter Values
- License
Requirements
- PHP 8.4 or higher
- Doctrine DBAL 3.5 or higher
Installation
Install via Composer:
Usage
Creating a Criteria Object
The Criteria class is the main entry point for building queries:
Using with Doctrine DBAL
The library integrates with Doctrine DBAL's QueryBuilder:
Filter Operators
The library supports various filter operators:
- Comparison:
EQUAL,NOT_EQUAL,GREATER,GREATER_OR_EQUAL,LESS,LESS_OR_EQUAL - Text search:
CONTAINS,NOT_CONTAINS,CONTAINS_INSENSITIVE,NOT_CONTAINS_INSENSITIVE - Collection:
IN,NOT_IN - Null checks:
IS_NULL,IS_NOT_NULL - JSON array operations:
IN_ARRAY,NOT_IN_ARRAY
Filter Fields
FilterField: Standard field for most column typesJsonKeyFilterField: For accessing JSON/JSONB fields with specific keys
Filter Values
Value types for different data types:
StringFilterValue: For string valuesIntFilterValue: For integer valuesStringArrayFilterValue: For arrays of strings (used with IN and NOT_IN operators)IntArrayFilterValue: For arrays of integers (used with IN and NOT_IN operators)ArrayElementFilterValue: For JSON array operationsNullFilterValue: For NULL checks
License
This project is licensed under the MIT License - see the LICENSE file for details.
All versions of criteria with dependencies
PHP Build Version
Package Version
The package adnanmula/criteria contains the following files
Loading the files please wait ...