All Codeigniter

README.md

All Codeigniter scripts

Database.md

Transaction

// controller code
$this->db->trans_start();
$this->maincategory_model->first_function($maincategoryData);
$this->market_model->second_function($marketData); 
$this->db->trans_complete();
if ($this->db->trans_status() === FALSE) {
    throw error
        `enter code here`
} 

// Maincategory_model code
public function first_function($maincategoryData)
{
    return $this->db->insert_batch('maincategory_users_mapping', $maincategoryData);
}

// Market_model code
public function second_function($marketData)
{
    return $this->db->insert_batch('market_users_mapping', $marketData);
}