How do I get corresponding keys to another key from multidimensional array?

Question

I have a multidimensional array in the following format:

$array = array (
  0 => 
    array (
      'date' => '2013-03-25',
      'name' => 'Bob',
      'time' => '11'
    ),
  1 => 
    array (
      'date' => '2013-03-25',
      'name' => 'Brian',
      'time' => '13'
    ),
  2 => 
    array (
      'date' => '2013-03-26',
      'name' => 'Jack',
      'time' => '14'
    ),
  3 => 
    array (
      'date' => '2013-03-26',
      'name' => 'Bob',
      'time' => '14'
    )
);

I am trying to get the names and corresponding times for each date. I have got the names using the following method:

$array2 = array();
    foreach($array as $item) {
    $array2[$item['date']][] = $item['name'];
    }

and then using:

foreach($array2[$date] as $name)

to run a query on the names returned. But I am not sure how to get the corresponding 'time' key for each 'name' key in the second foreach loop.

Mikhail Chernykh · Accepted Answer · 2013-03-27 21:55:56Z

2

Why you don't want to store both name and time for each date key?

$array2 = array();
foreach ($array as $item) {
  $array2[$item['date']] []= array($item['time'], $item['name']);
}

You can reach name and time with this code:

foreach ($array2 as $row) {
  $name = $row[0];
  $time = $row[1];
}

answered Mar 27, 2013 at 21:55

Mikhail Chernykh

2,69722 silver badges15 bronze badges

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

1 Comment

Nick Over a year ago

Ah, yes, that's the way to do it. Thanks.

Baba · Accepted Answer · 2013-03-27 21:57:34Z

1

You can try

$list = array();
foreach ( $array as $k => $item ) {
    $list[$item['date']][] = array(
            $item['name'],
            $item['time']
    );
}

foreach ( $list as $date => $data ) {
    echo $date, PHP_EOL;
    foreach ( $data as $var ) {
        list($name, $time) = $var;
        echo $name, " ", $time, PHP_EOL;
    }
    echo PHP_EOL;
}

Output

2013-03-25
Bob 11
Brian 13

2013-03-26
Jack 14
Bob 14

answered Mar 27, 2013 at 21:57

Baba

95.3k29 gold badges172 silver badges222 bronze badges

Comments

Mikhail Chernykh · Accepted Answer · 2013-03-27 22:04:00Z

0

try the following:

foreach($array as $item) {
   $array2[$item['date'][] = array('name' => $item['name'], 'time' => $item['time']);
}

foreach($array2[$date] as $name) {
   echo $name['name'] . ' => ' . $name['time'] . "\n";
}

edited Mar 27, 2013 at 22:04

Mikhail Chernykh

2,69722 silver badges15 bronze badges

answered Mar 27, 2013 at 21:57

GGio

7,67311 gold badges48 silver badges85 bronze badges

Collectives™ on Stack Overflow

How do I get corresponding keys to another key from multidimensional array?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related