Working with objects - Component overview - Collection - Loading related records.php 658 Bytes
Newer Older
lsmith's avatar
lsmith committed
1
Doctrine provides means for efficiently retrieving all related records for all record elements. That means
hansbrix's avatar
hansbrix committed
2 3
when you have for example a collection of users you can load all phonenumbers for all users by simple calling
the loadRelated() method.
4

hansbrix's avatar
hansbrix committed
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
<code type="php">
$users = $conn->query("FROM User");

// now lets load phonenumbers for all users

$users->loadRelated("Phonenumber");

foreach($users as $user) {
    print $user->Phonenumber->phonenumber;
    // no additional db queries needed here
}

// the loadRelated works an any relation, even associations:

$users->loadRelated("Group");

foreach($users as $user) {
    print $user->Group->name;
}
</code>