PHP search line in array

Question

i have a result on mysql where i have a lot of lines and a lot of columns. i need to echo a specific line that i don't know.

Example:

Array
(
    [0] => Array
        (
            [0] => 195
            [id_privilegios] => 195
            [1] => 206
            [id_usuario] => 206
            [2] => 10
            [id_menu] => 10
            [3] => S
            [consultar] => S
            [4] => 
            [inserir] => 
            [5] => S
            [alterar] => S
            [6] => 
            [excluir] => 
        )

    [1] => Array
        (
            [0] => 194
            [id_privilegios] => 194
            [1] => 206
            [id_usuario] => 206
            [2] => 9
            [id_menu] => 9
            [3] => S
            [consultar] => S
            [4] => S
            [inserir] => S
            [5] => S
            [alterar] => S
            [6] => S
            [excluir] => S
        )

    [2] => Array
        (
            [0] => 193
            [id_privilegios] => 193
            [1] => 206
            [id_usuario] => 206
            [2] => 1
            [id_menu] => 1
            [3] => S
            [consultar] => S
            [4] => S
            [inserir] => S
            [5] => S
            [alterar] => S
            [6] => S
            [excluir] => S
        )

    [3] => Array
        (
            [0] => 224
            [id_privilegios] => 224
            [1] => 206
            [id_usuario] => 206
            [2] => 56
            [id_menu] => 56
            [3] => S
            [consultar] => S
            [4] => S
            [inserir] => S
            [5] => S
            [alterar] => S
            [6] => 
            [excluir] => 
        )

    [4] => Array
        (
            [0] => 223
            [id_privilegios] => 223
            [1] => 206
            [id_usuario] => 206
            [2] => 52
            [id_menu] => 52
            [3] => S
            [consultar] => S
            [4] => S
            [inserir] => S
            [5] => S
            [alterar] => S
            [6] => S
            [excluir] => S
        )

)

i have this array for example and i want to show the value of "consultar" column where id_menu = 7

how i can echo this ?

thanks

By iterating through the array and checking the ['id_menu'] key? — h2ooooooo
– h2ooooooo, Commented Mar 6, 2014 at 15:15
You can get a formatted output by wrapping the print_r() statement in <pre> tags like so: echo '<pre>'.print_r($yourArray, TRUE).'</pre>';. — Amal
– Amal, Commented Mar 6, 2014 at 15:17
This has been answered before, have a look: stackoverflow.com/a/1019126/407697 — sprain
– sprain, Commented Mar 6, 2014 at 15:20
Would it make more sense to change your query so you only got the result where the id_menu value matches what you want? What you are doing may make sense for your situation, but it's often best to query so your result data better matches up with your needs. — Surreal Dreams
– Surreal Dreams, Commented Mar 6, 2014 at 15:30

hindmost · Accepted Answer · 2014-03-06 15:53:22Z

1

You may use array_filter in conjunction with array_map.

$result = array_map(
    function ($v) {
        return $v['consultar'];
    },
    array_filter($array, function ($v) {
        return $v['id_menu'] == 7;
    })
);
print_r($result);

edited Mar 6, 2014 at 15:53

answered Mar 6, 2014 at 15:29

hindmost

7,1713 gold badges33 silver badges42 bronze badges

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

3 Comments

Guhh Over a year ago

it is missing an ")" i change to array_filter($array, function ($v)) { but it doesnt work "/

Guhh Over a year ago

Parse error: syntax error, unexpected T_FUNCTION, expecting ')'

hindmost Over a year ago

Update your PHP version to 5.3+

vogomatix · Accepted Answer · 2014-03-06 15:40:13Z

0

If only one item, you'll have to iterate through and find the matching element, if more than one item, one way is to use array_filter to filter out all the matching array elements.

function myFilter( $row) {
   return ($row['id_menu'] == 7);
}

$matches = array_filter($my_array, "myFilter");
foreach ($matches as $element) {
   echo "Menu Id: {$element['id_menu']} Consultar: {$element['consultar']}";
}

edited Mar 6, 2014 at 15:40

answered Mar 6, 2014 at 15:27

vogomatix

5,1352 gold badges27 silver badges51 bronze badges

Comments

Burhan Çetin · Accepted Answer · 2014-03-06 15:27:03Z

0

foreach($arr as $key=>$value){
    if(isset($arr[$key]["id_menu"]) && $arr[$key]["id_menu"] == 7){
         echo $arr[$key]["consultar"];
    }
}

answered Mar 6, 2014 at 15:27

Burhan Çetin

6867 silver badges16 bronze badges

1 Comment

Guhh Over a year ago

Warning: Invalid argument supplied for foreach()

Collectives™ on Stack Overflow

PHP search line in array

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related