How to pass parameter from a controller by db query in Yii

Question

Here is my controller::

public function actionCreateGRN($id){
            $model = new VwPurchaseordhd;
            $sql = sprintf("call sp_im_CreateGRN(%s,'%s')",
                   $id,
                   $insertuser = Yii::app()->user->name
                );
           $command  = Yii::app()->db->createCommand($sql);
           $result = $command->queryAll();

         $this->redirect(array('grndetail/create', 'id'=>$model->id, 'pp_purordnum'=>$pp_purordnum, ));
    }

In $result I have an array:: Array ( [0] => Array ( [pp_purordnum] => PO1400000291 [vGrnNumber] => GR14007320 ) )

I need to pass array data via "redirect" to another controller/function. It's showing ERROR undefined pp_purordnum. I am missing something.

Could you please help me to pass parameter what I have in array ? Thanks in Advance.

SOLVED

Controller

        public function actionCreateGRN($id){
            $sql = sprintf("call sp_im_CreateGRN(%s,'%s')",
                   $id,
                   $insertuser = Yii::app()->user->name
                );
           $command  = Yii::app()->db->createCommand($sql);
           $result = $command->queryRow();

           $pp_purordnum = $result['pp_purordnum'];
           $vGrnNumber = $result['vGrnNumber'];

         $this->redirect(array('grndetail/create', 'pp_purordnum'=>$pp_purordnum, 'vGrnNumber'=>$vGrnNumber, ));
    }

Hett · Accepted Answer · 2014-01-05 09:29:03Z

2

   $sql = "call sp_im_CreateGRN(:id, :user_name)"
   $command  = Yii::app()->db->createCommand($sql);
   $result = $command->queryAll(true, array(
       ':id'=>$id, 
       ':user_name'=>Yii::app()->user->name,
   ));

answered Jan 5, 2014 at 9:29

Hett

3,8652 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Selim Reza Over a year ago

I found the solutions. and updated the code below the question.. thanks for your answer. I will need your code. It's really great ... please vote this question

Collectives™ on Stack Overflow

How to pass parameter from a controller by db query in Yii

SOLVED

Controller

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

SOLVED

Controller

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related