Yii createCommand Insert

Functions


function insert($table, $columns)
The insert() method builds and executes an INSERT SQL statement.

Sample 1

 
<?php
$user=Yii::app()->db->createCommand()
->insert('tbl_user',
            array('username'=>'bsourcecode','usertype'=>1,'password'=>'hai'));
?>

OUTPUT SQL

 INSERT INTO `tbl_user` (`username`, `usertype`,'password') 
        VALUES (:username,:usertype, :password)

Sample 2

 
<?php
$name='india';
$isactive=1;
$command= Yii::app()->db->createCommand(
        "INSERT INTO regionmaster (`regionname`,`isactive`)
                VALUES (:name,:isactive)");
$command->bindValue(':name', $name);
$command->bindValue(':isactive', $isactive);
$sql_result = $command->execute();
?>

OUTPUT SQL

INSERT INTO regionmaster (`regionname`,`isactive`)
                VALUES (:name,:isactive)