Mysql json column output backslash

Question

It is my first time to use Mysql json column type when I make post request via Laravel api to make new user like this

"username:andy21, password:123456, profile:{"home_town":"germany"}"

I save profile in the Json column when I retrieve it, it have backslash before every " on the json object like this

"profile":"{\"home_town\":\"germany\"}"

my return in laravel controller looks like this

return response()->json(['profile'=>$user]);

why it have these backslashes and how to remove it ?

Same as I have sent it, I think it maybe because of the json respons in laravel — Hesham Watany
– Hesham Watany, Commented Dec 15, 2016 at 21:04

Artur Subotkevič · Accepted Answer · 2016-12-15 21:01:29Z

2

Try this, if your $user variable is in JSON format:

return response()->json(['profile' => json_decode($user)]);

answered Dec 15, 2016 at 21:01

Artur Subotkevič

1,9391 gold badge15 silver badges18 bronze badges

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

1 Answer 1