Update form data into database

Before $this->load->view('formsuccess'); insert this piece of code:

PHP Code:

$data = array(
   'certno' => $this->input->post('certno'),
   'location' => $this->input->post('location'),
   'workdate' => $this->input->post('workdate'),
   'dateofreceipt' => $this->input->post('dateofreceipt'),    
   'customername' => $this->input->post('customername'), 
);
$this->db->insert('mytablename', $data); 


Alternatively you can create a model that stores the information, but that won't make your code much shorter.
If you need to use the same database actions repeatedly in different functions in your controller (or different controllers), then consider using a model.