Codeigniter Insert Batch array

Question

I am Inserting a multiple form input data in to database using Codeigniter. I have this post input array:

 Array
(
 [subject_id] => Array
    (
        [0] => 1
        [1] => 1
    )

[question] => Array

    (
        [0] => test
        [1] => test2
    )

[option1] => Array
    (
        [0] => test
        [1] => test2
    ) )

I don't get that how do i convert this array to insert How to insert this array using Insert batch.

$this->db->insert_batch('mytable', $data);

This is the form code which i use for posting the data:

<form method="post">
    <input type="text" name="subject_id[]" >
    <input type="text" name="question[]" >
    <input type="text" name="record[]" >

    // Down side Part is appended when user want to add more question

    <input type="text" name="subject_id[]" >
    <input type="text" name="question[]" >
    <input type="text" name="record[]" >

    <input type="submit" name="submit" >
</form>

Below is the Array format which i want.

$data = array(
    array(
        'subject_id' => 'My title' ,
        'question' => 'My Name' ,
        'option1' => 'My date'
        ),
    array(
        'subject_id' => 'Another title' ,
        'question' => 'Another Name' ,
        'option1' => 'Another date'
        )
    );

post your code in your question regarding how do you get this array? — dhruv jadia
– dhruv jadia, Commented Mar 27, 2017 at 6:45
I have updated the question again sir & added what the result array i need. @dhruvjadia — always-a-learner
– always-a-learner, Commented Mar 27, 2017 at 15:43

MaxiGui · Accepted Answer · 2020-12-14 10:14:23Z

5

<?php
    $i = 0;
    foreach($subject_id as $key=>$val)
    {
          $data[$i]['subject_id'] = $val;
          $data[$i]['question'] = $question[$key];
          $data[$i]['option1'] = $record[$key];
          $i++;
    }
    $this->db->insert_batch('mytable', $data);

?>

edited Dec 14, 2020 at 10:14

MaxiGui

6,3784 gold badges18 silver badges36 bronze badges

answered Mar 27, 2017 at 7:40

dhruv jadia

1,6802 gold badges15 silver badges28 bronze badges

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

Comments

Hikmat Sijapati · Accepted Answer · 2017-03-26 17:03:51Z

2

Try like below:Assume $records is an array that you want to insert.

foreach ($records as $record) 
{

    for ($i=0; $i < count($record); $i++) 
    {   
    $data[$i]['subject_id'] = $record['subject_id'][$i];
    $data[$i]['question'] = $record['question'][$i]
    $data[$i]['option1'] = $record['option1'][$i];
    }

}

Then

$this->db->insert_batch('mytable', $data);

answered Mar 26, 2017 at 17:03

Hikmat Sijapati

6,9691 gold badge11 silver badges19 bronze badges

4 Comments

Hikmat Sijapati Over a year ago

are you getting value of $records['subject_id'][0] properly.

Hikmat Sijapati Over a year ago

what is the name of array that you are posting in question.

always-a-learner Over a year ago

I give it the $records = array(); and so on.

always-a-learner Over a year ago

I have updated the question again sir & added what the result array i need. @hekmat

Collectives™ on Stack Overflow

Codeigniter Insert Batch array

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related