Iterate over array of results, two by two

Question

I have an array coming from a SQL query that follows the following format:

[ 
  ["2012-10-01", 1, 3890], 
  ["2012-10-01", 0, 8900], 
  ["2012-09-21", 0, 8900], 
  ["2012-09-21", 1, 8900], 
  ...
]

At the end I want to have the counts for 0s and 1s. So for example, for the date 2012-10-01, I would have that the value 1 have a count 3890 and the value 0 have a count 8900. I want to know how I can iterate this array in order to build a final array like this:

$final_array["value0"]["2012-10-01"] = 3890
$final_array["value1"]["2012-10-01"] = 8900
$final_array["total"]["2012-10-01"] = 12790

Taking into account that it can happen that a date doesn't have a count for value 0 or 1, and the order of value 0 and 1 is not always the same.

So the first example could be like this:

[ 
   ["2012-10-01", 1, 3890], 
   ["2012-09-21", 1, 8900], 
   ["2012-09-21", 0, 8900], 
   ...
]

As you can see the first date is lacking of value 0 and the final array would still have to have it like this:

   $final_array["value0"]["2012-10-01"] = 3890
   $final_array["value1"]["2012-10-01"] = 0

what is the value of $final_array["value1"]["2012-10-01"] in your second example? — Shiplu Mokaddim
– Shiplu Mokaddim, Commented Oct 23, 2012 at 7:25

Baronth · Accepted Answer · 2012-10-23 07:27:23Z

2

foreach ($array1 as $value){
    $final_array["value".$value[1]][$value[0]] = $value[2];
}

with $array1 as your first array

answered Oct 23, 2012 at 7:27

Baronth

9897 silver badges13 bronze badges

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

Comments

score 1 · Accepted Answer · 2012-10-23 08:04:05Z

1

Here is the code. You really should try to work it out yourself first, because this is basic array mapping.

foreach($initialarray as $data){
    $finalarray["value".$data[1]][$data[0]]=$data[2]; 
}

EDIT: Here is code that fulfils your updated requirements:

$initialarray = array(array("2012-10-01", 1, 3890), array("2012-09-21", 1, 8900), array("2012-09-21", 0, 8900));
$finalarray["value0"]=array();
$finalarray["value1"]=array();
foreach($initialarray as $data){
    $finalarray["value".$data[1]][$data[0]]=$data[2]; 
    $finalarray["value".round(cos($data[1]*pi()/2))][$data[0]]=$finalarray["value".round(cos($data[1]*pi()/2))][$data[0]]?$finalarray["value".round(cos($data[1]*pi()/2))][$data[0]]:0;
}
echo "<pre>";
var_dump($finalarray);
echo "<pre>";

DEMO

edited Oct 23, 2012 at 8:04

answered Oct 23, 2012 at 7:28

user1726343

8 Comments

Hommer Smith Over a year ago

This won't work if, as I said, the values of 0,1 are not ordered by date.

Ja͢ck Over a year ago

@HommerSmith This should work just fine, could you explain more why that wouldn't work?

Hommer Smith Over a year ago

Yes sorry. Imagine that for the first date, there is no 0 value. In that case I would have to create an entrance like this: $finalarray["value0"][$data[0]]=0

user1726343 Over a year ago

If there is no 0 value for the first date, the "value0" index will still be defined on the array as long as there is at least one entry for 0 values on some day. Your last comment is crucial information. You should include this in the question.

Hommer Smith Over a year ago

Yes, but it needs to be defined for all dates that there is value 1, and the other way around. So, all dates have to have value0 and value1.

|

Carlos · Accepted Answer · 2012-10-23 07:27:16Z

0

This will work:

$result = array('value0' => array(), 'value1' => array());
foreach ($array as $value) {
    $result[('value' . $value[1])][$value[0]] = $value[2];
}

answered Oct 23, 2012 at 7:27

Carlos

5,1222 gold badges23 silver badges37 bronze badges

Collectives™ on Stack Overflow

Iterate over array of results, two by two

3 Answers 3

Comments

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related