Yii Insert data query builder
Yii Insert data : Yii Query builder is used to insert data in yii. Yii::app()->db->createCommand()->insert($tableName, $dataArray) is used to insert data. It accepts two parameters first table name and second the array data which needs to be inserted.
Syntax : Yii Insert data query builder
Below is yii insert query example.
Yii::app()->db->createCommand()->insert($tableName,$dataArray );
Where $tableName is table name in which you want to insert data. $dataArray is associate array containing the data and column name.
Yii Insert data query builder example
$tableName = "Users"; $dataArray = array( "name" => "Kelly", "email" => "keylly@eample.com", "country" => "Spain" ); Yii::app()->db->createCommand()->insert($tableName,$dataArray );
The above example will produce the following output.
insert into users (name,email,country) values(“Kelly”,”kelly@example.com,”Spain”)
Advertisements
