[RESOLVED] Combining arrays?

h4x0rmx

I have to multidimensional arrays with similar data and I need to combine them. This is how they look like:

$punches:

Array ( [id] => 347594 [name] => Charls Brown [date] => 2009-03-23 [punch_in] => 09:32 [punch_out] => 11:55 )
Array ( [id] => 347595 [name] => Charls Brown [date] => 2009-03-24 [punch_in] => 08:00 [punch_out] => 11:55 )
Array ( [id] => 347596 [name] => Charls Brown [date] => 2009-03-25 [punch_in] => 07:59 [punch_out] => 11:59 )
Array ( [id] => 347597 [name] => Charls Brown [date] => 2009-03-26 [punch_in] => 07:58 [punch_out] => 11:55 )
Array ( [id] => 347598 [name] => Charls Brown [date] => 2009-03-30 [punch_in] => 08:09 [punch_out] => 11:55 )
Array ( [id] => 347599 [name] => Charls Brown [date] => 2009-03-31 [punch_in] => 08:04 [punch_out] => 11:55 )

$schedule:

Array ( [id] => 228996 [name] => Charls Brown [date] => 2009-03-16 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229031 [name] => Charls Brown [date] => 2009-03-17 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229032 [name] => Charls Brown [date] => 2009-03-18 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229033 [name] => Charls Brown [date] => 2009-03-19 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229329 [name] => Charls Brown [date] => 2009-03-23 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229364 [name] => Charls Brown [date] => 2009-03-24 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229365 [name] => Charls Brown [date] => 2009-03-25 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229366 [name] => Charls Brown [date] => 2009-03-26 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229706 [name] => Charls Brown [date] => 2009-03-30 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229741 [name] => Charls Brown [date] => 2009-03-31 [sched_in] => 8:00 [sched_out] => 12:00 )

I need to come up with something like:
$result:

Array ( [id] => 228996 [name] => Charls Brown [date] => 2009-03-16 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229031 [name] => Charls Brown [date] => 2009-03-17 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229032 [name] => Charls Brown [date] => 2009-03-18 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229033 [name] => Charls Brown [date] => 2009-03-19 [sched_in] => 8:00 [sched_out] => 12:00 )
Array ( [id] => 229329 [name] => Charls Brown [date] => 2009-03-23 [sched_in] => 8:00 [sched_out] => 12:00 [punch_in] => 09:32 [punch_out] => 11:55 [id2] => 347594 )
Array ( [id] => 229364 [name] => Charls Brown [date] => 2009-03-24 [sched_in] => 8:00 [sched_out] => 12:00 [punch_in] => 08:00 [punch_out] => 11:55 [id2] => 347595 )
Array ( [id] => 229365 [name] => Charls Brown [date] => 2009-03-25 [sched_in] => 8:00 [sched_out] => 12:00 [punch_in] => 07:59 [punch_out] => 11:59 [id2] => 347596 )
Array ( [id] => 229366 [name] => Charls Brown [date] => 2009-03-26 [sched_in] => 8:00 [sched_out] => 12:00 [punch_in] => 07:58 [punch_out] => 11:55 [id2] => 347597 )
Array ( [id] => 229706 [name] => Charls Brown [date] => 2009-03-30 [sched_in] => 8:00 [sched_out] => 12:00 [punch_in] => 08:09 [punch_out] => 11:55 [id2] => 347598 )
Array ( [id] => 229741 [name] => Charls Brown [date] => 2009-03-31 [sched_in] => 8:00 [sched_out] => 12:00 [punch_in] => 08:04 [punch_out] => 11:55 [id2] => 347599 )

I don't really need to have an array as a result, but I do need to make a table that looks like the last array.
I can only think of walking through one of the arrays and on every step walk through the other (looking for the same 'date' value) but this process would be quite slow if the arrays were bigger.
Any ideas?
Any code example would be really appreciated.
Thanks in advance!

NogDog

Is this data coming from database queries? If so, it might be easier to create one query (probably using a left join) to create the consolidated data.

h4x0rmx

NogDog;10911018 wrote:
Is this data coming from database queries? If so, it might be easier to create one query (probably using a left join) to create the consolidated data.

One of the array comes straight from a database, the other one is from a database but there are a lot of operations done before coming up with the data that it would be almost impossible...
I would do a left join if I could.
Any other suggestions? 😃

NogDog

You could read each array into 3rd array where the index is the date:

<?php
function byDate($arr, &$result)
{
   foreach($arr as $row)
   {
      $date = $row['date'];
      foreach($row as $ix => $val)
      {
         $result[$date][$ix] = $val;
      }
   }
}

$arr1 = array(
   Array ('id' => '347594', 'name' => 'Charls Brown', 'date' => '2009-03-23', 'punch_in' => '09:32', 'punch_out' => '11:55'),
   Array ('id' => '347595', 'name' => 'Charls Brown', 'date' => '2009-03-24', 'punch_in' => '08:00', 'punch_out' => '11:55'),
   Array ('id' => '347596', 'name' => 'Charls Brown', 'date' => '2009-03-25', 'punch_in' => '07:59', 'punch_out' => '11:59'),
   Array ('id' => '347597', 'name' => 'Charls Brown', 'date' => '2009-03-26', 'punch_in' => '07:58', 'punch_out' => '11:55'),
   Array ('id' => '347598', 'name' => 'Charls Brown', 'date' => '2009-03-30', 'punch_in' => '08:09', 'punch_out' => '11:55'),
   Array ('id' => '347599', 'name' => 'Charls Brown', 'date' => '2009-03-31', 'punch_in' => '08:04', 'punch_out' => '11:55')
);

$arr2 = array(
   Array ('id' => '228996', 'name' => 'Charls Brown', 'date' => '2009-03-16', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229031', 'name' => 'Charls Brown', 'date' => '2009-03-17', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229032', 'name' => 'Charls Brown', 'date' => '2009-03-18', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229033', 'name' => 'Charls Brown', 'date' => '2009-03-19', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229329', 'name' => 'Charls Brown', 'date' => '2009-03-23', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229364', 'name' => 'Charls Brown', 'date' => '2009-03-24', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229365', 'name' => 'Charls Brown', 'date' => '2009-03-25', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229366', 'name' => 'Charls Brown', 'date' => '2009-03-26', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229706', 'name' => 'Charls Brown', 'date' => '2009-03-30', 'sched_in' => '8:00', 'sched_out' => '12:00'),
   Array ('id' => '229741', 'name' => 'Charls Brown', 'date' => '2009-03-31', 'sched_in' => '8:00', 'sched_out' => '12:00')
);

$result = array();
byDate($arr1, $result);
byDate($arr2, $result);

echo "<pre>".print_r($result,1)."</pre>";

Result:

h4x0rmx

@
Pretty impressive! I appreciate your help!
I never thought I would use the & operator to modify a variable by reference

h4x0rmx

With the solution that you gave me, I loose one of the id's because both of the arrays have a field called 'id', but they're different. I need to keep both of them.
I wrote the following function:

	function changeIdIndex(&$arr){
		if(!is_array($arr) || (count($arr)==0)){
			return;
		}

	for($i = 0; $i < count($arr); $i++){
		$arr[$i]['idPunches'] = $arr[$i]['id'];
	}
}

It duplicates the 'id' field with another key name (idPunches). I call my function before the byDate function.

$result = array();
changeIdIndex($array1);
byDate($arr1, $result);
byDate($arr2, $result);

It works as I expect it and need it to work.... but I was wondering if there's a better and/or easier way of doing it?