sukohi / json-where
Installs: 36
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 1
Forks: 0
Open Issues: 0
pkg:composer/sukohi/json-where
Requires
- laravel/framework: ~5.0
This package is not auto-updated.
Last update: 2025-09-27 23:26:23 UTC
README
A PHP package mainly developed for Laravel to easily set where clause for JSON.
(This is for Laravel 5+. For Laravel 4.2)
Installation
Add this package name in composer.json
"require": {
"sukohi/json-where": "2.*"
}
Execute composer command.
composer update
Register the service provider in app.php
'providers' => [
...Others...,
Sukohi\JsonWhere\JsonWhereServiceProvider::class,
]
Also alias
'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.
$jsons = \App\Test::where(function($query){
\JsonWhere::query($query)
->column('json')
->value(3, 'int');
})->get();
License
This package is licensed under the MIT License.
Copyright 2015 Sukohi Kuhoh