+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: How to run Transactions in controller? (/showthread.php?tid=78970)
How to run Transactions in controller? - webdevron - 04-02-2021
I need to use transactions in my controller. My controller method is given below. This is not working and should not be as far as I understand. So, what could be the solution? Again, is it good practice to use transactions in the controller?
Thank you in advance.
PHP Code:
public function add_payment(){
if($this->request->getMethod() != 'post') return redirect()->back();
if(!$this->validate('addOrderPayment')) session()->setFlashdata('error', $this->validator->listErrors());
else{
$oid = $this->request->getPost('oid');
if($this->request->getPost('odrTkn') === md5(session('token').$oid)){
$order = (new ODR(['gid'=> esc($oid)]))->getOrder();
$data = [
'amount'=> $this->request->getPost('amount')
];
$db = \Config\Database::connect();
$db->transStart();
service('transaction')->addTrx($data);
service('order')->balanceDue($oid, $data['amount']);
$db->transComplete();
if ($db->transStatus() === FALSE){
$this->db->transRollback();
session()->setFlashdata('error', 'Something went wrong!!');
}
else{
$db->transCommit();
session()->setFlashdata('success', 'Payment added successfully!!');
}
}else session()->setFlashdata('error', 'Invalid request!!');
}
return redirect()->back();
}
Quote:The output is always the same:
Payment added successfully!!
Thank you in advance.
RE: How to run Transactions in controller? - InsiteFX - 04-02-2021
Transactions should be handled in the Model that's where your business logic should be.
Initializing the database and accessing it in the controller is breaking the mvc logic.
Make methods in your model for this then call that method from the controller.
RE: How to run Transactions in controller? - yahyaerturan - 04-02-2021
(04-02-2021, 06:01 AM)InsiteFX Wrote: Transactions should be handled in the Model that's where your business logic should be.
Initializing the database and accessing it in the controller is breaking the mvc logic.
Make methods in your model for this then call that method from the controller.
I am not sure if it is the best practice but if not I want to learn the correct way
I think it should be handled in controller for the following reasons:
- In a controller endpoint it can be used methods from different models which we want all to be in same transaction. For example, adding new tags to article when adding a new article, or adding new product tags when adding a new product.
- Sending response from API endpoint if transaction fails.
Here is an example how I use it:
PHP Code:
/**
* @method POST
* @url /api/{version}/company
*/
public function create(): ResponseInterface
{
$createData = $this->request->getJSON();
$this->db->transStart();
$tagIds = $this->handleIndustries($createData); // Adding new industries
$isSaved = $this->model->save($createData);
if (false === $isSaved) {
return $this->failValidation($this->model->errors(), Domain::COMPANY);
}
$insertID = $this->model->getInsertID();
if (false === $qB->addOrUpdateRelations($tagIds, $insertID)) {
return $this->failPersistence(
'One or more relation(s) could not be saved.',
Domain::COMPANY_INDUSTRY);
}
$this->db->transComplete();
if (false === $this->db->transStatus()) {
return $this->failPersistence(
'An error occurred in transaction.',
Domain::COMPANY
);
}
$data = $this->model->find($insertID);
return $this->respondCreated($data);
}
If there is a better way, I'd like to learn..
RE: How to run Transactions in controller? - mlurie - 04-06-2021
Add this to your BaseController in the "Preload" section of the initController method:
PHP Code:
$this->db = \Config\Database::connect(); //Load database connection
You should then be able to use transactions in any Controller like this:
PHP Code:
$this->db->transStart(); //Begin database transaction
$this->db->transComplete(); //Complete database transaction
RE: How to run Transactions in controller? - mlurie - 01-09-2023
(04-06-2021, 09:44 AM)mlurie Wrote: Add this to your BaseController in the "Preload" section of the initController method:
PHP Code:$this->db = \Config\Database::connect(); //Load database connection
You should then be able to use transactions in any Controller like this:
PHP Code:$this->db->transStart(); //Begin database transaction
$this->db->transComplete(); //Complete database transaction
Creating the object in the BaseController has been deprecated. Use this instead in your model or controller:
PHP Code:
$db = \Config\Database::connect(); //Load database connection
$db->transStart(); //Begin database transaction
$db->transComplete(); //Complete database transaction