Parsing array data

Question

I am trying to parse this array data that way generated from JQuery and JSON.

Array
(
[d] => Array
    (
        [0] => Array
            (
                [order] => 1
            )

        [1] => Array
            (
                [order] => 2
            )

        [2] => Array
            (
                [order] => 3
            )

        [3] => Array
            (
                [order] => 4
            )

        [4] => Array
            (
                [order] => 5
            )

    )

)

I am trying to save the above date into a mysql table, but cannot seem to parse the data properly to be inserted into the database.

Can anyone help?

Nikkeloodeni · Accepted Answer · 2010-04-25 13:04:36Z

1

I suppose language is PHP? You might wanna take a look json_decode()-function here: http://php.net/manual/en/function.json-decode.php

answered Apr 25, 2010 at 13:04

Nikkeloodeni

111 bronze badge

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

Comments

Pascal MARTIN · Accepted Answer · 2010-04-25 13:05:44Z

0

This looks like the ouput of the function print_r() -- and this is not intented to be parsed.

Instead of trying to parse that, you should work directly with the data your PHP code is receiving from the Ajax request -- i.e. with the JSON data, decoded with json_decode().

answered Apr 25, 2010 at 13:05

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

1 Comment

Sam Over a year ago

WOW, such quick replies... This is what is sent through the AJAX POST: {"d":[{"order":1},{"order":2},{"order":3},{"order":4},{"order":5}]} And using json_decode, the code below is what I have so far: $data = file_get_contents('php://input'); $data = json_decode(utf8_decode($data), true); foreach ( $data[d] as $key => $value ) { // $this->img_model->update_image_order($id , $order); } My main problem is getting my head round the arrays... Hopefully someone can point me in the right direction.

veturi · Accepted Answer · 2010-04-25 16:44:02Z

0

You should use json_decode() (as others have already stated) for decoding your JSON into php arrays. But if I got it right your problem is how to work with PHP arrays so i suggest you check out some good basic tutorial. w3c has decent basic array tutorial here: http://www.w3schools.com/php/php_arrays.asp

answered Apr 25, 2010 at 16:44

veturi

1,9712 gold badges14 silver badges17 bronze badges

Comments

ZZ Coder · Accepted Answer · 2010-04-25 18:04:59Z

0

All you have to do is something like this,

foreach ( $data['d'] as $key => $value ) { 
   $id = $value['order'];
   $order = 'order';
   $this->img_model->update_image_order($id , $order); 
}

This assumes the number in JSON is the order ID.

edited Apr 25, 2010 at 18:04

answered Apr 25, 2010 at 14:00

ZZ Coder

75.7k30 gold badges139 silver badges169 bronze badges

2 Comments

Sam Over a year ago

Thanks ZZCoder, unfortunately I am getting a couple of errors with this. I am getting "Message: Use of undefined constant d - assumed 'd" and "Message: Undefined variable: order" errors. How can I fix this?

ZZ Coder Over a year ago

I don't know the semantics of the message so the code is just an example how to handle the array of array. Just edited to get rid of the errors.

Collectives™ on Stack Overflow

Parsing array data

4 Answers 4

Comments

1 Comment

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

2 Comments

Related