PHP xf\db Database::getObjects Examples

Example #1

File: api.php Project: shannah/social-network-server

function find_users($token = null, $search)
{
    global $error_message;
    $db = new Database(df_db());
    $user = get_user();
    if (!$user) {
        $error_message = "You are not logged in";
        return false;
    }
    $out = $db->getObjects("select p.username, p.avatar, p.screen_name, if(f.user1 IS NULL, 0, 1) as is_friend,\n  if(pending_invites.sender IS NULL, 0, 1) as has_pending_invite\n    from profiles p \n    left join friends f on ((p.username=f.user1 and f.user2=:user) or (p.username=f.user2 and f.user1=:user)) \n  left join friend_requests pending_invites on (pending_invites.receiver=p.username and pending_invites.sender=:user)\n    where (p.username like :query or p.screen_name like :query) and p.username != :user limit 100", array('query' => '%' . $search . '%', 'user' => $user));
    foreach ($out as $o) {
        $o->avatar = get_avatar_url($o);
    }
    return $out;
}