change sql result array to wanted format in cakephp

Question

i'm getting a array of user names doing a sql query.it's like this

Array ( 
    [0] => Array (
        [users] => Array (
            [displayname] => Mark
        )
    )
    [1] => Array ( 
        [users] => Array ( 
            [displayname] => Helan
        )
    )
    [2] => Array ( 
        [users] => Array ( 
            [displayname] => Shaun
        )
    )
    [3] => Array ( 
        [users] => Array ( 
            [displayname] => Basu
        )
    )
    [4] => Array ( 
        [users] => Array ( 
            [displayname] => Charit
        )
    )
    [5] => Array ( 
        [users] => Array ( 
            [displayname] => Chris
        )
    )
    [6] => Array ( 
        [users] => Array ( 
            [displayname] => Tony
        )
    )
    [7] => Array ( 
        [users] => Array ( 
            [displayname] => Sam
        )
    )
    [8] => Array ( 
        [users] => Array ( 
            [displayname] => Duck
        )
    )
    [9] => Array ( 
        [users] => Array ( 
            [displayname] => Frank
        )
    )
)

i want to recreate the array to this format

Array ( 'Mark' => 'Mark','Helan' => 'Helan' , ..........,'Frank'=>'Frank')

How can i do this?

Anh Pham · Accepted Answer · 2011-09-16 17:21:07Z

2

$users = $this->User->find('list',array('fields'=>array('displayname','displayname')));

answered Sep 16, 2011 at 17:21

Anh Pham

5,4713 gold badges25 silver badges27 bronze badges

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

1 Comment

icc97 Over a year ago

I think that that won't give you the displayname as the key

pleasedontbelong · Accepted Answer · 2011-09-16 14:59:47Z

2

if you use the find('list') method, you could specify the fields and the result would be a simple key/value array.

Another way to do it is using the Set Object from the Core utility library. See the extract() method

Hope this helps

answered Sep 16, 2011 at 14:59

pleasedontbelong

20.1k12 gold badges55 silver badges79 bronze badges

Comments

Pierre MARTIN · Accepted Answer · 2011-09-16 15:26:00Z

1

It seems that Set::extract() is what you need here, with array_combine(). Here is an example:

// $data contains your find result
$names = Set::extract('/users/displayname', $data);
$formattedData = array_combine($names, $names)

answered Sep 16, 2011 at 15:26

Pierre MARTIN

863 bronze badges

Comments

icc97 · Accepted Answer · 2011-09-23 13:26:57Z

1

What you're actually asking for is Set::combine which is basically a combination of what Pierre MARTIN suggests.

$names = Set::combine($data, '{n}.users.displayname', '{n}.users.displayname');

answered Sep 23, 2011 at 13:26

icc97

13.1k9 gold badges84 silver badges99 bronze badges

Collectives™ on Stack Overflow

change sql result array to wanted format in cakephp

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related