CodeIgniter insert multidimensional array to database table as separate rows

Question

saving post value to an array.

$data2 = array(
  'invoice_id' =>($id),
  'order_id' => $this->input->post('order_id'),
  'invoiceitems_servicetype' =>$this->input->post('type'),
  'invoiceitems_quantity' => $this->input->post('quantity'),
  'invoiceitems_unitprice' => $this->input->post('rate'),
  'invoiceitems_notes' => $this->input->post('description')
      );

 $this->db->insert('abc_invoiceitems', $data2);

print_r($data2);

Array Structure.

Array
(
    [invoice_id] => 21
    [order_id] => 1
    [invoiceitems_servicetype] => Array
        (
            [0] => Order
            [1] => Miscellaneous
            [2] => Order
        )

    [invoiceitems_quantity] => Array
        (
            [0] => 5
            [1] => 64
            [2] => 88
        )

    [invoiceitems_unitprice] => Array
        (
            [0] =>  5
            [1] =>  6
            [2] =>  8
        )

    [invoiceitems_notes] => Array
        (
            [0] => test Data1
            [1] => test Data2
            [2] => test Data3
        )

)

Insert array values to database table.

TABLE NAME --- abc_invoiceitems 
 +------------+----------+--------------------------+-----------------------+------------------------+--------------------+
 | invoice_id | order_id | invoiceitems_servicetype | invoiceitems_quantity | invoiceitems_unitprice | invoiceitems_notes |
 +------------+----------+--------------------------+-----------------------+------------------------+--------------------+

I got this following error and the error is :

the values are returning as array.

INSERT INTO abc_invoiceitems (invoice_id, order_id, invoiceitems_servicetype, invoiceitems_quantity, invoiceitems_unitprice, invoiceitems_notes) VALUES ('21', '1', Array, Array, Array, Array)

So what did you expect? Have you ever worked with MySQL? It's a relational database, not document-oriented. If you want to save multidimensional arrays to a database MongoDB is the way to go, or use some ORM like Doctrine. — Sergey Telshevsky
– Sergey Telshevsky, Commented Feb 5, 2013 at 9:52

Avin Varghese · Accepted Answer · 2013-02-05 10:23:38Z

4

Fetch post values:

$temp =count($this->input->post('type'));//counting number of row's
$type= $this->input->post('type');
$quantity = $this->input->post('quantity');
$rate = $this->input->post('rate');
$description = $this->input->post('description');

Loop through Key values:

for($i=0; $i<$temp;$i++){
  $data2 = array(
  'invoice_id' =>($id),
  'order_id' => $this->input->post('order_id'),
  'invoiceitems_servicetype' =>$type[$i],
  'invoiceitems_quantity' => $quantity[$i],
  'invoiceitems_unitprice' => $rate[$i],
  'invoiceitems_notes' => $description[$i]
      );
   $this->db->insert('abc_invoiceitems', $data2);
  }

answered Feb 5, 2013 at 10:23

Avin Varghese

4,3601 gold badge24 silver badges32 bronze badges

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

Comments

Jezen Thomas · Accepted Answer · 2013-02-05 09:56:22Z

1

How about turning the arrays into serialized strings?

$data2 = array(
    'invoice_id' =>($id),
    'order_id' => $this->input->post('order_id'),
    'invoiceitems_servicetype' => serialize($this->input->post('type')),
    'invoiceitems_quantity' => serialize($this->input->post('quantity')),
    'invoiceitems_unitprice' => serialize($this->input->post('rate')),
    'invoiceitems_notes' => serialize($this->input->post('description'))
);

$this->db->insert('abc_invoiceitems', $data2);

When you want to pull the data back out of the database, you can unserialize the strings.

answered Feb 5, 2013 at 9:56

Jezen Thomas

13.8k7 gold badges55 silver badges95 bronze badges

6 Comments

Sergey Telshevsky Over a year ago

Interesting solution, Jezen! Want to mention works only when you don't need to do JOIN's on data in these arrays.

Avin Varghese Over a year ago

But i need each array values save to separate rows.

Jezen Thomas Over a year ago

You're right. You would need to distribute the datasets into relative tables.

Jezen Thomas Over a year ago

@DOCTYPE I think you're going to need to revise your database structure.

Avin Varghese Over a year ago

Can we do it with Foreach Loop.

|

Collectives™ on Stack Overflow

CodeIgniter insert multidimensional array to database table as separate rows

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related