PHPackages ruhulfbr/csvqry - 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/csvqry ActiveLibrary[Database & ORM](/categories/database) ruhulfbr/csvqry =============== Make data retrieval query on CSV like laravel `Query Builder` v1.0.3(1y ago)19MITPHPPHP ^8.0 Since May 7Pushed 1y ago1 watchersCompare [ Source](https://github.com/ruhulfbr/csvqry)[ Packagist](https://packagist.org/packages/ruhulfbr/csvqry)[ RSS](/packages/ruhulfbr-csvqry/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (4)Dependencies (1)Versions (5)Used By (0) Query on CSV ============ [](#query-on-csv) **Query on CSV** allows you to perform queries on CSV. 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/csvqry ``` Basic Usage ----------- [](#basic-usage) To instantiate the CSVQ do the following: ``` require_once 'vendor/autoload.php'; use Ruhul\CSVQuery\CSVQ; try { $result = CSVQ::from("example.csv") ->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 csv: ``` $result = CSVQ::from("example.csv") ->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 = CSVQ::from("example.csv")->all(); // To Get All Sorted Result $result = CSVQ::from("example.csv")->orderBy('id', 'desc')->all(); // To Get Specific Row $result = CSVQ::from("example.csv")->where('id', 1)->row(); // To Get First Result $result = CSVQ::from("example.csv")->where('id', 1)->first(); // To Get Last Result $result = CSVQ::from("example.csv")->where('id', 1)->last(); // To Get nth row $result = CSVQ::from("example.csv")->getNth(2); // [0-n] // Check Is row exist $result = CSVQ::from("example.csv")->where('id', 1)->hasData(); // boolean $result = CSVQ::from("example.csv")->where('id', 1)->doesExist(); // boolean // To Get All Sorted Result $result = CSVQ::from("example.csv")->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 = CSVQ::from("example.csv")->count(); // To Get Sum $result = CSVQ::from("example.csv")->sum('age'); // To Get Average $result = CSVQ::from("example.csv")->avg('age'); // To Get row with minimum column value $result = CSVQ::from("example.csv")->min('age'); // To Get row with maximum column value $result = CSVQ::from("example.csv")->max('age'); ``` Support ------- [](#support) If you found an issue or had an idea please refer [to this section](https://github.com/ruhulfbr/csvqry/issues). Authors ------- [](#authors) - **Md Ruhul Amin** - [Github](https://github.com/ruhulfbr) ### Health Score 25 — LowBetter than 37% of packages Maintenance31 Infrequent updates — may be unmaintained Popularity6 Limited adoption so far Community7 Small or concentrated contributor base Maturity49 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 Every ~1 days Total 4 Last Release 729d 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 (15 commits)") --- Tags phpjsoncomposerarraypackagedatasqlcsvconversionqueryphp8jsonqrowcsvqryarrayqcsvq ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/ruhulfbr-csvqry/health.svg) ``` [![Health](https://phpackages.com/badges/ruhulfbr-csvqry/health.svg)](https://phpackages.com/packages/ruhulfbr-csvqry) ``` ### 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)