Zend Framework - join query

Question

I build a function

public function getBannedByLogin($commentId)
    {
    $sql = $this->getDbAdapter()->select()
            ->from(array('comments' => 'comments'), array())
            ->join(array('users' => 'qengine_users'),
            'comments.bannedBy = users.userId',
            array())
            ->where('commentId = ?', $commentId)
        ;
        $row = $this->fetchRow($sql);
        return $row['login'];

    }

And there are problems, that does'nt work! :D Let's I explain you. Column 'bannedBy' from comments returns id of user, who give a ban. I need to join this with table users to load a login field. Where i have mistakes?

mingos · Accepted Answer · 2014-04-25 18:27:27Z

0

I assume the code works in the sense of not throwing an exception. If so, your code is OK, you just specifically tell Zend_Db not to select any columns.

public function getBannedByLogin($commentId)
{
$sql = $this->getDbAdapter()->select()
        ->from(array('comments' => 'comments'))
        ->join(array('users' => 'qengine_users'),
        'comments.bannedBy = users.userId')
        ->where('commentId = ?', $commentId)
    ;
    $row = $this->fetchRow($sql);
    return $row['login'];

}

The last argument to from() and join() functions is an array of columns you wish to select. If you pass in an empty array, no columns are selected. No argument = select everything. You can, of course, specify only the columns you need too.

answered Apr 25, 2014 at 18:27

mingos

24.7k12 gold badges73 silver badges108 bronze badges

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

Collectives™ on Stack Overflow

Zend Framework - join query

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