php create json multiple arrays

Question

php create json multiple arrays. Following code with php i need output like that json .. so many array and object confusing me. we using wordpres

<?php 
 $categories = get_categories( array(
  'orderby' => 'name',
  'parent'  => 0
  ));

 foreach ( $categories as $category ) {
    $category_id =  $category->term_id;
    $category_name = $category->name;
    echo  $category_name;
    echo "<br>";

        $args = array(
            'post_type' => 'post',
            'post_status' => 'publish',
            'category'  => $category_id
        );

        $myposts = get_posts( $args );
        foreach( $myposts as $post ){
            $category_postname = $post->post_title;
            echo $category_postname;
            echo "<br>";
        }
}
?>

Php output is"

    Testcat1
      pos1
      post2
    Testcat2
      post3
      post4
    TestCat3
      post5
      post 6

I need create Json like this:

    {
      "data": [
        {
          "cat": "Testcat1",
          "post": [
            {
              "name": "post1"
            },
            {
              "name": "post2"
            }
          ]
        },
        {
          "cat": "Testcat2",
          "post": [
            {
              "name": "post3"
            },
            {
              "name": "post4"
            }
          ]
        },
        {
          "cat": "Testcat3",
          "post": [
            {
              "name": "post5"
            },
            {
              "name": "post6"
            }
          ]
        }
      ]
    }

i need like this json output.

what about json_encode?

Jeff
– Jeff

2016-09-24 10:40:56 +00:00
Commented Sep 24, 2016 at 10:40 — Jeff
– Jeff, Commented Sep 24, 2016 at 10:40

Omnisite · Accepted Answer · 2016-09-24 10:59:24Z

1

You should put everything in an array and the json_encode it. I commented out your echos, so you could use them if you need later.

<?php 
$categories = get_categories( array(
    'orderby' => 'name',
    'parent'  => 0
));

// init empty array with root "data"
$array = array( 'data' => array() );
// set counter to 0 for array later on
$n = 0;

foreach ( $categories as $category ) {
    $category_id =  $category->term_id;
    $category_name = $category->name;

    // store cat.name
    $array['data'][$n]['cat'] = $category_name;
    // echo  $category_name;
    // echo "<br>";

    $args = array(
        'post_type' => 'post',
        'post_status' => 'publish',
        'category'  => $category_id
    );

    $myposts = get_posts( $args );
    // init posts counter
    $i = 0;
    foreach( $myposts as $post ){
        $category_postname = $post->post_title;
        $array['data'][$n]['post'][$i]['name'] = $category_postname;
        $array['data'][$n]['post'][$i]['id'] = $post->ID;
        // echo $category_postname;
        // echo "<br>";
        // increment post loop counter
        $i++;
    }

    // increment counter for array
    $n++;
}

echo json_encode( $array );
?>

edited Sep 24, 2016 at 10:59

answered Sep 24, 2016 at 10:42

Omnisite

2871 silver badge7 bronze badges

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

3 Comments

Omnisite Over a year ago

@suresh no problem: you can choose this answer as being the one you will use, by the way

suresh Over a year ago

how can i add $category_postid inside post array?? "post": [ { "name": "post5","id": "1", }

Omnisite Over a year ago

You will need an extra counter in the $myposts loop. I will edit the code

Collectives™ on Stack Overflow

php create json multiple arrays

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