Tag Archives: Yii createCommand

Yii createCommand Delete

Functions function delete($table, $conditions=”, $params=array()) The delete() method builds and executes a DELETE SQL statement.’$table’ is a table name of delete from.’$conditions’ and ‘$params’ is like where condition of delete statement Sample <?php $user=Yii::app()->db->createCommand() ->delete(‘tbl_user’, ‘user_id=:id’, array(‘:id’=>2)); ?> OUTPUT SQL DELETE FROM `tbl_user` WHERE user_id=:id

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 […]

Yii createCommand queryAll

I posted here examples of createCommand Query with properties. createCommand Properties are distinct, from, group, having, join, limit, offset, params, pdoStatement, select and where. CDbCommand represents an SQL statement to execute against a database. bindParam used to bind a php variable to parameter in SQL query. bindValue is used to bind a value to and […]

Yii createCommand Update

Functions function update($table, $columns, $conditions=”, $params=array()) Sample The update() method builds and executes an UPDATE SQL statement. <?php $user=Yii::app()->db->createCommand() ->update(‘tbl_user’, array( ‘username’=>’bsourcecode’, ), ‘user_id=:id’, array(‘:id’=>1)); ?> OUTPUT SQL UPDATE `tbl_user` SET `username`=:username WHERE user_id=:id