Set and fetch bindModel query in cake template file

Question

$categ = $this->FreeadsCategory->bindModel( array( 'hasMany' => array( 'Subcategory' => array('foreignKey' => 'category_id', 'order'=>'id ASC') ) ) );

$data = $this->FreeadsCategory->findById($i); $this->set("datas", $data);

I am not able to fetch the datas in view page using cakephp
If i give pr($datas); showing nothing in ctp file
If i print the data in controller i am getting the following array structure

Array ( [FreeadsCategory] => Array ( [id] => 1 [uuid] => 51512434-e4c4-441b-b90e-16f8732d5573 [category] => Automobiles [status] => Active )

[Subcategory] => Array
    (
        [0] => Array
            (
                [id] => 1
                [uuid] => 4ea15f22-adf0-4020-b35d1-052ff9ff9a27
                [category_id] => 1
                [subcategory] => Cars/Cabs/Jeeps
                [status] => Active
            )

        [1] => Array
            (
                [id] => 5
                [uuid] => 51cec363-e7ac-4095-a86b-0ccdf260d1b4
                [category_id] => 1
                [subcategory] => Buses/Lorries
                [status] => Active
            )

)

floriank floriank · Accepted Answer · 2013-09-25T21:49:42

You don't fetch data in views, that violates the MVC pattern. Technically there are ways to do it but it's plain wrong, you'll end up with unmaintanable garbage code.

I really recommend you to get started by reading about the MVC design pattern and to do the CakePHP blog tutorial first to get a minimum of understanding of how CakePHP works.

Set and fetch bindModel query in cake template file

1 Answers