Symfony 2 - querybuilder nested tree array

Question

Here is scenario:

   id  parent_id  search
   1   null       hello
   2   1          hello/something
   3   1          hello/new
   4   null       new
   5   4          new/hello

Then I got via querybuilder and searching "hello" to this results:

   1   null       hello
   2   1          hello/something
   3   1          hello/new
   5   4          new/hello
   5   4          new/hello

How to build nested tree via querybuilder if I want only get all elements inside childs, include "hello/something" ?

How to build up using symfony to array?

Dan Blows · Accepted Answer · 2015-03-24 14:55:19Z

0

Assuming you're using Doctrine, check out the tree extension in DoctrineExtensions

answered Mar 24, 2015 at 14:55

Dan Blows

21.2k10 gold badges68 silver badges99 bronze badges

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

2 Comments

Marin Sagovac Over a year ago

I don't want to use Doctrine, I know for this, but i'm using LIKE statements.

Dan Blows Over a year ago

If you can't use the doctrine extension, then just get it as an array and then look at this answer.

Collectives™ on Stack Overflow

Symfony 2 - querybuilder nested tree array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related