Total Pageviews

Thursday, July 17, 2014

Insert Update with createCommand in yii

public function assignVehicle($driver_id=null,$vehicle_id=null)
{
$sql = "UPDATE `drivers` SET `vehical_id`=$vehicle_id WHERE id=:driver_id";

$parameters = array(":driver_id"=>$driver_id);

Yii::app()->db->createCommand($sql)->execute($parameters);
}

public function insertCharges($area_id=null,$charge=null){


$sql = "insert into delivery_charge (`area_id`,`charge`) values (:area_id,:charge)";

$parameters = array(":area_id"=>$area_id,":charge"=>$charge);

Yii::app()->db->createCommand($sql)->execute($parameters);


}

No comments:

Post a Comment