combine array in php json encode

Question

I develop php code like this :

while($row = mysql_fetch_array ($result))     
    {

        $catalogue = array(
            'catalogue_id' => $row[0],          
            'catalogue_name' => $row[1],
            'catalogue_cover' => $row[2],

            'category' =>  array(
                            'id' => $row[3],
                            'name' => $row[4],
                            'cover' => $row[5],
                            'item' => array (
                                'id' => $row[6],
                                'name' => $row[7],
                                'cover' => $row[8],
                                'description' => $row[9],
                                'price' =>$row[10]
                            )
            ),                  
        );
        array_push($json, $catalogue);              
    }   
    $jsonresult  =  array2json($json);
    echo $jsonresult;

The result json is :

[
    {
        "catalogue_id": "59",
        "catalogue_name": "IT Catalog",
        "catalogue_cover": "http://192.168.0.22:90/Ecatalogue/catalogue/covers/511b21f398969.jpeg",
        "category": {
            "id": "60",
            "name": "Computer Accessory",
            "cover": "http://192.168.0.22:90/Ecatalogue/category/covers/511b2e11e8b26.jpg",
            "item": {
                "id": "61",
                "name": "CD",
                "cover": "http://192.168.0.22:90/Ecatalogue/item/covers/511b2e1da3063.jpg",
                "description": "",
                "price": "0.00"
            }
        }
    },
    {
        "catalogue_id": "59",
        "catalogue_name": "IT Catalog",
        "catalogue_cover": "http://192.168.0.22:90/Ecatalogue/catalogue/covers/511b21f398969.jpeg",
        "category": {
            "id": "61",
            "name": "IT Category",
            "cover": "http://192.168.0.22:90/Ecatalogue/category/covers/511caf7329f63.jpeg",
            "item": {
                "id": "63",
                "name": "IT Item",
                "cover": "http://192.168.0.22:90/Ecatalogue/item/covers/511cafa17cce5.jpeg",
                "description": "",
                "price": "0.00"
            }
        }
    }
]

But I want to combine the same catalog like this :

[
    {
        "catalogue_id": "59",
        "catalogue_name": "IT Catalog",
        "catalogue_cover": "http://192.168.0.22:90/Ecatalogue/catalogue/covers/511b21f398969.jpeg",
        "category": {
            "id": "60",
            "name": "Computer Accessory",
            "cover": "http://192.168.0.22:90/Ecatalogue/category/covers/511b2e11e8b26.jpg",
            "item": {
                "id": "61",
                "name": "CD",
                "cover": "http://192.168.0.22:90/Ecatalogue/item/covers/511b2e1da3063.jpg",
                "description": "",
                "price": "0.00"
            },
        "category-2": {
                "id": "61",
                "name": "IT Category",
                "cover": "http://192.168.0.22:90/Ecatalogue/category/covers/511caf7329f63.jpeg",
                "item": {
                    "id": "63",
                    "name": "IT Item",
                    "cover": "http://192.168.0.22:90/Ecatalogue/item/covers/511cafa17cce5.jpeg",
                    "description": "",
                    "price": "0.00"
                }
            }
        }
    }
]

How can I do that ?

i dont't think that is the idea with json... you would have 2 times the key category or later multiple times, should be against specification the way you want it — Dukeatcoding
– Dukeatcoding, Commented Feb 14, 2013 at 10:24
Are you saying you just want to overwrite the category element of the $json array? This is rather confusing. — EM-Creations
– EM-Creations, Commented Feb 14, 2013 at 10:24
I edit my question category to category, category 2 . Can I create that? — thinzar
– thinzar, Commented Feb 14, 2013 at 10:26
What have you done to come up with an answer yourself? The community wants to help you, but we don't like doing your homework. — Dennis Haarbrink
– Dennis Haarbrink, Commented Feb 14, 2013 at 10:34

Olaf Dietsche · Accepted Answer · 2013-02-15 08:35:14Z

1

You can index the $catalogue by catalogue_id and append category as they come

while ($row = mysql_fetch_array($result)) {
    $catalogue_id = $row[0];
    if (!isset($json[$catalogue_id])) {
        $json[$catalogue_id] = array(
            'catalogue_id' => $catalogue_id,
            'catalogue_name' => $row[1],
            'catalogue_cover' => $row[2]
            'categories' => array();
            );
    }

    $json[$catalogue_id]['categories'][] = array(
        'id' => $row[3],
        'name' => $row[4],
        'cover' => $row[5],
        'item' => array (
            'id' => $row[6],
            'name' => $row[7],
            'cover' => $row[8],
            'description' => $row[9],
            'price' =>$row[10]
        );
}

$jsonresult = array2json(array_values($json));
echo $jsonresult;

Instead of array2json you could also use json_encode

echo json_encode(array_values($json));

edited Feb 15, 2013 at 8:35

answered Feb 14, 2013 at 11:36

Olaf Dietsche

74.3k9 gold badges112 silver badges214 bronze badges

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

3 Comments

thinzar Over a year ago

Thanks for your help . Catalog are combine but category is empty array.

thinzar Over a year ago

I got it . I add $json[$catalogue_id] = $catalogue; after array_push($catalogue['categories'], $category); this.

Olaf Dietsche Over a year ago

@thinzar Sorry, I missed that. I simplified the code a bit. Please see updated answer.

Collectives™ on Stack Overflow

combine array in php json encode

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related