How to send multiple values to mysql tables in yii

Question

I'm new to PHP and Yii framework. how to insert multiple questions in database

This is Form view code

<?php echo $form->textField($model,'questions',array('id'=>"content_#index#_question textBox")); ?>

<?php echo $form->textField($model,'questions',array('id'=>"content_#index#_question textBox")); ?>

Here is My Controller

public function actionAdd_quick()

{

    $model=new Question;
    $answers=new Answers;

    if(isset($_POST['Question'],$_POST['Answers']))
    {
        $model->attributes=$_POST['Question'];
        $answers->attributes=$_POST['Answers'];
                foreach ($model['questions'] as $value) {
                    $model->questions = $value;

                }
                $model->save();

            Yii::app()->user->setFlash('add_quick','Thank you for ');
            $this->refresh();

    }
    $this->render('add_quick',array('model'=>$model,'answers'=>$answers));
}

actually my process is to create multiple questions and answers ,but now getting error like

"Invalid argument supplied for foreach()" by using my code and how to send multiple questions and answers to mysql tables...

What you want to do ? Insert multiple answers to a question. Or insert question and answer pairs — Claude Janz
– Claude Janz, Commented Oct 3, 2013 at 13:11
i have to insert both multiple Questions and answers,but here i mentioned only for question — Aravind Balaji
– Aravind Balaji, Commented Oct 4, 2013 at 6:08

Liauchuk Ivan · Accepted Answer · 2013-10-07 07:48:27Z

2

change this

foreach ($model['questions'] as $value) {
                $model->questions = $value;

            }
            $model->save();

on this

foreach ($model['questions'] as $value) {
                $model->questions = $value;
                $model->save();
            }

answered Oct 7, 2013 at 7:48

Liauchuk Ivan

2,0233 gold badges14 silver badges22 bronze badges

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

Comments

Liauchuk Ivan · Accepted Answer · 2013-10-04 09:42:23Z

0

Try this

 <?php echo $form->textField($model,'questions[]',array('id'=>"content_#index#_question textBox"));  ?>

answered Oct 4, 2013 at 9:42

Liauchuk Ivan

2,0233 gold badges14 silver badges22 bronze badges

1 Comment

Aravind Balaji Over a year ago

Hi thanks for your response,i did change as you said but now single row only inserted...

Collectives™ on Stack Overflow

How to send multiple values to mysql tables in yii

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related