Get column values from an associative array in php

Question

I have an array of form:

$records = array(
    array(
        'id' => 2135,
        'first_name' => 'John',
        'last_name' => 'Doe',
    ),
    array(
        'id' => 3245,
        'first_name' => 'Sally',
        'last_name' => 'Smith',
    ),
    array(
        'id' => 5342,
        'first_name' => 'Jane',
        'last_name' => 'Jones',
    ),
    array(
        'id' => 5623,
        'first_name' => 'Peter',
        'last_name' => 'Doe',
    )
);

I want output like this :

EDIT:

 Array
    ( array('first_Name' => John),
      array('first_Name'=> Sally),
      array('first_Name'=> Jane),  
      array('first_Name'=> Peter)
    );

Can this be achieved??

how can be first_name as multiple index of array ?

Satish Sharma
– Satish Sharma

2014-05-21 06:47:02 +00:00
Commented May 21, 2014 at 6:47 — Satish Sharma
– Satish Sharma, Commented May 21, 2014 at 6:47
that has the same keys, that aint possible

user1978142
– user1978142

2014-05-21 06:49:06 +00:00
Commented May 21, 2014 at 6:49 — user1978142
– user1978142, Commented May 21, 2014 at 6:49
An associative array cant hold the same index key

Ranjith
– Ranjith

2014-05-21 06:50:36 +00:00
Commented May 21, 2014 at 6:50 — Ranjith
– Ranjith, Commented May 21, 2014 at 6:50

Community · Accepted Answer · 2017-05-23 12:20:54Z

3

You cannot do this since you can't have duplicate keys in an array.

Here is a related question: How to allow duplicate keys in a PHP array?

This article explains how PHP stores array internally: http://nikic.github.io/2012/03/28/Understanding-PHPs-internal-array-implementation.html.

Answer after your edit:

$arr = array();
foreach($records as $value) {
    $arr[] = array('first_name' => $value['first_name']);
}
print_r($arr);

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered May 21, 2014 at 6:50

Madhurendra Sachan

7608 silver badges23 bronze badges

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

5 Comments

Amal Over a year ago

+1. Or just: array_walk($records, function ($v, $k) use (&$arr) { $arr[] = ['first_name' => $v['first_name']]; });

asprin Over a year ago

And how is this any different from nl-x's answer? Add to that you edited your post after nl-x posted his answer

Madhurendra Sachan Over a year ago

@asprin Probably my typing speed is slower than nl-x . While i was typing he answered.

Amal Over a year ago

@asprin: It's not like there are thousand different ways to achieve this :-)

Madhurendra Sachan Over a year ago

@asprin For your happiness.It is different now.

nl-x · Accepted Answer · 2014-05-21 06:55:53Z

2

You can achieve your (edited) question like this:

$new_array = array();
foreach($records as $record)
    $new_array[] = array('first_Name'=>$records['first_name']);

answered May 21, 2014 at 6:55

nl-x

11.9k7 gold badges36 silver badges67 bronze badges

Comments

Hieu Vo · Accepted Answer · 2014-05-21 07:00:59Z

1

try this

$records = array(
    array(
        'id' => 2135,
        'first_name' => 'John',
        'last_name' => 'Doe',
    ),
    array(
        'id' => 3245,
        'first_name' => 'Sally',
        'last_name' => 'Smith',
    ),
    array(
        'id' => 5342,
        'first_name' => 'Jane',
        'last_name' => 'Jones',
    ),
    array(
        'id' => 5623,
        'first_name' => 'Peter',
        'last_name' => 'Doe',
    )
);

$tmp = array('first_name' => '');
foreach ($records as &$record) {
    $record = array_intersect_key($record, $tmp);
    // or $record = array('first_name' => $record['first_name']);
}
unset($record);

var_dump($records);

edited May 21, 2014 at 7:00

answered May 21, 2014 at 6:51

Hieu Vo

3,3441 gold badge33 silver badges32 bronze badges

Comments

Ranjith · Accepted Answer · 2014-05-21 07:06:47Z

1

If you want to array with in the array means, surely it will generated with index key, like this

 Array
    ( '0' => array('first_Name' => John),
      '1' => array('first_Name'=> Sally),
      '2' => array('first_Name'=> Jane),  
      '3' => array('first_Name'=> Peter)
    );

Try this one,

 foreach($records as $record) {
    $name_array[] = Array('first_Name' =>$record['first_name']);
 }
 print_r($name_array);

Your output will be,

Array
(
    [0] => Array
        (
            [first_Name] => John
        )

    [1] => Array
        (
            [first_Name] => Sally
        )

    [2] => Array
        (
            [first_Name] => Jane
        )

    [3] => Array
        (
            [first_Name] => Peter
        )

)

edited May 21, 2014 at 7:06

answered May 21, 2014 at 7:00

Ranjith

2,8393 gold badges24 silver badges42 bronze badges

1 Comment

Amal Over a year ago

This is the same as this answer and this one. Not sure if having another one with the same content is going to be helpful.

chh · Accepted Answer · 2014-08-12 09:55:51Z

1

To get your desired output you can use array_map, though you can get similar output with array_column which is new in PHP 5.5.

With `array_map` (http://3v4l.org/v8Y8Z):

<?php

$firstNames = array_map(function($record) {
    return ['first_name' => $record['first_name']];
}, $records);

With `array_column` (http://3v4l.org/ohnGu):

$firstNames = array_column($records, 'first_name');

Note: array_column doesn't make subarrays with the first_name key.

answered Aug 12, 2014 at 9:55

chh

5933 silver badges8 bronze badges

Comments

Satish Sharma · Accepted Answer · 2014-05-21 06:50:41Z

0

you can try this one

$arr_output = array();
foreach($records as $key=>$arr)
{
    $arr_output['id'][] = $arr['id'];
    $arr_output['first_name'][] = $arr['first_name'];
    $arr_output['last_name'][] = $arr['last_name'];
}

print_r($arr_output['first_name']); // display all first names
print_r($arr_output); // display complete output array.

Output :

Array
(
    [id] => Array
        (
            [0] => 2135
            [1] => 3245
            [2] => 5342
            [3] => 5623
        )

    [first_name] => Array
        (
            [0] => John
            [1] => Sally
            [2] => Jane
            [3] => Peter
        )

    [last_name] => Array
        (
            [0] => Doe
            [1] => Smith
            [2] => Jones
            [3] => Doe
        )

)

Demo

answered May 21, 2014 at 6:50

Satish Sharma

9,6356 gold badges31 silver badges52 bronze badges

2 Comments

asprin Over a year ago

This is not what the OP is askin

Satish Sharma Over a year ago

@user2129794 as i commented on your question same key is not possible in array. you can use it as i answered.

Amal · Accepted Answer · 2014-05-21 06:51:49Z

0

This is not possible, because you cannot have multiple elements of the same key in an associative array.

edited May 21, 2014 at 6:51

Amal

76.8k18 gold badges134 silver badges155 bronze badges

answered May 21, 2014 at 6:48

Sethunath K M

4,7694 gold badges31 silver badges42 bronze badges

5 Comments

asprin Over a year ago

Seriously? This constitutes as an answer?

asprin Over a year ago

@nl-x and Amal _ I wasn't saying the answer is wrong. What I was referring to is a single sentence being posted as an answer. It could well have been posted as a comment

nl-x Over a year ago

@asprin : I know that you meant that. So still, why not?

asprin Over a year ago

@nl-x meta.stackexchange.com/questions/118582/…

nl-x Over a year ago

@asprin : according to your link it IS an answer. (see #8 in of your link) It says it should be an answer, and should not be reported as NaA (Not an Answer)

Collectives™ on Stack Overflow

Get column values from an associative array in php

7 Answers 7

5 Comments

Comments

Comments

1 Comment

With `array_map` (http://3v4l.org/v8Y8Z):

With `array_column` (http://3v4l.org/ohnGu):

Comments

2 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

5 Comments

Comments

Comments

1 Comment

With array_map (http://3v4l.org/v8Y8Z):

With array_column (http://3v4l.org/ohnGu):

Comments

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related

With `array_map` (http://3v4l.org/v8Y8Z):

With `array_column` (http://3v4l.org/ohnGu):