Recommend this page to a friend! |
Download |
Info | Files | Install with Composer | Download | Reputation | Support forum | Blog | Links |
Ratings | Unique User Downloads | Download Rankings | ||||
76% | Total: 1,060 | All time: 3,501 This week: 41 |
Version | License | PHP version | Categories | |||
jsonq 1.0.22 | The PHP License | 5 | PHP 5, Parsers |
Description | Author | |||
This package can query JSON data to find and extract information. Innovation Award
|
JsonQ is a simple, elegant PHP package to Query over any type of JSON Data. It'll make your life easier by giving the flavour of an ORM-like query on your JSON.
Hey due, please help me out for daily improve this project
composer require nahid/jsonq
You can start using this package right away by importing your JSON data from a file:
use Nahid/JsonQ/Jsonq;
$jsonq = new Jsonq('data.json');
Or from a JSON String:
$json->json('{"id": 1, "name": "Nahid"}');
Or from a PHP Array:
$json->collect(['id'=>1, 'name'=>'Nahid']);
You can start Query your data using the various query methods such as find, where, orWhere, whereIn, whereStartsWith, whereEndsWith, whereContains and so on. Also you can aggregate your data after query using sum, count, groupBy, max, min etc.
Let's see a quick example:
//data.json
{
"name": "products",
"description": "Features product list",
"vendor":{
"name": "Computer Source BD",
"email": "info@example.com",
"website":"www.example.com"
},
"users":[
{"id":1, "name":"Johura Akter Sumi", "location": "Barisal"},
{"id":2, "name":"Mehedi Hasan Nahid", "location": "Barisal"},
{"id":3, "name":"Ariful Islam", "location": "Barisal"},
{"id":4, "name":"Suhel Ahmed", "location": "Sylhet"},
{"id":5, "name":"Firoz Serniabat", "location": "Gournodi"},
{"id":6, "name":"Musa Jewel", "location": "Barisal", "visits": [
{"name": "Sylhet", "year": 2011},
{"name": "Cox's Bazar", "year": 2012},
{"name": "Bandarbar", "year": 2014}
]}
],
"products": [
{"id":1, "user_id": 2, "city": "bsl", "name":"iPhone", "cat":1, "price": 80000},
{"id":2, "user_id": 2, "city": null, "name":"macbook pro", "cat": 2, "price": 150000},
{"id":3, "user_id": 2, "city": "dhk", "name":"Redmi 3S Prime", "cat": 1, "price": 12000},
{"id":4, "user_id": 1, "city": null, "name":"Redmi 4X", "cat":1, "price": 15000},
{"id":5, "user_id": 1, "city": "bsl", "name":"macbook air", "cat": 2, "price": 110000},
{"id":6, "user_id": 2, "city": null, "name":"macbook air 1", "cat": 2, "price": 81000}
]
}
use Nahid\JsonQ\Jsonq;
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 2)
->get();
dump($res);
//This will print
/*
array:3 [?
1 => {#7 ?
+"id": 2
+"user_id": 2
+"city": null
+"name": "macbook pro"
+"cat": 2
+"price": 150000
}
4 => {#8 ?
+"id": 5
+"user_id": 1
+"city": "bsl"
+"name": "macbook air"
+"cat": 2
+"price": 110000
}
5 => {#9 ?
+"id": 6
+"user_id": 2
+"city": null
+"name": "macbook air 1"
+"cat": 2
+"price": 81000
}
]
*/
Let's say we want to get the Summation of _price_ of the Queried result. We can do it easily by calling the sum() method instead of get():
$result = $json->from('products')
->where('cat', '=', 2)
->sum('price');
dump($result);
//It will print:
/*
365000
*/
Pretty neat, huh?
Let's explore the full API to see what else magic this library can do for you. Shall we?
Following API examples are shown based on the sample JSON data given here. To get a better idea of the examples see that JSON data first. Also detailed examples of each API can be found here.
List of API:
fetch()
This method will execute queries and will return the resulted data. You need to call it finally after using some query methods. Details can be found in other API examples.
find(path)
You don't need to call fetch()
method after this. Because this method will fetch and return the data by itself.
caveat: You can't chain further query methods after it. If you need that, you should use at()
or from()
method.
example:
Let's say you want to get the value of _'cities'_ property of your Json Data. You can do it like this:
$q = new Jsonq('data.json');
echo $q->find('vendor.name');
If you want to traverse to more deep in hierarchy, you can do it like:
$q = new Jsonq('data.json');
echo $q->find('vendor.name');
See a detail example here.
from(path)
By default, query would be started from the root of the JSON Data you've given. If you want to first move to a nested path hierarchy of the data from where you want to start your query, you would use this method. Skipping the path
parameter or giving '.' as parameter will also start query from the root Data.
Difference between this method and find()
is that, find()
method will return the data from the given path hierarchy. On the other hand, this method will return the Object instance, so that you can further chain query methods after it.
example:
Let's say you want to start query over the values of _'vendor.name'_ property of your JSON Data. You can do it like this:
$q = new Jsonq('data.json');
echo $q->from('vendor.name')->get();
If you want to traverse to more deep in hierarchy, you can do it like:
$q = new Jsonq('data.json');
echo $q->from('users.5.visits')->get();
See a detail example here.
at(path)
This is an alias method of from()
and will behave exactly like that. See example here.
where(key, condition, val)
`op` -- operand to be used for matching. The following operands are available to use:
* `=` : For weak equality matching
* `eq` : Same as `=`
* `!=` : For weak not equality matching
* `neq` : Same as `!=`
* `==` : For strict equality matching
* `seq` : Same as `==`
* `!==` : For strict not equality matching
* `sneq` : Same as `!==`
>
: Check if value of givenkeyin data is Greater thanval*
* `gt` : Same as `>`
<
: Check if value of givenkeyin data is Less thanval*
* `lt` : Same as `<`
>=
: Check if value of givenkeyin data is Greater than or Equal ofval*
* `gte` : Same as `>=`
<=
: Check if value of givenkeyin data is Less than or Equal ofval*
* `lte` : Same as `<=`
null
: Check if the value of givenkeyin data isnull* (`val` parameter in `where()` can be omitted for this `op`)
notnull
: Check if the value of givenkeyin data isnot null* (`val` parameter in `where()` can be omitted for this `op`)
in
: Check if the value of givenkeyin data is exists in givenval.val* should be a plain _Array_.
notin
: Check if the value of givenkeyin data is not exists in givenval.val* should be a plain _Array_.
startswith
: Check if the value of givenkeyin data starts with (has a prefix of) the givenval*. This would only works for _String_ type data.
endswith
: Check if the value of givenkeyin data ends with (has a suffix of) the givenval*. This would only works for _String_ type data.
contains
: Check if the value of givenkeyin data has a substring of givenval*. This would only works for _String_ type data.
match
: Check if the value of givenkeyin data has a Regular Expression match with the givenval. The val
parameter should be aRegExp* for this `op`.
macro
: It would try to match the value of givenkeyin data executing the given val
. The val
parameter should be aFunctionfor this op
. This function should have a matching logic inside it and returntrueorfalse* based on that.
example:
Let's say you want to find the _'users'_ who has _id
_ of 1
. You can do it like this:
$q = new Jsonq('data.json');
$res = $q->from('users')->where('id', '=', 1)->get();
You can add multiple _where_ conditions. It'll give the result by AND-ing between these multiple where conditions.
$q = new Jsonq('data.json');
$res = $q->from('users')
->where('id', '=', 1)
->where('location', '=', 'barisal')
->get();
See a detail example here.
orWhere(key, op, val)
Parameters of orWhere()
are the same as where()
. The only difference between where()
and orWhere()
is: condition given by the orWhere()
method will OR-ed the result with other conditions.
For example, if you want to find the users with _id_ of 1
or 2
, you can do it like this:
$q = new Jsonq('data.json');
$res = $q->from('users')
->where('id', '=', 1)
->orWhere('id', '=', 2)
->get();
See detail example here.
whereIn(key, val)
This method will behave like where(key, 'in', val)
method call.
whereNotIn(key, val)
This method will behave like where(key, 'notin', val)
method call.
whereNull(key)
This method will behave like where(key, 'null')
or where(key, '=', null)
method call.
whereNotNull(key)
This method will behave like where(key, 'notnull')
or where(key, '!=', null)
method call.
whereStartsWith(key, val)
This method will behave like where(key, 'startswith', val)
method call.
whereEndsWith(key, val)
This method will behave like where(key, 'endswith', val)
method call.
whereContains(key, val)
This method will behave like where(key, 'contains', val)
method call.
sum(column)
example:
Let's say you want to find the sum of the _'price'_ of the _'products'_. You can do it like this:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->sum('price');
If the data you are aggregating is plain array, you don't need to pass the 'column' parameter. See detail example here
count()
It will return the number of elements in the collection.
example:
Let's say you want to find how many elements are in the _'products'_ property. You can do it like:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->count();
See detail example here.
size()
This is an alias method of count()
.
max(column)
example:
Let's say you want to find the maximum of the _'price'_ of the _'products'_. You can do it like this:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->max('price);
If the data you are querying is plain array, you don't need to pass the 'column' parameter. See detail example here
min(column)
example:
Let's say you want to find the minimum of the _'price'_ of the _'products'_. You can do it like this:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->min('price');
If the data you are querying is plain array, you don't need to pass the 'property' parameter. See detail example here
avg(column)
example:
Let's say you want to find the average of the _'price'_ of the _'products'_. You can do it like this:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->avg('price');
If the data you are querying is plain array, you don't need to pass the 'column' parameter. See detail example here
first()
It will return the first element of the collection.
example:
$q = new jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->first();
See detail example here.
last()
It will return the last element of the collection.
example:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->last();
See detail example here.
nth(index)
It will return the nth element of the collection. If the given index is a positive value, it will return the nth element from the beginning. If the given index is a negative value, it will return the nth element from the end.
example:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->nth(2);
See detail example here.
exists()
It will return true if the element is not empty or not null or not an empty array or not an empty object.
example:
Let's say you want to find how many elements are in the _'products'_ property. You can do it like:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->exists();
See detail example here.
groupBy(column)
example:
Let's say you want to group the _'users'_ data based on the _'location'_ property. You can do it like:
$q = new Jsonq('data.json');
$res = $q->from('users')
->groupBy('location')
->get();
See detail example here.
sort(order)
Note: This method should be used for plain Array. If you want to sort an Array of Objects you should use the sortBy() method described later.
example:
Let's say you want to sort the _'arr'_ data. You can do it like:
$q = new Jsonq();
$res = $q->collect([7, 5, 9, 1, 3])
->sort();
See detail example here.
sortBy(column, order)
Note: This method should be used for Array of Objects. If you want to sort a plain Array you should use the sort() method described earlier.
example:
Let's say you want to sort the _'price'_ data of _'products'_. You can do it like:
$q = new Jsonq('data.json');
$res = $q->from('products')
->where('cat', '=', 1)
->sortBy('price', 'desc');
See detail example here.
reset(data)
At any point, you might want to reset the Object instance to a completely different set of data and then query over it. You can use this method in that case.
See a detail example here.
copy()
It will return a complete clone of the Object instance.
See a detail example here.
If you encounter any bugs or issues, feel free to open an issue at github.
Also, you can shoot me an email to <mailto:nahid.dns@gmail.com> for hugs or bugs.
This package has also different language support.
Hey dude! Help me out for a couple of :beers:!
Files (37) |
File | Role | Description | ||
---|---|---|---|---|
.github (1 file) | ||||
config (1 file) | ||||
examples (12 files) | ||||
src (4 files, 3 directories) | ||||
tests (5 files, 1 directory) | ||||
.travis.yml | Data | Auxiliary data | ||
changelog.txt | Doc. | Documentation | ||
composer.json | Data | Auxiliary data | ||
LICENSE | Lic. | License text | ||
phpunit.xml.dist | Data | Auxiliary data | ||
README.md | Doc. | Documentation |
Files (37) | / | examples |
File | Role | Description |
---|---|---|
copy.php | Example | Example script |
count.php | Example | Example script |
data.json | Data | Auxiliary data |
exists.php | Example | Example script |
find.php | Example | Example script |
from.php | Example | Example script |
get.php | Example | Example script |
group-by.php | Example | Example script |
index.php | Example | Example script |
max.php | Example | Example script |
min.php | Example | Example script |
sum.php | Example | Example script |
Files (37) | / | src |
File | Role | Description | ||
---|---|---|---|---|
Exceptions (5 files) | ||||
Facades (1 file) | ||||
Results (1 file) | ||||
Condition.php | Class | Class source | ||
Jsonq.php | Class | Class source | ||
JsonqServiceProvider.php | Class | Class source | ||
JsonQueriable.php | Class | Class source |
Files (37) | / | src | / | Exceptions |
File | Role | Description |
---|---|---|
ConditionNotAllowedException.php | Class | Class source |
FileNotFoundException.php | Class | Class source |
InvalidJsonException.php | Class | Class source |
InvalidNodeException.php | Class | Class source |
NullValueException.php | Class | Class source |
Files (37) | / | tests |
File | Role | Description | ||
---|---|---|---|---|
Facades (1 file) | ||||
AbstractTestCase.php | Class | Class source | ||
ConditionTest.php | Class | Class source | ||
JsonqServiceProviderTest.php | Class | Class source | ||
JsonQueriableTest.php | Class | Class source | ||
TestCase.php | Class | Class source |
The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page. |
Install with Composer |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
100% |
|
|
User Ratings | User Comments (1) | ||||||||||||||||||||||||||||||||||
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.