Codeigniter insert array into database

Question

I am currently making a registration form where in you could register individually or by many I need a way how to make the multiple register work i cant add the input into db i get an array to string conversion error i still dont have the model for this

my code is controller

public function registerbatch(){ for ($i = 0; $i < count($this->input->post('surname','firstname','age','school','course','email')); $i++) { $this->form_validation->set_rules("surname[$i]", "surname[$i]", "required"); $this->form_validation->set_rules("firstname[$i]", "firstname[$i]", "required"); $this->form_validation->set_rules("age[$i]", "Age[$i]", "required"); $this->form_validation->set_rules("school[$i]", "School[$i]", "required"); $this->form_validation->set_rules("course[$i]", "Course[$i]", "required"); $this->form_validation->set_rules("email[$i]", "Email[$i]", "required"); } if ($this->form_validation->run() == TRUE) { $reg_dat = array( 'surname' => $this->input->post('surname'), 'name' => $this->input->post('firstname'), 'age' => $this->input->post('age'), 'school' => $this->input->post('school'), 'course' => ($this->input->post('course')), 'email' => ($this->input->post('email')), ); $this->user_model->add_user($reg_dat); $this->load->view('user/home_view'); } else { $this->load->view('user/batch_register'); }

view:

<html> <head> </head> <body> <form class="form" action="<?php echo base_url() . 'user/registerbatch'; ?>" method="post" class="form-horizontal" role="form"> <?php for ($i = 0; $i < $num; $i++): ?> <br> Surname: <input type="text" name="surname[]"> <br> Name: <input type="text" name="firstname[]"> <br> Age:<input type ="int" name ="age[]"> <br> School: <input type="text" readonly value="<?= $school ?>" name="school[]"> <br> Course:<input type ="text" name ="course[]"> <br> Email:<input type ="text" name ="email[]"> <br> <br> <?php endfor ?> <button type="submit" class="btn btn-success">Register</button> </body> </html>

print_r( $reg_dat ); check the result and share add_user() coding — msvairam
– msvairam, Commented Jan 27, 2016 at 12:20
this is my model public function add_batchuser($reg_dat) { $this->db->set('date_registered', 'NOW()', FALSE); $this->db->insert('user', $reg_dat); } — Christian
– Christian, Commented Jan 28, 2016 at 1:18
and the return value when printing reg_dat i tried to run this and print_reg Array ( [surname] => Array ( [0] => surnametest [1] => testsurname ) [name] => Array ( [0] => nametest [1] => testname ) [age] => Array ( [0] => 20 [1] => 30 ) [school] => Array ( [0] => testschool [1] => testschool ) [course] => Array ( [0] => CS [1] => EE ) [email] => Array ( [0] => [email protected] [1] => [email protected] ) ) — Christian
– Christian, Commented Jan 28, 2016 at 1:19

msvairam · Accepted Answer · 2016-01-28 07:20:48Z

4

Try this below coding ....

 if ($this->form_validation->run() == TRUE) { extract($_POST); foreach($surname as $key=>$value) { $reg_dat = array( 'surname' => $value, 'name' => $firstname[$key], 'age' => $age[$key], 'school' => $school[$key], 'course' => $course[$key], 'email' => $email[$key], ); $this->user_model->add_user($reg_dat); } } $this->load->view('user/home_view');

answered Jan 28, 2016 at 7:20

msvairam

8725 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Christian Over a year ago

i just noticed this when I am inserting into database it inserts the data twice resulting into a duplticate in entry any ideas?

msvairam Over a year ago

Share your add_user() function in your question and check get value is twice from view form print_r($_POST);

Christian Over a year ago

oh wait nevermind i just had an unclosed bracket in my for loop thanks !

David · Accepted Answer · 2016-01-27 16:34:26Z

Seems that your Post can be a multidimensional array. I think the best way to solve your problem is to foreach that post and insert every row

 //your controller if ($this->form_validation->run() == TRUE) { $reg_dat_multi = $this->input->post(); foreach ($reg_dat_multi as $reg_dat) { $this->user_model->add_user($reg_dat); } );

you didn't show your model but let's think that is something like this

 //your model function add_user($reg_dat){ if ( $this->db->insert('table', $reg_dat) ){ return true; } return false; }

hope that helps

i tried this but im getting a database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0, 1) VALUES (NOW(), 'snamtest', 'testsname')' at line 1 INSERT INTO user ( 0, 1) VALUES ( 'snamtest', 'testsname')

Collectives™ on Stack Overflow

Codeigniter insert array into database

2 Answers 2

3 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Related