How do you convert Laravel query results to json?

Question

I have a query that I call with:

$query = "select * from myTable";
$results = DB::connection('myDB')->select($query);

I want to be able to get this in the simple json format of:

[{firstColumn: firstColumnValue, secondColumn: secondColumnValue},
{firstColumn: firstColumnValue, secondColumn: secondColumnValue}]

What is the easiest way to achieve this?

the `$results` variable is actually an `StdClass`. You can directly use the `Response::json` facade as well if you need to directly send the data as a response. — psiyumm, Nov 15 '15 at 06:37

score 4 · Answer 1 · edited May 23 '17 at 10:27

4

As I have read here : Laravel, converting data from raw query to JSON you can just use the json_encode. Hope that one helps.

edited May 23 '17 at 10:27

Community

1
1

answered Nov 15 '15 at 05:49

It doesn't work? What's the output upon trying that? Can I see – Nov 15 '15 at 05:54
Great! Happy coding :) – Nov 15 '15 at 05:55

score 1 · Answer 2 · answered Nov 15 '15 at 06:21

If you thought of writing web service or something related to it, then

$Response = array('success' => '1', 'result' => $yourData);
else
$Response = array('success' => '0', 'error' => 'Your Custom Errors');
return json_encode($Response);

So that you can handle it in while you retrieve according to the result.

How do you convert Laravel query results to json?

2 Answers2