YII2查询修改

model 层   联查

$con = Yii::$app->db;
$re = $con->createCommand("select * from ads LEFT JOIN nav on nav.id=ads.nav_id")->queryAll();
return $re;

 

model层    修改

$con = Yii::$app->db;
return $con->createCommand("update phone set ".$d."= '".$v."' where id = 1")->execute();

查看sql语句

var_dump($query->createCommand()->getRawSql());die();