Download the PHP package lachlanhickey/query-builder-parser without Composer
On this page you can find all versions of the php package lachlanhickey/query-builder-parser. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download lachlanhickey/query-builder-parser
More information about lachlanhickey/query-builder-parser
Files in lachlanhickey/query-builder-parser
Package query-builder-parser
Short Description Build complex Eloquent & QueryBuilder queries automatically when using jQuery-QueryBuilder
License MIT
Homepage http://github.com/timgws/QueryBuilderParser
Informations about the package query-builder-parser
QueryBuilderParser
Status Label | Status Value |
---|---|
Build | |
Insights | |
Code Climate | |
Test Coverage |
QueryBuilderParser is designed mainly to be used inside Laravel projects, however it can be used outside Laravel projects by using Illuminate/Database.
A simple to use query builder for the jQuery QueryBuilder plugin.
Using QueryBuilderParser
Building a new query from QueryBuilder rules.
This query when posted will create the following SQL query:
Getting results from MongoDB
This query when posted will create the following MongoDB query:
Note that to use this you will need to install and configure jenssegers/mongodb
.
Integration examples
Integrating with jQuery Datatables
Mixed with Datatables, jQuery QueryBuilder makes for some true awesome, allowing limitless options for filtering data, and seeing the results on the fly.
On the client side, a little bit of magic is required to make everything work.
Using JoinSupportingQueryBuilderParser
JoinSupportingQueryBuilderParser
is a version of QueryBuilderParser
that supports building even more complex queries.
Which will build an SQL query similar to:
For simple queries, QueryBuilderParser
should be enough.
Exporting CSV files
Just as a footnote, there are right ways to export CSV files, and there are wrong ways.
For the right way, check out the question on StackOverflow, How can I output a UTF-8 CSV in PHP that Excel will read properly?
Reporting Issues
I use this code in a number of my projects, so if you do find an issue, please feel free to report it with GitHub's bug tracker for this project.
Alternatively, fork the project and make a pull request :)