CODEWITHSUNDEEP
phparraysmultidimensional-arraygrouping
Mic
Mic

Reputation: 81

How to group the result of array in two categories in PHP?

I have data here:

Array
(
[1] => Array
    (
        [SiteID] => 1
        [OwnerAID] => 1

    )

[3] => Array
    (
        [SiteID] => 3
        [OwnerAID] => 1

    )

[6] => Array
     (
        [SiteID] => 6
        [OwnerAID] => 2

     )
    )

Now, I need to group the OwnerAID into two categories: the first one is OwnerAID owning only one SiteID and the second one is OwnerAID owning more than 1 SiteID.

I've tried to make a program and do some research, but the output of my code is wrong.

Please see my code:

       public function groupIndividualAndAggregateSites()
    {

    $arrays = array();
        foreach($this->combined as $key => $key_value)
        {
            $SiteID = "";

        if ($SiteID == "") {

            $SiteID=array($key_value['SiteID']); }

           else {
                   $SiteID = array_merge((array)$SiteID, (array)$key_value['SiteID']);

                   $SiteID = array_unique($SiteID);

                }

       } if ($SiteID != "") {

       $arrays = array('AID'=>$key_value['AID'], 'Sites' => $SiteID);
     }
        print_r($arrays);

    }

The result should be shown like this:

 Array( 
        [1] => Array

      ( [Sites] => Array ([0] => 1, [1] => 3)))

 Array( 
        [2] => Array

      ( [Sites] => Array ([0] => [6]))

Upvotes: 0

Views: 158

Answers (2)

Gundars Mēness
Gundars Mēness

Reputation: 498

What you should go for is array: 

$owners = array(
owner_1 => SiteID1, // int Only one site
owner_2 => array (SiteID2,SiteID3), // array Multiple sites
);

and later use the array $owners like:

echo (is_array($owners[$owner_1]) ? 'Has multiple sites' : 'has one site';

Thats the basic idea of small memory footprint.

Example, not tested.

public function groupIndividualAndAggregateSites() {
  $owners = array();
  foreach($this->combined as $key => $value) {
    $owner_id = $value['OwnerAID'];
    $site_id = $value['SiteID'];

    if(array_key_exists($owner_id,$owners)) {
      // He has one or more sites already?
      if(is_array($owners[$owner_id]){
        array_push($owners[$owner_id],$site_id);
      } else {
      // User already has one site. Lets make an array instead and add old and new siteID
        $old_site_id = $owners[$owner_id];
        $owners[$owner_id] = array($old_site_id,$owner_id);
      }
    } else {
      $owners[$owner_id] = $site_id;
    }
return $owners;    
}

Upvotes: 1

eggyal
eggyal

Reputation: 125865

All you need to do is loop over your initial array, appending each OwnerAID to the relevant output subarray as determined by the SiteID:

$output = array(1=>array(), 2=>array());
foreach ($original as $v) $output[$v['SiteID'] == 1 ? 1 : 2][] = $v['OwnerAID'];

Here I am using the following features:

Upvotes: 0

Related Questions