Adding an array to an existing array and saving with CodeIgniter

Question

I have the following function:

function saveCOA() {
    $labref = $this->uri->segment(3);   
    $data = $this->input->post('compedia');
    $data1 = $this->input->post('specification');
    count($data) == count($data1); 
    for ($i = 0; $i < count($data); $i++) {
        $insert_data = array(
            'labref' => $labref, //NDQA201303001                
            'compedia' => $data[$i],
            'specification' => $data1[$i]
        );
        $this->db->insert('coa_body', $insert_data);
    }

It saves well, but now I have modified it as shown below:

$labref=$this->uri->segment(3);
$test_id=  $this->getRequestedTestIds($labref);
$data = $this->input->post('compedia');
$data1 = $this->input->post('specification');
count($data) == count($data1) && count($data)==  count($test_id); 
for ($i = 0; $i < count($data); $i++) {
    $insert_data = array(
        'labref' => $labref, //NDQA201303001 - Same for all the rows
        'test_id'=>$test_id[$i], //added array
        'compedia' => $data[$i],
        'specification' => $data1[$i]
    );
    $this->db->insert('coa_body', $insert_data);
}

The value of $test_id is printed out by print_r() as:

Array ( [0] => Array ( [test_id] => 5 ) [1] => Array ( [test_id] => 7 ) [2] => Array ( [test_id] => 9 ) [3] => Array ( [test_id] => 10 ) )

I have added the array $test_id, and it returns:

Error Number: 1054

Unknown column 'Array' in 'field list'

INSERT INTO `coa_body` (`labref`, `test_id`, `compedia`, `specification`) VALUES ('NDQA201303001', Array, 'Alphy', 'poxy')

Filename: C:\xampp\htdocs\NQCL\system\database\DB_driver.php

Line Number: 330

What am I missing?

Daniel · Accepted Answer · 2013-05-19 18:45:53Z

1

Looks like $test_id[$i] or $test_id[0] is an array which contains key test_id so you're giving a mysql query an array. Instead do this:

'test_id' => $test_id[$i]['test_id'], //added array

Eg. print_r($test_id[0]) would give you:

Array ( [test_id] => 5 )

I hope you get it. Have a nice day.

answered May 19, 2013 at 18:45

Daniel

18.7k8 gold badges69 silver badges90 bronze badges

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

Collectives™ on Stack Overflow

Adding an array to an existing array and saving with CodeIgniter

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