php array key issue with foreach loop and multi-dim arrays

Question

I have listed an example below. What I need is for $key to return the actual index number (position) in the array during the loop, but instead it is returning Array. The same code works fine when given a single dimension array, but not in the example below.

GIVEN:

$screenshots would be similar to the following with only more entries.

Array
(
    [0] => Array
        (
            [screenshot_id] => 871
            [image_filename] => DSCF0124.JPG
        )

)

PHP:

//build in clause & binding using selected array from above
$prefix = $in_clause = '';
$binding_clause = array();  
foreach($screenshots as $key)
{
    $in_clause .= $prefix.':selected_'.$key;
    $prefix = ', ';
    $binding_clause[':selected_'.$key] = $key['screenshot_id'];
}

RESULT:

$inclause = :selected_Array

$binding_clause = 

Array
(
    [:selected_Array] => 871
)

EXPECTED:

$inclause = :selected_0

$binding_clause = 

Array
(
    [:selected_0] => 871
)

AbraCadaver · Accepted Answer · 2014-09-08 18:40:04Z

2

Just because you call it $key doesn't make it a key. You need the key and the value (inner array):

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

answered Sep 8, 2014 at 18:40

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

Comments

Tango Bravo · Accepted Answer · 2014-09-08 18:40:13Z

1

You need to tell it that you want the KEY and the VALUE.

like this:

foreach($screenshots as $key=>$screenShot)

That will get you the key and the value.

answered Sep 8, 2014 at 18:40

Tango Bravo

3,3293 gold badges25 silver badges45 bronze badges

Comments

Fabio · Accepted Answer · 2014-09-08 18:40:29Z

1

You just need to change your foreach to cast keys and values

foreach($screenshots as $key => $val)

Now the key is in your $key variable while you can access elements with $val array, for example $key['screenshot_id']

You can have a check to documentation examples here

answered Sep 8, 2014 at 18:40

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Comments

iambriansreed · Accepted Answer · 2014-09-08 18:40:34Z

1

Try:

foreach($screenshots as $key => $screenshot)
{
    $in_clause .= $prefix.':selected_'.$key;
    $prefix = ', ';
    $binding_clause[':selected_'.$key] = $screenshot['screenshot_id'];
}

Read more about PHP foreach: http://php.net/manual/en/control-structures.foreach.php

answered Sep 8, 2014 at 18:40

iambriansreed

22.3k6 gold badges66 silver badges81 bronze badges

Collectives™ on Stack Overflow

php array key issue with foreach loop and multi-dim arrays

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related