Yii Function : createMultipleInsertCommand

Yii 1.1.14

$builder = Yii::app()->db->schema->commandBuilder; $command=$builder->createMultipleInsertCommand('tbl_accjvs', array( array('MemberID'=>$MemberID,'MINOR_CODE'=>$minorCode,'JVACC_CODE'=>$jvcrCode,'JVDATE'=>$jvDate,'JVNO'=>'','JVITEM'=>$jvItem,'JVAMT'=>$jvAmt, 'JVCR'=>'Y', 'JVDR'=>'N', 'JVREMARK'=>$jvRemark,'JVPOSTDATE'=>$jvPostDate,'JVUPDATE'=>$jvPostDate), array('MemberID'=>$MemberID,'MINOR_CODE'=>$minorCode,'JVACC_CODE'=>$jvdrCode,'JVDATE'=>$jvDate,'JVNO'=>'','JVITEM'=>$jvItem,'JVAMT'=>$jvAmt, 'JVCR'=>'N', 'JVDR'=>'Y', 'JVREMARK'=>$jvRemark,'JVPOSTDATE'=>$jvPostDate,'JVUPDATE'=>$jvPostDate), )); $command->execute();