symfony get data from db in while loop

Question

I need to grab data from a symfony 2 db. The data looks like :

Parent-Element [id 15]
 -> Child Element [id 20, parent ID 15]
 --->Child Element [id 27, parent ID 20]
 ----->Child Element [id 34, Parent ID 27]
 ....

The Childs are assigned to each parent Element by a cathegory ID see [ ]. There might be more than one Child Elements per level.

In php it would be easy to grab this by a while loop. But in Symfony im stucking. Can anyone help me finding a solution? IS there a while loop in symfony?

Kind regdards

Philipp

EDIT: I mean, in "normal" php I would do a simple while or create an array with ids which I loop through by another while loop... In smyfony, I would use a queryBuilder like that

$query = $em->createQueryBuilder()
    ->select('d')
    ->from('PrUserBundle:Location', 'd')
    ->where('d.client_id = :client_id')
    ->setParameter('client_id', $this->clientId)
    ->getQuery();
    $results=$query->getResult();

Where I don't see any possibility to grab any other Ids or sort it so that I can render a parent-child listing.

Uhm, Symfony is PHP, you can use while loops all you want. Could it be that your question is rather aimed at the difference between retrieving results in plain MySQL and retrieving results in Doctrine/DQL? If so, please clarify. — lxg
– lxg, Commented Sep 2, 2014 at 9:57

Trone · Accepted Answer · 2014-09-02 07:55:07Z

1

What about iterators:

$iterator = new RecursiveIteratorIterator(new RecursiveArrayIterator($array));
foreach($iterator as $key => $value) {
    echo "$key => $value\n";
}

answered Sep 2, 2014 at 7:55

Trone

1347 bronze badges

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

Collectives™ on Stack Overflow

symfony get data from db in while loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related