How to populate this PHP array?

Question

I have a outsource data from :

Here is the example result after decoding :

Array
(
    [popular] => Array
        (
            [last_week] => Array
                (
                    [0] => Array
                        (
                           [title] => Business 1
                            [category] => blog/business/local
                        )
                    [1] => Array
                        (
                        [title] => Health 1
                        [category] => blog/health/skincare
                    )
                [2] => Array
                    (
                        [title] => Business 2
                        [category] => blog/business/local
                    )
                [3] => Array
                    (
                        [title] => Health 2
                        [category] => blog/health/skincare
                    )
            )
    )

)

I'm use following method to display it :

$url = 'http://example.com/data/news.json';
$json = file_get_contents($url);
if(!empty($json)) {
$json_data = json_decode($json, true);
$popular_last_week = $json_data['popular']['last_week'];
$count = count($popular_last_week);
$result .= $count.' last week popular article' . "\n";
for ($i = 0;  $i <$count; $i++) {
$result .= 'Title : '.$popular_last_week[$i]['title'] . "\n";
$result .= 'Category : '.$popular_last_week[$i]['category'] . "\n\n";
}
echo $result;
}

and the output data is :

4 last week popular articles

Title : Business 1
Category : blog/business/local

Title : Health 1
Category : blog/health/skincare

Title : Business 2
Category : blog/business/local

Title : Health 2
Category : blog/health/skincare

The question is how to display the output to be following :

2 last week popular Business articles

Title : Business 1
Category : Busines

Title : Business 2
Category : Business

2 last week popular Health articles

Title : Health 1
Category : Health

Title : Health 2
Category : Health

help would be greatly appreciated! thank you.

Not sure if I understand correctly ... Simply iterate through the array, check if title contains Business and display it? — Pateman
– Pateman, Commented Jun 16, 2012 at 6:45
Hi, Thanks for your answer I'm new with PHP and it would be great if you give an example. :-D — Rifki
– Rifki, Commented Jun 16, 2012 at 6:50

Pateman · Accepted Answer · 2012-06-16 07:27:35Z

3

$url = 'http://example.com/data/news.json';
$json = file_get_contents($url);
if(!empty($json)) {
    $json_data = json_decode($json, true);
    $popular_last_week = $json_data['popular']['last_week'];

    //  This loop will group all entries by category.
    $categories = array();
    foreach ($popular_last_week as $item) {
        $categories[$item['category']][] = $item['title'];
    }

    //  This loop will echo the titles grouped by categories.
    foreach ($categories as $category => $titles) {
        $result = count($titles) . ' popular in "' . $category . '"' . "\n";
        foreach ($titles as $title) {
            $result .= 'Title: ' . $title . "\n";
        }
        echo $result;
    }
}

edited Jun 16, 2012 at 7:27

answered Jun 16, 2012 at 6:55

Pateman

2,7403 gold badges32 silver badges47 bronze badges

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

4 Comments

hjpotter92 Over a year ago

the category is taken to be only business

Rifki Over a year ago

The problem is the title is not always contains "Business".

Rifki Over a year ago

Let assumsing I've 4 articles (any words) with 2 categories "blog/business/local" and "blog/health/skincare" and I want to display them populated by category.

Rifki Over a year ago

Wow that exactly what I want, you're rock buddy!! thanks a lot!

Arjan · Accepted Answer · 2012-06-16 07:39:18Z

0

Do you mean that you only want to show 2 items? You need to use a for loop.

for ($i = 0;  $i < 2; $i++) {
    # display for $i
}

Update:

Ah, I think I understand. You should use a foreach loop and loop through twice:

$categoryItems = array();
foreach ($popular_last_week as $item) {
    $categoryItems[$item['category']][] = $item['title'];
}
foreach ($categoryItems as $category => $items) {
    $result .= count($items) . ' popular in category ' . $category;
    foreach ($items as $item){
        $result .= 'Title: ' . $item['title'] . "\n";
    }
}
echo $result;

edited Jun 16, 2012 at 7:39

Arjan

9,8941 gold badge33 silver badges43 bronze badges

answered Jun 16, 2012 at 6:54

Andrew

241k196 gold badges531 silver badges719 bronze badges

3 Comments

Rifki Over a year ago

Hi, Yes I'm also put that code but I don't know maybe eaten by editor

Andrew Over a year ago

Please see my updates, sorry it's hard to format when typing on my phone

Andrew Over a year ago

You know, Pateman copied my answer. You should have accepted mine.

Collectives™ on Stack Overflow

How to populate this PHP array?

2 Answers 2

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related