I know this kind of question has been asked on different topics and I've read so many but none seem to have what I want. If you are familiar with CodeIgniter you probably know you need a method with parameters in your model to insert records to a database from a controller. In my case there are too many records I want to insert and the parameters seems like they've exceed required limits for parameters, I doubt if there's any but regardless it looks like a dirty work and I want it looking better. If you got any suggestion or improvement here's the code below. I would so much appreciate. Thank you.
public function create_cv($created_by, $fullname = '', $mobile = '', $email = '', $summary = '', $career_obj = '', $personal_skill = '',$experience1 = '', $position1 = '',$duration1 = '', $experience2 = '', $position2 = '', $duration2 = '', $experience3 = '', $position3 = '', $duration3 = '', $degree_course1 = '', $institution1 = '', $degree_duration1 = '', $degree_course2 = '', $institution2 = '',$degree_duration2 = '', $degree_course3 = '', $institution3 = '',$degree_duration3 = '', $skils = '', $linguistic_skills = '', $certificates = '', $hobbies = '', $refrees = '') {
$data = array(
'created_by' => $created_by,
'fullname' => $fullname,
'mobile' => $mobile,
'email' => $email,
'summary' => $summary,
'career_obj' => $career_obj,
'perosnal_skill' => $personal_skill,
'experience1' => $experience1,
'position1' => $position1,
'duration1' => $duration1,
'experience2' => $experience2,
'position2' => $position2,
'duration2' => $duration2,
'experience3' => $experience3,
'position3' => $position3,
'duration3' => $duration3,
'degree_course1' => $degree_course1,
'institution1' => $institution1,
'degree_duration1' => $degree_duration1,
'degree_course2' => $degree_course2,
'institution2' => $institution2,
'degree_duration2' => $degree_duration2,
'degree_course3' => $degree_course3,
'institution3' => $institution3,
'degree_duration3' => $degree_duration3,
'skills' => $skils,
'linguistic_skills' => $linguistic_skills,
'certificates' => $certificates,
'hobbies' => $hobbies,
'refrees' => $refrees,
);
$this->db->insert('users', $data);
}
Thanks again in advance as I hope to get positive results. Thanks again :)
UPDATE: I added this $this->db->insert('users', $data);
to the code snippet
UPDATE: Thanks guys it got it handled now. Your answers helped a lot.