Codeigniter Transactions

by

Using transactions means support databases to insert data safely. So in Codeigniter we write every database related functions in the Model not in Controller.. And in your second code(which is not working)you have pointed model on there.(utils). So simple I’m sure this will not work. Because its not a insert data with model and Controller parallel. Transaction should be coded in the Model(I will write in Model in my answer).

Load this stuffs as well

  1. Database Library
  2. Model Class
  3. URL helper
  4. Session

Assumptions

In your code you have used $data and $test as array. So i assume there is two array for inserting and updating data.

Your data sets

$data = array(
   'title' => 'My title' ,
   'name' => 'My Name' ,
   'date' => 'My date'
);

$id = 007;
$test = array(
   'title' => $title,
   'name' => $name,
   'date' => $date
);

Your Code

$this->db->trans_start(); # Starting Transaction
$this->db->trans_strict(FALSE); # See Note 01. If you wish can remove as well 

$this->db->insert('table_name', $data); # Inserting data

# Updating data
$this->db->where('id', $id);
$this->db->update('table_name', $test); 

$this->db->trans_complete(); # Completing transaction

/*Optional*/

if ($this->db->trans_status() === FALSE) {
    # Something went wrong.
    $this->db->trans_rollback();
    return FALSE;
} 
else {
    # Everything is Perfect. 
    # Committing data to the database.
    $this->db->trans_commit();
    return TRUE;
}

Notes

  1. By default Codeigniter runs all transactions in Strict Mode. When
    strict mode is enabled, if you are running multiple groups of transactions, if one group fails all groups will be rolled back. If
    strict mode is disabled    , each group is treated
    independently    , meaning a failure of one group will not affect
    any others    .

More Related Contents:

  1. how to select only one value sql
  2. How to create codeigniter dynamic menu from single table
  3. Comma separated numeric values – PHP CodeIgniter
  4. CodeIgniter – foreach loop
  5. PHP – Change value y,n in database [closed]
  6. PHP + MySQL transactions examples
  7. How to insert multiple rows from array using CodeIgniter framework?
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  10. Find total number of results in mySQL query with offset+limit
  11. How can I Use Prepared Statements in CodeIgniter
  12. Grouping WHERE clauses in Codeigniter
  13. Understanding pdo mysql transactions
  14. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  15. How to create Codeigniter language files from database?
  16. Trying to get property of non-object – CodeIgniter
  17. Codeigniter echoing [::1] instead of localhost
  18. How do detect that transaction has already been started?
  19. Inserting NOW() into Database with CodeIgniter’s Active Record
  20. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  21. PHP prepared statements and transactions in a loop [duplicate]
  22. Escaping SQL queries in Codeigniter
  23. Project Links do not work on Wamp Server
  24. MySQL – count total number of rows in php
  25. check if the query results empty row mysqli [duplicate]
  26. double results in my array ( mysql_fetch_array )
  27. How best to get someone’s ‘rank’ from a scores table with php and mysql without looping
  28. How to get rid of MySQL error ‘Prepared statement needs to be re-prepared’
  29. Codeigniter assets folder best practice
  30. Getting data from post array in CodeIgniter

Leave a Comment