sql - 从不同的 Controller 插入 yii2

Question

我想在表格中插入数据。

像这样尝试，但它不起作用。

$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);

哪里不对？

使用

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

Answer 1

这个函数好像只创建SQL语句see doc

insert() Creates an INSERT command

为了执行命令，我认为你应该尝试这种方式

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();