JsonWhere
A PHP package mainly developed for Laravel to easily set where clause for JSON.
(This is for Laravel 5+. For Laravel 4.2), (*1)
Installation
Add this package name in composer.json, (*2)
"require": {
"sukohi/json-where": "2.*"
}
Execute composer command., (*3)
composer update
Register the service provider in app.php, (*4)
'providers' => [
...Others...,
Sukohi\JsonWhere\JsonWhereServiceProvider::class,
]
Also alias, (*5)
'aliases' => [
...Others...,
'JsonWhere' => Sukohi\JsonWhere\Facades\JsonWhere::class
]
Usage
$jsons = DB::table('tests')->where(function($query){
\JsonWhere::query($query)
->column('json')
->value(3, $type = 'auto'); // $type: (default: auto), string or int. Optional.
})->get();
or You also can use model like so., (*6)
$jsons = \App\Test::where(function($query){
\JsonWhere::query($query)
->column('json')
->value(3, 'int');
})->get();
License
This package is licensed under the MIT License., (*7)
Copyright 2015 Sukohi Kuhoh, (*8)