batch insert prevent cyclic insert codeigniter

Question

Hi I faced a problem when I insert some value from dynamic adding table then it insert with cycle.

But I want to insert all my arrays at once how it possible.

This is my Model:

$id=$this->input->post('id');
$rank=$this->input->post('rank');
$name=$this->input->post('name');
$mob=$this->input->post('mob');
$count = count($this->input->post('id'));

$data = array();

for($i=0, $i>$count; $i++) {

    $data[] = array(
    'id'=> null,
    'pers_no' => $id[$i],
    'rank' => $rank[$i],
    'name' => $name[$i],
    'mobile' => $mob[$i],
    'vendor_id' => $vendor[$i],
    );

    $result = $this->db->insert_batch('workers_tbl', $data);
}

Ankur Radadiya · Answer 1 · 2017-03-11T06:30:55.280

$id=$this->input->post('id');
$rank=$this->input->post('rank');
$name=$this->input->post('name');
$mob=$this->input->post('mob');
$count = count($this->input->post('id'));

$data = array();

for($i=0, $i>$count; $i++) {

$data[] = array(
'id'=> null,
'pers_no' => $id[$i],
'rank' => $rank[$i],
'name' => $name[$i],
'mobile' => $mob[$i],
'vendor_id' => $vendor[$i],
);}

$result = $this->db->insert_batch('workers_tbl', $data);

Please try this may be work for you....

Put your insert_batch query outside the loop completed. i have only once change and remain same..

score 1 · Answer 2 · edited May 23 '17 at 12:17

1

You are inserting one record, this isn't called batch insertion. Just create an array and insert the record. In your model function

public function insert_record($data)
{
   $record=array(
     'pers_no' => $data['id'],
     'rank' => $data['rank'],
     'name' => $data['name'],
     'mobile' => $data['mobile'],
   );
   $this->db->insert('workers_tbl',$record);
}

You can secure your input by doing

$this->db->escape($data); // before creating the record array

From your controller just call this function once you store the post in some variable like

public function insert_worker()
{
   if($_POST)
   {
     $data=$this->input->post();
     $this->model_name->insert_record($data);
   }
}

if you want to create one huge array of multiple records . Read this

edited May 23 '17 at 12:17

Community

1
1

answered Mar 11 '17 at 05:11

Mudassar Khani

1,469
1
20
39

create array of arrays, read the link of the thread I mentioned – Mudassar Khani Mar 11 '17 at 05:33
if its a huge file like 5k+ records you might wanna set max_exec time in php.in or time_out . There are some default values which stops the server from long scripts executions – Mudassar Khani Mar 11 '17 at 05:35

score 0 · Answer 3 · answered Oct 04 '18 at 17:51

$id=$this->input->post('id');
$rank=$this->input->post('rank');
$name=$this->input->post('name');
$mob=$this->input->post('mob');
$count = count($this->input->post('id'));

$data = array();

for($i=0, $i>$count; $i++) {

    $data[] = array(
    'pers_no' => $id[$i],
    'rank' => $rank[$i],
    'name' => $name[$i],
    'mobile' => $mob[$i],
    'vendor_id' => $vendor[$i],
    );


}
$result = $this->db->insert_batch('workers_tbl', $data);

Could you explain your answer? How does it solve the problem? — slfan, Oct 04 '18 at 18:18

GYaN · Answer 4 · 2017-03-14T05:09:17.233

-1

Try this...

$count = $_POST['id'];

for($i=0, $i < $count; $i++){

$data[] = array(
    'pers_no' => $id[$i],
    'rank' => $rank[$i],
    'name' => $name[$i],
    'mobile' => $mob[$i],
    'vendor_id' => $vendor[$i]

);

}

$this->db->insert('workers_tbl',$data);

This may work. Thanks.

edited Mar 14 '17 at 05:09

answered Mar 11 '17 at 06:03

GYaN

2,327
4
19
39

batch insert prevent cyclic insert codeigniter

4 Answers4