Skip to main content

Yii, function to show all products in a category hierarchy


Below is the function to show all products in a category hierarchy created in Model file 'Categories':

<?php

public function get_category_products($cat_id) {
        if ($cat_rs = $this->find('category_parent_id=' . $cat_id)) {

            return $this->get_category_products($cat_rs->category_id);
        } else {

            return $product_rs = Products::model()->findAll('product_category_id=' . $cat_id);
        }
    }

?>


Popular posts from this blog

Yii, return to previous url after login or logout

If you want to return to your previous url after login or logout try this : <?php $this -> redirect (Yii :: app () -> request -> urlReferrer ); ?> To set the return url to be the url that was before the login page or registeration page was called you can put following code in views/layouts/main.php file : <?php //this checks id the controller action is not 'login' then it keeps the current url in returnUrl if (CController :: getAction () -> id != 'login' ) { Yii :: app () -> user -> setReturnUrl (Yii :: app () -> request -> getUrl ()); } ?>

yii, Executing a SQL without calling a Model

yii, Executing a SQL without calling a Model <? $connection = Yii :: app () -> db ; $sql = "SELECT id,username FROM users" ; $command = $connection -> createCommand ( $sql ); $dataReader = $command -> query (); $rows = $dataReader -> readAll (); print_r ( $rows ); ?>