sukohi/where-json

A Laravel package to mange WHERE clause for json data.

2.0.1 2016-06-02 19:15 UTC

This package is not auto-updated.

Last update: 2024-11-09 20:01:48 UTC


README

A Laravel package to mange WHERE clause for json data. (This is for Laravel 5+. For Laravel 4.2)

Installation

Execute composer command.

composer require sukohi/where-json:2.*

Preparation

Set WhereJsonTrait in your model like so.

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Sukohi\WhereJson\WhereJsonTrait;

class JsonValue extends Model
{
    use WhereJsonTrait;
}

Usage

$items = \App\Item::whereJson('column', [1])->get();

or

$items = \App\Item::whereJson('column', [
    'key1' => 'value1', 
    'key2' => 'value2', 
    'key3' => 'value3', 
])->get();
  • 1st argument is column name.
  • 2nd argument is array containing value you want to retrieve from the column value.

License

This package is licensed under the MIT License.

Copyright 2016 Sukohi Kuhoh