"codeigniter clone data from table and update it" Code Answer

you can do like this:

$query = $this->db->where('payment_id', $payment_id)->get('payment');
foreach ($query->result() as $row) {      
      $this->db->where('payment_id', $row->payment_id)->update('paymenthistory', $row); // to update existing record
      //$this->db->insert('paymenthistory',$row); // to insert new record
}

By Prabhakar Undurthi on July 12 2022