We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Database

Problem in Builder

i have 

    $resultset = $this->modelsManager->createBuilder()        
            ->columns(array("mi_pass.id"))
            ->from('Users')
            ->innerJoin('Passwords','mi_pass.owner = Users.id','mi_pass')
            ->where("Users.username = :user: ", array("user" => $username))
            ->getQuery()
            ->execute();

        foreach($resultset as $user){
            echo $user->my_pass;
        };

result is

Undefined property: Phalcon\Mvc\Model\Row::$my_pass

why ?



3.8k

Could you try:

foreach($resultset as $user){
    echo $user->mi_pass;
};


34.6k

You just have to access id:

foreach($resultset as $user){
    echo $user->id;
};