how to split JSON array in php

Question

I manage to get the data I want from database using array_push and encode it into JSON in PHP. The results I get are like below,

{
"name":[
    "Lucky Draw Ticket",
    "KIP Voucher RM10",
    "KIP Voucher RM20",
    "KIP Voucher RM50"
],
"image":[
    "\/l\/u\/lucky_draw_ticket_1.jpg",
    "\/c\/a\/cash-voucher.jpg",
    "\/c\/a\/cash-voucher2.jpg",
    "\/c\/a\/cash-voucher50_1.jpg"
],
"price":[
    "50.0000",
    "1500.0000",
    "2500.0000",
    "5000.0000"
]}

But now I want to separate it into something like below, but I don't know how to do.

{
"catalog":[
   {
   "name": "Lucky Draw Ticket",
   "image": "\/l\/u\/lucky_draw_ticket_1.jpg",
   "price": "50.0000"
   },
   {
   "name": "KIP Voucher RM10",
   "image": "\/c\/a\/cash-voucher.jpg",
   "price": "1500.0000"
   },
   {
   "name": "KIP Voucher RM20",
   "image": "\/c\/a\/cash-voucher2.jpg",
   "price": "2500.0000"
   },
   {
   "name": "KIP Voucher RM20",
   "image": "\/c\/a\/cash-voucher50_1.jpg"
   "price": "5000.0000"
   }
]}

decode into an array, use a for loop, push into new container array, encode it again — Kevin
– Kevin, Commented Feb 3, 2016 at 2:46
most likely you'll need to use json_encode and json_decode, a for loop also — Kevin
– Kevin, Commented Feb 3, 2016 at 3:06

hherger · Accepted Answer · 2016-02-03 08:52:23Z

1

Try this:

create a Json object from the Json string,
reorganize the object into a temporary PHP array,
create a Json object (string) from the PHP arrray.

Code

<?php
    $sjson='{
"name":[
    "Lucky Draw Ticket",
    "KIP Voucher RM10",
    "KIP Voucher RM20",
    "KIP Voucher RM50"
],
"image":[
    "\/l\/u\/lucky_draw_ticket_1.jpg",
    "\/c\/a\/cash-voucher.jpg",
    "\/c\/a\/cash-voucher2.jpg",
    "\/c\/a\/cash-voucher50_1.jpg"
],
"price":[
    "50.0000",
    "1500.0000",
    "2500.0000",
    "5000.0000"
]}';
$tarray = json_decode($sjson);
$newarray = array('catalog'=>array());
foreach($tarray->name as $ix => $name) {
    $newarray['catalog'][]=array(
        'name'  => $tarray->name[$ix],
        'image' => $tarray->image[$ix],
        'price' => $tarray->price[$ix],
    );
}
$sjson = json_encode($newarray);
// echo '<pre>'; var_dump($sjson); echo '</pre>';
?>

Result

{
    "catalog":[
        {
            "name":"Lucky Draw Ticket",
            "image":"\/l\/u\/lucky_draw_ticket_1.jpg",
            "price":"50.0000"
        },
        {
            "name":"KIP Voucher RM10",
            "image":"\/c\/a\/cash-voucher.jpg",
            "price":"1500.0000"
        },
        {
            "name":"KIP Voucher RM20",
            "image":"\/c\/a\/cash-voucher2.jpg",
            "price":"2500.0000"
        },
        {
            "name":"KIP Voucher RM50",
            "image":"\/c\/a\/cash-voucher50_1.jpg",
            "price":"5000.0000"
        }
    ]
}

edited Feb 3, 2016 at 8:52

answered Feb 3, 2016 at 3:15

hherger

1,6721 gold badge11 silver badges13 bronze badges

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

3 Comments

chyman-91 Over a year ago

Thank you, i get the result i want.

Vijaysinh Parmar Over a year ago

@hherger : $tarray = json_decode($sjson);//Its giving error here you have to use object array like this $tarray =(object) json_decode($sjson);

hherger Over a year ago

@Vihaysinh: json_decode() usually returns a Json object per default. Otherwise the syntax $tarray->name[...] would be erroneous. What exactly is the error message you are receiving?

Raphael Rafatpanah · Accepted Answer · 2016-02-03 03:06:13Z

1

An example:

<?php

$data = json_decode('{
"name":[
    "Lucky Draw Ticket",
    "KIP Voucher RM10",
    "KIP Voucher RM20",
    "KIP Voucher RM50"
],
"image":[
    "\/l\/u\/lucky_draw_ticket_1.jpg",
    "\/c\/a\/cash-voucher.jpg",
    "\/c\/a\/cash-voucher2.jpg",
    "\/c\/a\/cash-voucher50_1.jpg"
],
"price":[
    "50.0000",
    "1500.0000",
    "2500.0000",
    "5000.0000"
]}', true);

$result = [
    'catalog' => [
    ]
];

for ($i=0; $i<=count($data); $i++) {
    $temp = [];
    array_push($temp, $data['name'][$i]);
    array_push($temp, $data['image'][$i]);
    array_push($temp, $data['price'][$i]);
    array_push($result['catalog'], $temp);
}


?>

<pre>
    <?php
        print_r($result);
    ?>
</pre>

<?php 

// Convert back to JSON
$json = json_encode($result);

?>

answered Feb 3, 2016 at 3:06

Raphael Rafatpanah

20.2k28 gold badges106 silver badges176 bronze badges

3 Comments

chyman-91 Over a year ago

Hi, i cannot get the result. Server error was shown.

chyman-91 Over a year ago

my data is retrieved from database using array then use json_encode before echo out, so is this the problem cause it got error?

Raphael Rafatpanah Over a year ago

What is the error exactly? Please update your code with the error message and relevant code.

Santhy K · Accepted Answer · 2016-02-03 03:12:48Z

0

Try this..

$str = '{
"name":[
    "Lucky Draw Ticket",
    "KIP Voucher RM10",
    "KIP Voucher RM20",
    "KIP Voucher RM50"
],
"image":[
    "\/l\/u\/lucky_draw_ticket_1.jpg",
    "\/c\/a\/cash-voucher.jpg",
    "\/c\/a\/cash-voucher2.jpg",
    "\/c\/a\/cash-voucher50_1.jpg"
],
"price":[
    "50.0000",
    "1500.0000",
    "2500.0000",
    "5000.0000"
]}';
$jsonArr  = json_decode($str, true);

//create array in needed format
$finalArr = array();
foreach ($jsonArr AS $key => $dataArr) {
    $count = count($dataArr);
    for ($indx = 0; $indx < $count; $indx++) {
        $finalArr['catalog'][$indx][$key] = $dataArr[$indx];
    }
}

//output
$jsonFinal = json_encode($finalArr, true);
echo $jsonFinal;

answered Feb 3, 2016 at 3:12

Santhy K

8041 gold badge7 silver badges12 bronze badges

Comments

Narendrasingh Sisodia · Accepted Answer · 2016-02-03 05:17:19Z

Simply you can use array_map like as

array_map(null,$jsonArr['name'],$jsonArr['image'],$jsonArr['price']);

So your code looks like as

$jsonArr = json_decode($json, true);
$result['catalog'] = array_map(null,$jsonArr['name'],$jsonArr['image'],$jsonArr['price']);
echo json_encode($result);

Output:

{
    "catalog": [
        [
            "Lucky Draw Ticket",
            "\/l\/u\/lucky_draw_ticket_1.jpg",
            "50.0000"
        ],
        [
            "KIP Voucher RM10",
            "\/c\/a\/cash-voucher.jpg",
            "1500.0000"
        ],
        [
            "KIP Voucher RM20",
            "\/c\/a\/cash-voucher2.jpg",
            "2500.0000"
        ],
        [
            "KIP Voucher RM50",
            "\/c\/a\/cash-voucher50_1.jpg",
            "5000.0000"
        ]
    ]
}

Vijaysinh Parmar · Accepted Answer · 2016-02-03 06:58:03Z

0

Use this code to get exact result what you expect..

$string = your json string.

$json_decode = json_decode($string,true);
$temp = array();
$i = 0;
foreach($json_decode as $key=>$val){
        $temp['catalog'][$i]['name'] = $json_decode['name'][$i];
        $temp['catalog'][$i]['image'] = $json_decode['image'][$i];
        $temp['catalog'][$i]['price'] = $json_decode['price'][$i];
        $i++;
}
echo "<pre>";
print_r($temp);
print_r(json_encode($temp));

edited Feb 3, 2016 at 6:58

answered Feb 3, 2016 at 4:27

Vijaysinh Parmar

9271 gold badge15 silver badges19 bronze badges

Collectives™ on Stack Overflow

how to split JSON array in php

5 Answers 5

Code

Result

3 Comments

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Code

Result

3 Comments

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related