How to write insert via QueryBuilder >_

Question

Yii

I am trying to make a banal insert according to the documentation
Here is my piece of code

$query = \Yii::$app->db->queryBuilder;
$query->insert('poll_vote', [
      'choice_id' => $choiceID,
      'poll_id' => $pollID,
      'user_id' => empty($userID) ? NULL : $userID,
      'ip' => $ip,
      'timestamp' => time()
    ], $params);

I can't figure out what should be in the $params variable.
Please tell me how to correctly compose a banal insert...

Answer 1

the content received from the user must be bound using prepared statements

$query = new Query();
    $query->createCommand()->insert(self::tableName(),[
      'choice_id' => ':choiceID'
...], [
':choiceID' => $choiceID
])->execute();

Answer 2

Basically, this is what I did.

$query = new Query();
    $query->createCommand()->insert(self::tableName(),[
      'choice_id' => $choiceID,
      'poll_id' => $pollID,
      'user_id' => empty($userID) ? NULL : $userID,
      'ip_address' => $ip,
      'timestamp' => time()])->execute();