showing json array data from mysql database to laravel blade view

Question

Here is the Migration file, I have stored two numbers as json in mysql database, ["1234","4568"]. like this the O/P I am getting is "[\"1234\", \"5678\"]" but I need to print 1234,5678

public function up()
{
    Schema::create('store', function (Blueprint $table) {
        $table->increments('id');
        $table->json('store_numbers');

    });

}

//blade view

@foreach($stores as $store)
     <tr>
         <td>{{ $store->store_id }}</td>
         <td>{{ json_encode($store->store_numbers)}}</td>
     </tr>
@endforeach

Rosh · Accepted Answer · 2018-12-16 07:06:49Z

1

Try this:

@foreach($stores as $store)
     <tr>
         <td>{{ $store->store_id }}</td>
         @php $store_numbers= json_decode($store->store_numbers); @endphp
         @foreach($store_numbers as $store_number)
            <td>
                 {{$store_number}}
            </td>
         @endforeach
     </tr>
@endforeach

answered Dec 16, 2018 at 7:06

Rosh

4912 gold badges7 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

showing json array data from mysql database to laravel blade view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related