Github · Twitter · Facebook · Guide · Class Reference · Guide 2.0 · API 2.0 · Wiki · Extensions · Live Chat
search

Yii Framework Forum: Execute Mysql Stored Procedure In Yii Applications. - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Execute Mysql Stored Procedure In Yii Applications. You can use simple following statement in controller to execute proc. Rate Topic: -----

#1 User is offline   Rahul Shevare 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 5
  • Joined: 16-March 14

Posted 04 July 2014 - 04:47 AM

$connection = Yii::app()->db;
$command = $connection->createCommand("CALL sp_generate_payroll('$doc_date',$hrid,$clientid)");
$command->execute();


This statement will execute MySQL stored procedure by YII application. Tested successfully.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users