How show json data with database in symfony

Question

I have a little problem, because I have to show json date with database in Symfony3.

My controller

/**
     * @Route("/api/rest", name="rest_api")
     * 
     * 
     * @Template
     */
public function indexAction(Request $Request) {

    $Repo = $this->getDoctrine()->getRepository('CommonUserBundle:Comment');
    $row = $Repo->findAll();


    $data = json_encode($row, true);

    return array(
        'comment' => $data
    );
}

And this is my layout in html.twig

{% for comments in comment %}
           {{ comments }}
{% endfor %}

But I don't know why nothing show. Help me please :)

So are you trying to return json, or render a twig template? — Jenne
– Jenne, Commented Jun 7, 2017 at 15:15

Jenne · Accepted Answer · 2017-06-07 15:19:58Z

1

Ok using my deductive skills (as your question is a bit vague) I am going to make the opposite assumption as everyone else did and say use the JSON helper function (Since 3.2).

return $this->json($myThings);

If you are working in older versions you need to return a proper Response object with the headers and such.

answered Jun 7, 2017 at 15:19

Jenne

9035 silver badges14 bronze badges

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

Comments

goto · Accepted Answer · 2017-06-07 15:13:00Z

0

json_encode return a string.

Twig

{{ dump(comments) }}

answered Jun 7, 2017 at 15:13

goto

8,21210 gold badges50 silver badges60 bronze badges

Comments

Alessandro Minoccheri · Accepted Answer · 2017-06-07 15:16:04Z

0

try this:

  {% for comments in comment %}
       {{ comment }}
  {% endfor %}

If it doesn't work try to change and you want to print an array

$data = json_encode($row, true);

to $data = json_decode(json_encode($row), true);

if you want to print the string try this inside your twig

{{ dump(comments) }}

instead of this

{% for comments in comment %}
       {{ comment }}
  {% endfor %}

edited Jun 7, 2017 at 15:16

answered Jun 7, 2017 at 15:09

Alessandro Minoccheri

36.1k22 gold badges128 silver badges176 bronze badges

4 Comments

goto Over a year ago

No he has @template annotation

Alessandro Minoccheri Over a year ago

ops sorry update answer with a new solution, thanks @goto

Jakub W Over a year ago

Yea, probalby I have to use object Response but I don't know how

Jakub W Over a year ago

When I use decode json I have error ,,Warning: json_decode() expects parameter 1 to be string, array given''

Collectives™ on Stack Overflow

How show json data with database in symfony

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related