Here is my Row Query to get the data from database.
$users = DB::table('users')->get();
I want to pass my $users array data to json format. How can I do so?
I have tried using Eloquent Model. but didn't work.
Thank You in Advance.
3 Answers
If you use Eloquent then you can use ->toJson();
But you are using Query builder. So you have to use php function: json_encode()
For more information see here http://php.net/manual/en/function.json-encode.php
2 Comments
Bhavin Shah
Yes i m using Query Builder. Thanks
RV Technologies
Bhavin, if my answer is helpful then please accept it :)
Eloquent has a method named
->toJson()
However you're code doesn't looks like Eloquent.
1 Comment
Bhavin Shah
I m using Query Builder. so using json_encode() , i can get array values in json format.
To get an array instead of object, you have to pass true as second parameter
json_decode($user,true)
json_encode?return json_encode(User:all());