Laravel, converting data from raw query to JSON

Question

Hy all, can anyone help me with converting some data which will be return from model(based on the RAW query) into JSON.

So in my controller i have something like:

public function get_index() {
    $data = Something::getDataFromRawQuery();

    return View::make('....')->with('data', $data);
}

So my question is how to forward JSON data to the view from controller?

Here is the query:

$apps = DB::query('SELECT a.name,
    a.desc,
    a.sig,
    ar.rate
    FROM something a
    INNER JOIN something_else ar
    ON (a.id=ar.something_id)
    ORDER BY ar.rate DESC'
 );

 return $apps;

If it's not Fluent or Eloquent, then what is it? mysqli? PDO? Can you show us the code doing the query? — Joseph Silber, May 19 '13 at 18:48
Out of curiosity: why are you shunning the Fluent Query Builder? — Joseph Silber, May 19 '13 at 19:01
@JosephSilber there are some things that are awkward with the query builder; although this query doesn't look like it would be. — Phill Sparks, May 19 '13 at 19:34
@PhillSparks - which is why I said *shunning*. Everything has its place. — Joseph Silber, May 19 '13 at 19:35

Joseph Silber · Accepted Answer · 2013-05-19T19:22:35.637

8

DB::query returns a simple array, so just call json_encode directly on it:

$data = Something::getDataFromRawQuery();

return View::make('....')->with('data', json_encode($data));

edited May 19 '13 at 19:22

answered May 19 '13 at 18:58

Joseph Silber

214,931
59
362
292

Getting error: Call to a member function to_array() on a non-object when use to_array() – Srle May 19 '13 at 19:06
After that in .js, var data = ; i get following: Error rendering view: [something::template] Array to string conversion – Srle May 19 '13 at 19:32
Why are you `json_decode`ing it? Just do `var data = ;` and you're done. – Joseph Silber May 19 '13 at 19:33

score 3 · Answer 2 · answered May 19 '13 at 18:57

Just use json_encode()

public function get_index() {
    $data = Something::getDataFromRawQuery();

    /* Do your loop here to build an array "results" from $data, if necessary
       Really depends on what ::getDataFromRawQuery returns. */

    return View::make('....')->with('data', json_encode($results));
}

Laravel, converting data from raw query to JSON

2 Answers2

Linked