php - trying to create a 'join' statement using Zend DB Table - zend framework 2

Solution:

This is not an answer to the question but since i cant comment yet i will post this here. I found the following website helpful with the join examples.

github.com

Solution:

the end result of my model_friends script is as follows:

<?php
//model created to add user to database, sendmail etc...
require_once 'Zend/Db/Table/Abstract.php';

class Model_Friends extends Zend_Db_Table_Abstract
{
protected $_name = "friend_list";

public function fetchFriendList($userID)
{       
    $select = $this->select()
                   ->from($this)
                   ->setIntegrityCheck(false)
                   ->join(array('u'=>'user_profile'), 'friend_list.friend_id =u.id', array())
                   ->columns(array('u.id', 'u.username'))
                   ->where("friend_list.user_id = ?", $userID);     

    $result = $this->fetchAll($select);                    
    if ($result !== null){
        echo $select;
        return $result;
    } else {
        echo "no records found";
    }   
  }
}
Copy code