Foreach As Function

kopecsrk · May 28, 2013, 11:24am

Hello.

I have Join function:


  public function getFormQuest() {

        $select = Yii::app()->db->createCommand()

                ->select('pytanie')

                ->from('quest_open p')

                ->join('odp_open_form o', 'p.id=o.quest_open_id')

                ->where('form_id=' . $this->id . '')

                ->queryAll();

    }

And in view :


<?php $model->getFormQuest();?>

How i can get foreach in view, where my question must by render.

sukunj · May 28, 2013, 12:00pm

Hello.

You have to return the array then only you can get array in view and then using forwach loop u can retrive data.

your function shold be like this as follow:


  public function getFormQuest() {

        $select = Yii::app()->db->createCommand()

                ->select('pytanie')

                ->from('quest_open p')

                ->join('odp_open_form o', 'p.id=o.quest_open_id')

                ->where('form_id=' . $this->id . '')

                ->queryAll();

        return $select;

    }

And in view :


<?php 

$model->getFormQuest();?>

How i can get foreach in view, where my question must by render.

[/quote]

kopecsrk · May 28, 2013, 12:14pm

Now i do that, but in view doesn;t render my question.

But when i do that:


public function getFormQuest() {

        $select = Yii::app()->db->createCommand()

                ->select('pytanie')

                ->from('quest_open p')

                ->join('odp_open_form o', 'p.id=o.quest_open_id')

                ->where('form_id=' . $this->id . '')

                ->queryAll();

        var_dump($select);

    }

I get in view:


array (size=3)

  0 => 

    array (size=1)

      'question' => string 'question 1?' (length=11)

  1 => 

    array (size=1)

      'question' => string 'question 2?' (length=11)

  2 => 

    array (size=1)

      'question' => string 'question 3?' (length=11)

sukunj · May 29, 2013, 6:48am

public function getFormQuest() {

    &#036;select = Yii::app()-&gt;db-&gt;createCommand()


            -&gt;select('pytanie')


            -&gt;from('quest_open p')


            -&gt;join('odp_open_form o', 'p.id=o.quest_open_id')


            -&gt;where('form_id=' . &#036;this-&gt;id . '')


            -&gt;queryAll();


    return &#036;select;


}

and in the view file

<?php

&#036;data = &#036;model-&gt;getFormQuest();


print_r(&#036;data);exit;

?>

This will 100% work…I have tried …

kopecsrk · May 29, 2013, 6:56am

Sukunj Mendpara Rudra Soft:

public function getFormQuest() {

    &#036;select = Yii::app()-&gt;db-&gt;createCommand()


            -&gt;select('pytanie')


            -&gt;from('quest_open p')


            -&gt;join('odp_open_form o', 'p.id=o.quest_open_id')


            -&gt;where('form_id=' . &#036;this-&gt;id . '')


            -&gt;queryAll();


    return &#036;select;


}

and in the view file

<?php

&#036;data = &#036;model-&gt;getFormQuest();


print_r(&#036;data);exit;