CodeIgniter Forums

Full Version: CI's mysql transction question
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum


$result_sub_payment = $this->payforgame_model->sub_payment($username,$payment);
$privatekey = '[email protected]';
$base64_username = base64_encode($username);
//md5加密串, accName(base64编码后)+creditNum+orderId+约定码
$digit = md5($base64_username.$point.$orderId.$privatekey);
$result_payforgame_tmp = $this->payforgame_model->payforgame_tmp($username,$gameid,$areaid,$payment,$orderId,$digit);


I use CI's transaction as above.

because the SQL query in my model,so I am not sure the transction will be run?

El Forum

you can start and stop your transaction as you describe no problems (make sure you turn db_debug to FALSE or transactions do not work). The only problem you will find is when you call a transaction within a transaction, e.g. if payforgame_tmp had a trans_start and trans_complete the transaction would not work.

Even though the transaction will work in the above code, I personally think it makes more sense to engineer your code so that the transactions are left in the model (you can call functions that are in the same model).

El Forum