Insert array batch in codeigniter

Question

I want to insert an array with array like below format, how to do this, i've try insert batch also, but it doesn't work.

 array(4) {
  ["notification_title"]=>
  array(2) {
    [0]=>
    string(35) "Hello! We have a good news for you."
    [1]=>
    string(35) "Hello! We have a good news for you."
  }
  ["notification_message"]=>
  array(2) {
    [0]=>
    string(81) "Now you can choose up to three types of advertisers that you wish to collaborate."
    [1]=>
    string(95) "Saat ini Anda sudah dapat memilih maksimal 3 (tiga) tipe iklan untuk dipasang pada mobil Anda. "
  }
  ["notification_type"]=>
  array(2) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "1"
  }
  ["notification_language"]=>
  array(2) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "2"
  }
}

i've try this, but it doesn't work

public function save($data) {
    $this->db->insert_batch($this->table, $data);   
}

Error Message

<h1>A Database Error Occurred</h1>
    <p>Error Number: 1064</p><p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0, 1) VALUES ('Hello! We have a good news for you.','Hello! We have a good news ' at line 1</p><p>INSERT INTO `ads_notification` (0, 1) VALUES ('Hello! We have a good news for you.','Hello! We have a good news for you.'), ('Now you can choose up to three types of advertisers that you wish to collaborate.','Saat ini Anda sudah dapat memilih maksimal 3 (tiga) tipe iklan untuk dipasang pada mobil Anda. '), ('1','1'), ('1','2')</p><p>Filename: C:/xampp/htdocs/movads/application/models/ModelNotifications.php</p><p>Line Number: 127</p>  </div>

This one is my print_r statement

--- Print_r statement ---

    Array
(
    [notification_title] => Array
    (
        [0] => Keep your weekly minimum distance well monitor.
        [1] => Keep your weekly minimum distance well monitor.
    )
[notification_message] => Array
    (
        [0] => We found out that your driving is below weekly minimum distance. Keep driving safely and increase your driving distance to meet the minimum requirements.
        [1] => Anda masih belum memenuhi target jarak minimum mingguan. Tetap menyetir dengan aman dan tingkatkan jarak mingguan Anda. Tetap semangat!
    )

[notification_type] => Array
    (
        [0] => 2
        [1] => 2
    )

[notification_language] => Array
    (
        [0] => 1
        [1] => 2
    )

    )

hi @Swolschblauw no, there is no error messages, but i want to insert with that array format, it seems different with the documentations from CI — Amir Rachman
– Amir Rachman, Commented Jun 29, 2016 at 9:23

Raj Jagani · Accepted Answer · 2016-06-29 09:42:10Z

2

$post_array = array(
    "notification_title"=>array("Hello! We have a good news for you.","Hello! We have a good news for you."),
    "notification_message"=>array("Now you can choose up to three types of advertisers that you wish to collaborate.","Now you can choose up to three types of advertisers that you wish to collaborate."),
    "notification_type"=>array('1','1'),
    "notification_language"=>array('1','1')
    );
$data = array();
$i = 0;
foreach($post_array as $key=>$val) {
    $i = 0;
    foreach($val as $k=>$v) {
        $data[$i][$key] = $v;
        $i++;
    }
}
echo '<pre>';
print_r($data);

so you will get array like below and you can use it with insert batch

$data = array(
    array(
       'notification_title'=> 'Hello! We have a good news for you',
       'notification_message'=> 'Now you can choose up to three types of advertisers that you wish to collaborate.',
       'notification_type'=>'1',
       'notification_language'=>'1'
    ),
    array(
       'notification_title'=> 'Hello! We have a good news for you',
       'notification_message'=> 'Now you can choose up to three types of advertisers that you wish to collaborate.',
       'notification_type'=>'1',
       'notification_language'=>'1'
    ),
);

here key will be your column name of table and than

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

hope this will help you..

edited Jun 29, 2016 at 9:42

answered Jun 29, 2016 at 9:26

Raj Jagani

7333 gold badges6 silver badges21 bronze badges

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

4 Comments

Amir Rachman Over a year ago

Hi @raj Jagani, yes, how to reformat that array to be like that format, that is my question actually.

Raj Jagani Over a year ago

ok I can do that can you just post your array with print_r statement.

Amir Rachman Over a year ago

i need the code to convert an array format like my questions above to your array format

Raj Jagani Over a year ago

@AmirRachman : I have updated the answer and please remove your print statement from answer.

Vincent Decaux · Accepted Answer · 2016-06-29 09:42:52Z

0

You can use this function to format your array :

function toBatchArray($array)
{
    $result = array();
    foreach ($array as $k => $v)
    {
        $array = array();

        foreach ($v as $value)
        {
            $array[][$k]= $value;
        }
        $result[] = $array;
    }

    return $result;
}

answered Jun 29, 2016 at 9:42

Vincent Decaux

10.9k7 gold badges67 silver badges103 bronze badges

Collectives™ on Stack Overflow

Insert array batch in codeigniter

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related