Store Procedure In Yii : How To Pass Data From Store Procedure Into Yii Form

selimppc · December 5, 2013, 7:40am

I am running store procedure. I want to pass store procedure data from MySQL and then insert into a from to save a table. I have tried but failed to success. I am missing something because I am new in yii.

Controller::

public function actionCreate()

{

&#036;model=new Requisitionhd;


        &#036;model-&gt;pp_requisitionno = mysql_query('CALL sp_pp_requisition_insert( :pp_requisitionno)');





if(isset(&#036;_POST['Requisitionhd']))


{


    &#036;model-&gt;attributes=&#036;_POST['Requisitionhd'];


    if(&#036;model-&gt;save())


        &#036;this-&gt;redirect(array('view','id'=&gt;&#036;model-&gt;pp_requisitionno));


}





&#036;this-&gt;render('create',array(


    'model'=&gt;&#036;model,


));

}

Form :::

&lt;?php echo &#036;form-&gt;labelEx(&#036;model,'pp_requisitionno'); ?&gt;


&lt;?php echo &#036;form-&gt;textField(&#036;model,'pp_requisitionno',array('size'=&gt;50,'maxlength'=&gt;50)); ?&gt;


&lt;?php echo &#036;form-&gt;error(&#036;model,'pp_requisitionno'); ?&gt;

</div>

Please help me how can I get store procedure data into my form … Thanks in advcanced