sukohi/json-where

Maintainers

Details

github.com/SUKOHI/JsonWhere

Source

Issues

Installs: 35

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 2

Forks: 0

Open Issues: 0

2.0.0 2015-08-08 20:53 UTC

Requires

MIT de01f105993f69180248d3a1ea0611efe80d8fa3

  • Sukohi <capilano.sukohi.woop@gmail.com>

This package is not auto-updated.

Last update: 2024-12-21 19:37:03 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