Yii2 insert query with bindparam for sql injection

Question

I want use but not work please help me.

$sql = Yii::$app->db("INSERT INTO posts(name) VALUES(:name)");
$sql->bindValues([':name' => 'John']);
$sql->execute();

Answer 1

try create command exceute

    Yii::$app->db->createCommand('INSERT INTO posts(name) VALUES(:name)')
          ->bindValues([':name' => 'John'])->execute();