Transforming mysql result array

Question

I have

$query = "SELECT
PrivilageName,
PrivilageExp,
'true' hakkivarmi
FROM users
natural join usermemberships
natural join groupprivileges
natural join `privileges`
where UserID = '2' ";

$result = mysqli_query($link, $query);

$rows = Array();
while($row = mysqli_fetch_assoc($result)) {
    array_push($rows, $row);
}

print_r($rows);exit;

And it prints out

Array
(
    [0] => Array
        (
            [PrivilageName] => AddBuilding
            [PrivilageExp] => Bina Ekleme
            [hakkivarmi] => true
        )

    [1] => Array
        (
            [PrivilageName] => RemoveBuilding
            [PrivilageExp] => Bina Silme
            [hakkivarmi] => true
        )

    [2] => Array
        (
            [PrivilageName] => EditBuilding
            [PrivilageExp] => Bina Düzenleme
            [hakkivarmi] => true
        )

)

And what I want is

Array
(
 AddBuilding => true
 RemoveBuilding => true
 EditBuilding => true
)

I have tried many different things but no success. How I'll do it?

Colin M · Accepted Answer · 2013-02-11 14:13:28Z

1

$permissions = array();

while($row = mysqli_fetch_assoc($result)) {
    $permissions[$row['PrivilageName']] = true; // You can use $row['hakkivarmi'] but it looks like it's always true based on your code
}

var_dump($permissions);

answered Feb 11, 2013 at 14:13

Colin M

13.4k3 gold badges42 silver badges61 bronze badges

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

Comments

Bhavik Shah · Accepted Answer · 2013-02-11 14:13:55Z

1

foreach($rows as $key => $value){
    $f[$value['PrivilageName']] = $value['hakkivarmi']
}

var_dump($f);

answered Feb 11, 2013 at 14:13

Bhavik Shah

2,2911 gold badge18 silver badges32 bronze badges

Collectives™ on Stack Overflow

Transforming mysql result array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related