How to use batch_insert in Code Igniter to insert an array into 1 column PHP?

Question

I have this function,

public function storeVals($vals)
{
    $vals = explode(",", $vals);

    foreach ($vals as $val)
    {
        $val = array('input'=>$val);

        $this->db->insert('input', $val);
    }
}

The function basically receives a string e.g: This,Is,An,Example

Then it turns the string into an array with "," as a delimiter.

Then it loops through the array and inserts the data into the DB.

Code Igniter, I think, already has the functionality to do this.

File: system/database/drivers/mysql/mysql_driver.php

function _insert_batch($table, $keys, $values)
{
    return "INSERT INTO ".$table." (".implode(', ', $keys).") VALUES    ".implode(', ', $values);
}

Any ideas on how I can use insert_batch() instead of looping and inserting will be highly appreciated.

Thank you.

devpro · Accepted Answer · 2016-03-18 16:22:19Z

1

In CodeIgniter, You can use batch_insert as:

public function storeVals($vals)
{
    $vals = explode(",", $vals);

    $yourArr = array();
    foreach ($vals as $val)
    {
        $yourArr[] = array('input'=>$val); // store values in array  
    }
    $this->db->insert('tableName', $yourArr);
}

You can also follow the CI example:

$data = array(
   array(
      'title' => 'My title' ,
      'name' => 'My Name' ,
      'date' => 'My date'
   ),
   array(
      'title' => 'Another title' ,
      'name' => 'Another Name' ,
      'date' => 'Another date'
   )
);

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

// Produces: INSERT INTO mytable (title, name, date) VALUES ('My title', 'My name', 'My date'), ('Another title', 'Another name', 'Another date')

Example Reference

CI 3 User Guide (Batch Insert)

answered Mar 18, 2016 at 16:22

devpro

16.1k3 gold badges29 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

How to use batch_insert in Code Igniter to insert an array into 1 column PHP?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related