JAVASCRIPT

laravel read from db json string in blade in table

@foreach ($coupon as $key => $item)   @endforeach )
<?php
$transaction_result='';
if ($item->transaction_result){$transaction_result= json_decode($item->transaction_result);}
?>
<td>
  <?php if ($item->transaction_result) echo  ($transaction_result->fourdigits)?>
</td>

laravel output json database field as json

class Paste extends Model {
    protected $casts = [
        'data' => 'array'
    ];
}

get a json element from a DB laravel

$results = DB::table('testing')
             ->select(
                'id',
                DB::raw('json_extract(params, "$.4") as number'),
                'type'
                'created_at'
)->get();