PHP User::addOrder Examples

Example #1

File: users_groups.php Project: BackupTheBerlios/ydframework-svn

$user->resetRelation();
$user->groups->id = 1;
$user->findRelation();
$user->groups->fetch();
YDDebugUtil::dump($user->groups->getValues());
while ($user->fetchRelation()) {
    YDDebugUtil::dump('-----------------------------------');
    YDDebugUtil::dump($user->getValues());
    YDDebugUtil::dump($user->join_groups->getValues());
}
echo "<h1>And how about the second group?</h1>";
echo "<p>Let's order by name and return only the group name, user name, is_admin and active.</p>";
echo "<p>And return the values in a single array.</p>";
$user->resetRelation();
$user->groups->id = 2;
$user->addOrder('name');
$user->addSelect('name', 'is_admin');
$user->join_groups->addSelect('active');
$user->groups->addSelect('name');
$user->findRelation();
while ($user->fetchRelation()) {
    YDDebugUtil::dump('-----------------------------------');
    YDDebugUtil::dump($user->getRelationValues());
}
echo "<h1>But I only want active users.</h1>";
$user->resetRelation();
$user->groups->id = 2;
$user->join_groups->active = 1;
$user->findRelation();
while ($user->fetchRelation()) {
    YDDebugUtil::dump($user->getRelationValues());