Decoding JSON array laravel

Question

Hello i am having slight trouble with arrays in my application. I have a table in my database called "contacts" inside that table i have a column "info" of datatype 'TEXT' where i store a json encoded array. This is my function:

/**
 * Store a newly created resource in storage.
 *
 * @return Response
 */
public function store(Request $request)
{
    $contact = new Contacts;
    $contact->type = $request->type;
    $contact->name = str_replace('  ', ' ', $request->type == 'person' ? $request->first_name . ' ' . $request->other_name . ' ' . $request->last_name : $request->description);
    $contact->email = $request->email;
    $contact->info = json_encode($request->info);

    if ($contact->save())
    {
        return [
            'success' => 'Data was saved successfully!'
        ];
    }
}

Now this saves perfectly however the issues is when i retrieving the data from the database it returns that column as a "string" and as such i am unable to access that array from my front-end javascript (i use angular).

I have tried decoding the entire returned result but that did not work, still had the same problem:

/**
     * Display a listing of the resource.
     *
     * @return Response
     */
    public function index()
    {
        $type = Input::get('type');
        $contacts = "";

        if (empty($type))
        {
            $contacts = Contacts::get();
        }
        elseif ($type == 'persons')
        {
            $contacts = Contacts::where('type', 'person')->get();
        }
        elseif ($type == 'companies')
        {
            $contacts = Contacts::where('type', 'company')->get();
        }

        return [
            'contacts' => json_decode($contacts)
        ];
    }

I'm confused, the array was already encoded to JSON when it was saved in the DB now i want to decode it and return to the client. — user3718908x100
– user3718908x100, Commented Sep 4, 2015 at 16:26

Joseph Silber · Accepted Answer · 2015-09-04 16:27:30Z

3

Use the $casts property on your model:

class Contacts extends Eloquent
{
    protected $casts = ['inof' => 'json'];
}

It'll handle all encoding/decoding for you.

$contact->info = $request->info;

answered Sep 4, 2015 at 16:27

Joseph Silber

221k59 gold badges369 silver badges292 bronze badges

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

3 Comments

user3718908x100 Over a year ago

Wow!! Didn't know i could do that lol, learned something new today, thanks :)

scott Over a year ago

@Joseph Silber.how many type of properties available like you mentioned .i know proected $table,$hidden

Joseph Silber Over a year ago

@tester - Just look at the source. Most of them don't make much sense in your own models, but it'll give you a quick overview.

Collectives™ on Stack Overflow

Decoding JSON array laravel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related