Stored procedures in yii2

[ElizaArriaga93]

hello, I do not have much experience with yii2 but I need an example of how to implement a stored procedure from my database in mysql since I have already seen several examples but I want to create it so that at the moment of clicking on the save button it executes

[samdark (Alexander Makarov)]

Yii and Mysql Stored Procedures

Hi, You can call the Procedure using the below function public function actionView($param1, $param2) { // sql query for calling the procedure $sql = "CALL get_country_and_states(:params_1, :params_2)"; // passing the params into to the sql query $params = [':pamams_1'=>$pamam1, ':pamams_2'=>$pamam2]; // execute the sql command return Yii::$app->db->createCommand($sql, $params)->queryAll(); } using the same function(by sending the required update fields) you ca…