Detailed explanation of the use of bindParam and bindValue in Yii2

This time I will bring you a detailed explanation of the use of bindParam and bindValue in Yii2. What are the precautions for using bindParam and bindValue in Yii2. Here are practical cases, let’s take a look.

bindParam() and bindValue() are very similar. The only difference is that the former uses a PHP variablebind parameter, while the latter uses a value. For those parameters with large data blocks in memory, for performance reasons, the former should be used first.

Query a piece of data based on id and filter the id:

$id = 1;
$result = Yii::$app->db->createCommand("select * from product where id=:id")->bindParam(":id",$id,\PDO::PARAM_INT)->queryAll();
$result = Yii::$app->db->createCommand("select * from product where id=:id")->bindParam(":id",$id,\PDO::PARAM_STR)->queryAll();

UpdateA piece of data:

$id = 1;
$name = 'xiaoming';
$result = Yii::$app->db->createCommand("update product set name=:name where id=:id")->bindParam(':id',$id,\PDO::PARAM_INT)->bindParam(':name',$name,\PDO::PARAM_INT)->execute();

The following writing method will report an error

$result = Yii::$app->db->createCommand()->delete('product',['name'=>':value'],'id=:id')->bindValue(':id',1,\PDO::PARAM_INT)->bindParam(':value',$user,\PDO::PARAM_INT)->execute();

I believe you have mastered the method after reading the case in this article, more Please pay attention to other related articles on the php Chinese website!

Recommended reading:

php retains key value + merged array detailed explanation

How to remove duplicates in a two-dimensional array value

The above is the detailed content of Detailed explanation of the use of bindParam and bindValue in Yii2. For more information, please follow other related articles on the PHP Chinese website!