PHPackages ruhulfbr/array-qry - 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. [Database & ORM](/categories/database) 4. / 5. ruhulfbr/array-qry ActiveLibrary[Database & ORM](/categories/database) ruhulfbr/array-qry ================== Make data retrieval query on `Array` like laravel Query Builder v1.0.0(2y ago)07MITPHPPHP ^8.0 Since May 10Pushed 2y ago1 watchersCompare [ Source](https://github.com/ruhulfbr/array-qry)[ Packagist](https://packagist.org/packages/ruhulfbr/array-qry)[ RSS](/packages/ruhulfbr-array-qry/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (1)Dependencies (1)Versions (2)Used By (0) Query on Array ============== [](#query-on-array) **Query on Array** allows you to perform queries on Array. Use Cases --------- [](#use-cases) This package is suitable for you if you need to perform some queries on: - Perform SELECT query - Perform where query (where, orWhere, whereIn, whereDate e.t.c) - Perform Sorting - Perform Limit, Offset - Perform Aggregate Query (count, sum, avg, max, min) Installation ------------ [](#installation) To install the package, you can use [Composer](https://getcomposer.org/): ``` composer require ruhulfbr/array-qry ``` Basic Usage ----------- [](#basic-usage) To instantiate the ArrayQ do the following: ``` require_once 'vendor/autoload.php'; use Ruhul\ArrayQuery\ArrayQ; $array = [ [ 'id' => 1, 'name' => 'John Doe', 'email' => 'john.doe@example.com', 'age' => 25, 'dob' => '1999-05-15', 'company' => [ 'name' => 'ABC Company', 'catchPhrase' => 'Innovative solutions for businesses', 'bs' => 'Transforming industries through technology' ] ], [ 'id' => 2, 'name' => 'Jane Smith', 'email' => 'jane.smith@example.com', 'age' => 30, 'dob' => '1994-08-20', 'company' => [ 'name' => 'XYZ Corporation', 'catchPhrase' => 'Empowering companies to succeed', 'bs' => 'Driving growth and innovation' ] ], [ 'id' => 3, 'name' => 'Alice Johnson', 'email' => 'alice.johnson@example.com', 'age' => 35, 'dob' => '1989-12-10', 'company' => [ 'name' => 'PQR Enterprises', 'catchPhrase' => 'Delivering excellence to clients', 'bs' => 'Building a better future together' ] ] ]; try { $result = ArrayQ::from($array) ->select('id', 'name') ->get(); } catch (\Exception $e) { $result = $e->getMessage(); } pr($result); ``` Querying, sorting and get results --------------------------------- [](#querying-sorting-and-get-results) You can perform queries on your array: ``` $result = ArrayQ::from($array) ->select('id', 'name') //->select(['id', 'name']) ->where('id', 2) //->where('id', '>' ,2) ->orWhere('id', 3) //->orWhere('id', '>=', 3) ->whereDate('dob', '2010-10-10') //->whereDate('dob', '>=','2010-10-10') ->whereLike('name', 'ruhul') //->whereLike('name', 'ruhul', 'start') //->whereLike('name', 'ruhul', 'end') ->whereIn('age', [22,23,25,26]) ->whereNotIn('age', [11,12,13]) ->orderBy('id') //->orderBy('id', 'desc') //->orderBy('id', 'asc') //->latest('id') // Default Id //->oldest('id') // Default Id ->get(); ``` ### More Example [](#more-example) ``` // To Get All Result $result = ArrayQ::from($array)->all(); // To Get All Sorted Result $result = ArrayQ::from($array)->orderBy('id', 'desc')->all(); // To Get Specific Row $result = ArrayQ::from($array)->where('id', 1)->row(); // To Get First Result $result = ArrayQ::from($array)->where('id', 1)->first(); // To Get Last Result $result = ArrayQ::from($array)->where('id', 1)->last(); // To Get nth row $result = ArrayQ::from($array)->getNth(2); // [0-n] // Check Is row exist $result = ArrayQ::from($array)->where('id', 1)->hasData(); // boolean $result = ArrayQ::from($array)->where('id', 1)->doesExist(); // boolean // To Get All Sorted Result $result = ArrayQ::from($array)->orderBy('id', 'desc')->all(); ``` ### Available where operators [](#available-where-operators) - `=` (default operator, can be omitted) - `>` - `select('*') ->orderBy('id') ->limit(10) //->limit(10, 2) ->get(); ``` Aggregator Query ---------------- [](#aggregator-query) You can add criteria and specify limit and offset for your query results: ``` // To Get Count $result = ArrayQ::from($array)->count(); // To Get Sum $result = ArrayQ::from($array)->sum('age'); // To Get Average $result = ArrayQ::from($array)->avg('age'); // To Get row with minimum column value $result = ArrayQ::from($array)->min('age'); // To Get row with maximum column value $result = ArrayQ::from($array)->max('age'); ``` Support ------- [](#support) If you found an issue or had an idea please refer [to this section](https://github.com/ruhulfbr/array-qry/issues). Authors ------- [](#authors) - **Md Ruhul Amin** - [Github](https://github.com/ruhulfbr) ### Health Score 21 — LowBetter than 19% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity4 Limited adoption so far Community7 Small or concentrated contributor base Maturity45 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. ### Release Activity Cadence Unknown Total 1 Last Release 737d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/9600ba7b93d10623dc0519cd11fd5063d3770c06c29f7b54533ac316cbd334a1?d=identicon)[ruhulfbr](/maintainers/ruhulfbr) --- Top Contributors [![ruhulfbr](https://avatars.githubusercontent.com/u/25591435?v=4)](https://github.com/ruhulfbr "ruhulfbr (2 commits)") --- Tags phpjsoncomposerarraypackagedatasqlcsvconversionqueryphp8jsonqrowarray querycsvqryarrayqcsvqarray-qry ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/ruhulfbr-array-qry/health.svg) ``` [![Health](https://phpackages.com/badges/ruhulfbr-array-qry/health.svg)](https://phpackages.com/packages/ruhulfbr-array-qry) ``` ### Alternatives [annexare/countries-list Continents & countries: ISO 3166-1 alpha-2 code, name, ISO 639-1 languages, capital, currency, native name, phone. JSON, CSV and SQL. 1.3k220.8k1](/packages/annexare-countries-list)[izniburak/pdox Useful Query Builder, PDO Class for PHP. A simple access to your SQL records. 30221.1k7](/packages/izniburak-pdox)[archon/dataframe Archon: PHP Data Analysis Library 9824.2k1](/packages/archon-dataframe)[rolfvreijdenberger/izzum-statemachine A superior statemachine library php >= 5.3. Integrates with your domain models perfectly. 7425.5k](/packages/rolfvreijdenberger-izzum-statemachine)[butschster/dbml-parser DBML (database markup language) parser written on PHP8. 6416.8k2](/packages/butschster-dbml-parser)[mammothphp/woollym WoollyM: PHP Data Analysis Library 111.6k](/packages/mammothphp-woollym) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)