How to count unique value in array in php

Question

I am getting data from database in following format,I just want to get data,How many restaurant name (count) in which country,How can i do this ? How can i change following array/object in php ?

stdClass Object
(
    [_id] => 5ce405ced246f713b6256f3a
    [location] => stdClass Object
        (
            [country] => Kuwait
        )
    [employerDetails] => Array
        (
            [0] => stdClass Object
                (
                    [restraunt_name] => test1
                 )
        )

    [_id] => 5ce405ced246f713b6277373
    [location] => stdClass Object
        (
            [country] => Kuwait
        )
    [employerDetails] => Array
        (
            [0] => stdClass Object
                (
                    [restraunt_name] => test2
                 )
        )       
    ....
 )

an array cannot have same indexes multiple time. please correct input data — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jun 3, 2019 at 8:10
@ Alive to die,ya,this is just example,hope you understand my question,please help me — amit
– amit, Commented Jun 3, 2019 at 8:13
You want count of restaurants country wise or names of restaurants also? I see this is mongodb stuff, do you want query for that or in php? — Rahul
– Rahul, Commented Jun 3, 2019 at 8:52

dWinder · Accepted Answer · 2019-06-03 08:13:36Z

1

As object can have same keys I will assume you have array of object for each restaurant object.

First I recommend get only the countries to separate array as:

foreach($objectArray as $restaurant)
    $countries[] = $restaurant->location->country;

Now you can use array-count-values to get number of object according the countries:

print_r(array_count_values($countries));

answered Jun 3, 2019 at 8:13

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

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

Comments

Amarat · Accepted Answer · 2019-06-03 10:51:13Z

$countries = array();
//first get all countries list
foreach ($array as $data) {
    if (!in_array($data->location->country, $countries)) {
        array_push($countries, $data->location->country);
    }
}
//get restraunt county wise
foreach ($array as $key => $data) {
    //if (in_array($data->location->country, $countries)) {
    if (!empty($data->location->country) && !empty($data->employerDetails[0]->restraunt_name)) {
        $countries_f[$data->location->country][$key] = $data->employerDetails[0]->restraunt_name;
    }
    //}
}
//get count of restraunt in each ocuntry
foreach ($countries as $cnt) {
    echo 'count of' . $cnt = count($countries_f[$cnt]) . '<br />';
}

echo "<pre>";
print_r($countries_f);

die;

Collectives™ on Stack Overflow

How to count unique value in array in php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related