how to use hasone

Question

how to use hasone

nick Jun '16

Created Jun '16	Last Reply Jul '16	Replies 3	Views 565	Votes 0

nick 705

Jun '16

i have two myISAM tables:ex1 ex2. each table have two Field.They are id1,t1(ex1) ; id2,t2(ex2); how to use hasone method that it can be the same as this SQL:

select ex1.*,ex2.* from ex1 inner join ex2 where ex1.id1=ex2.id2;

model:

//model ex1.php
namespace Frontend\Model;       
class ex1 extends \Phalcon\Mvc\Model{    
    public initialize(){
        $this->hasone( 'id1' , 'Model\ex2' , 'id2' , array( 'alias' => ‘ex2’) );
    }
}

controller:

//controller indexController.php     
namespace  Frontend\Controller; 
use \Frontend\Model\ex1;

class indexController extends Phalcon\Mvc\Controller{     
    public indexAction(){
        $result = ex1::find() -> toArray();
        var_dump( $result );
    }
}

OS: win8.1 64 Nginx:1.8.1 PHP:php-5.4.45-nts-Win32-VC9-x86 Phalcon:2.1.0r

The result is : only ex1 data can be displayed. how to fix it? Thanks for your help.

Wojciech Ślawski
145.0k

Accepted
answer

Jun '16

But you didn't even accesed data ? You need to make a join men. Use queryBuilder or ::query static method

Wojciech Ślawski · Answer 1 · 2016-06-30T13:55:57-07:00

Wojciech Ślawski
145.0k

Jun '16

Change it to belongsTo

nick · Answer 2 · 2016-06-30T16:11:10-07:00

nick
705

in reply to

Wojciech Ślawski

Jun '16

I've tried. But the results did not change.

Change it to belongsTo

nick · Answer 3 · 2016-07-01T17:36:50-07:00

i use raw sql to solve:

static public function queryAll()
    {
        # code...
        $sql = 'SELECT tdm_ex1.* ,tdm_ex2.* FROM tdm_ex1 INNER JOIN tdm_ex2 WHERE tdm_ex1.id1=tdm_ex2.id2';

        $ex1= new self();

        return new Resultset( null , $ex1 , 
            $ex1 ->getReadConnection() -> query($sql)
        );
    }

But you didn't even accesed data ? You need to make a join men. Use queryBuilder or ::query static method

Wojciech Ślawski · Answer 4 · 2016-07-02T03:07:29-07:00

You can use phalcon ::query or models manager. No need to use raw sql, https://docs.phalcon.io/pl/latest/reference/phql.html#creating-queries-using-the-query-builder

nick · Answer 5 · 2016-07-03T07:59:04-07:00

Thanks,it works.

CreateBuilder:

$result = $modelsManager -> createBuilder()
            ->columns('Ex1Model.*,Ex2Model.*')          
            ->from( ['Ex1Model' => 'Tdm\Home\Models\Ex1Model'] )
            ->join( 'Tdm\Home\Models\Ex2Model', 'Ex1Model.id1 = Ex2Model.id2' , 'Ex2Model' ,'INNER' )           
            ->getQuery()
            ->execute();

PHQL:

$result=$modelsManager ->executeQuery( '
            select Ex1Model.id1,Ex2Model.id2 from Tdm\Home\Models\Ex1Model as Ex1Model 
            inner join Tdm\Home\Models\Ex2Model as Ex2Model on Ex1Model.id1 =Ex2Model.id2           
        ');

You can use phalcon ::query or models manager. No need to use raw sql, https://docs.phalcon.io/pl/latest/reference/phql.html#creating-queries-using-the-query-builder