for each loop with specific key value in multidimensional array in PHP

Question

I've been using the following to build a clause for multiple deletes at once which works great. This was for single dimension arrays though.

$prefix = $in_clause = '';
$binding_clause = array();  
foreach($selected as $key => $value)
{
    $in_clause .= $prefix.':selected_'.$key;
    $prefix = ', ';
    $binding_clause[':selected_'.$key] = $value;
}

Now, I need to use it on a specific value of a multidimensional array. Given this :

Array
(
    [0] => Array
        (
            [account_id] => 2
            [screenshot_id] => 120262
            [image_filename] => a1.jpg
        )

    [1] => Array
        (
            [account_id] => 2
            [screenshot_id] => 120263
            [image_filename] => a2.jpg
        )
    .......

I only need the key value and the screenshot_id value so I am trying to change the first function so the values are :

key = 0, value = 120262
key = 1, value = 120263

Hopefully that makes sense. Not sure how to do this with a multi-array.

Barmar · Accepted Answer · 2015-02-05 06:38:01Z

1

Since the array elements are arrays, use array indexing to access that part of the elements:

foreach ($selected as $key => $value) {
    $binding_clause[':selected_'.$key] = $value['screenshot_id'];
}

answered Feb 5, 2015 at 6:38

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

1 Comment

user756659 Over a year ago

That's it. Guess I was overthinking it there as I didn't think value would take the array. Thanks!

Murtaza Khursheed Hussain · Accepted Answer · 2015-02-05 06:33:37Z

1

Assuming you have the array format as explained above.

for($i=0; $i<=$array.count(); $i++){
    foreach($array[$i] as $key => $value){
        echo "Key: ". $i . " Value:" . $key['screenshot_id']
    }
}

answered Feb 5, 2015 at 6:33

Murtaza Khursheed Hussain

15.4k7 gold badges62 silver badges83 bronze badges

1 Comment

Barmar Over a year ago

You don't need the nested loop.

Collectives™ on Stack Overflow

for each loop with specific key value in multidimensional array in PHP

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related