Insert in yii2 from different controller

Question

I am tring to insert data in a table.

trying like this but it`s not working.

$sql = $queryBuilder->insert(' HRMS_candidateEducation', [
                 'HRMS_candidateEducationCandidateID' => $candidateID,
                 'HRMS_candidateEducationDegree' => $data['Degree'.$i],
                 'HRMS_candidateEducationUniversity' => $data['University'.$i],
                 'HRMS_candidateEducationCollege' => $data['College'.$i],
                 'HRMS_candidateEducationYear' => $data['Specilization'.$i], 
                 'HRMS_candidateEducationSpecilization' => $data['Specilization'.$i],
                ], $params);

What is incorrect?

using

use yii\db\QueryBuilder;
use app\models\CandidateEducation;

Why you do not use save method of CandidateEducation's AR class? — Sergey
– Sergey, Commented Oct 13, 2015 at 7:50

ScaisEdge · Accepted Answer · 2015-10-13 05:51:31Z

4

This function seem only create the SQL statement see doc

insert() Creates an INSERT command

for executing the command i think you shoul try this way

Yii::$app->db->createCommand()->
 insert(' HRMS_candidateEducation', [
             'HRMS_candidateEducationCandidateID' => $candidateID,
             'HRMS_candidateEducationDegree' => $data['Degree'.$i],
             'HRMS_candidateEducationUniversity' => $data['University'.$i],
             'HRMS_candidateEducationCollege' => $data['College'.$i],
             'HRMS_candidateEducationYear' => $data['Specilization'.$i], 
             'HRMS_candidateEducationSpecilization' => $data['Specilization'.$i],
            ], $params)->
 execute();

answered Oct 13, 2015 at 5:51

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

Comments

Piyush · Accepted Answer · 2015-10-14 10:48:27Z

0

I found another solution to my question.

This is what i did. by following this link.

public function actionCreate()
{
  $a=new A;
  $b=new B;
 if(isset($_POST['A'], $_POST['B']))
{
    // populate input data to $a and $b
    $a->attributes=$_POST['A'];
    $b->attributes=$_POST['B'];

    // validate BOTH $a and $b
    $valid=$a->validate();
    $valid=$b->validate() && $valid;

    if($valid)
    {
        // use false parameter to disable validation
        $a->save(false);
        $b->save(false);
        // ...redirect to another page
    }
}

$this->render('create', array(
    'a'=>$a,
    'b'=>$b,
));

}

answered Oct 14, 2015 at 10:48

Piyush

4,0079 gold badges41 silver badges70 bronze badges

Collectives™ on Stack Overflow

Insert in yii2 from different controller

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related