How to merge multidimensional array to single dimension array?

Question

I have a class method which returns the result in multidimension. the method i am using is.

public function getUserRoles($userId) {
    $sth = $this->dbh->prepare('SELECT role_id FROM user_roles WHERE user_id = :userId');
    $sth->bindParam(':userId', $userId);
    $sth->execute();
    $roles = array();
    while($row = $sth->fetch(PDO::FETCH_ASSOC)) {
        $roles[] = array($row['role_id']);
    }
    return $roles;
}

and when i call the method

print_r($acl->getUserRoles(1));

the returned set of result i get is.

Array ( [0] => Array ( [0] => 1 ) [1] => Array ( [0] => 2 ) [2] => Array ( [0] => 3 ) [3] => Array ( [0] => 4 ) [4] => Array ( [0] => 5 ) )

However i do not want the values to be returned in multidimensional array instead i would like the above returned result to be.

Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 )

Is there any PHP's native function to take care of this?

Thank you

Jon · Accepted Answer · 2011-07-15 11:31:19Z

3

The fetchAll function serves this exact purpose if used with the PDO::FETCH_COLUMN option:

$roles = $sth->fetchAll(PDO::FETCH_COLUMN);
return $roles;

answered Jul 15, 2011 at 11:31

Jon

439k85 gold badges756 silver badges820 bronze badges

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

1 Comment

octern Over a year ago

Thank you! I was just about to ask this very question.

Shakti Singh · Accepted Answer · 2011-07-15 11:32:07Z

3

Change this line of code

$roles[] = array($row['role_id']);

to

$roles[] = $row['role_id'];

in getUserRoles method

answered Jul 15, 2011 at 11:32

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Collectives™ on Stack Overflow

How to merge multidimensional array to single dimension array?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related