PHP - Unable to echo out values in returned array

Question

I have a function that retrieves data from a Mysql database, stores the values in an array and returns that array to the calling function.

$stmt = $dbh->prepare("SELECT img_file_name FROM mjbox_images JOIN mjbox_posts USING (post_id) WHERE post_active = 0 AND post_id = ? ");
        $stmt->bindParam(1,$post_id);
        $stmt->execute();

        $resultarray = array();

        while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

                $resultarray[] = $row;
        }

        return $resultarray;

I am attempting to echo out the $values within that array like this:

$resultarray = get_post_data($post_id);

print_r($resultarray);

foreach($resultarray as $key => $value){
    echo 'The value is: '. $value . '<br />';
}

But when I browse the webpage it is only echoing out "Array". When I print_r the array the values are definitely in the array. So how do I correctly display those values?

depends on array structure, loop through it as you do with foreach — Gntem
– Gntem, Commented Jun 6, 2012 at 10:20

Madara's Ghost · Accepted Answer · 2012-06-06 10:23:06Z

4

Makes sense. when you save $row to your array, you're actually creating a 2d array. $row is an array, even though you only selected one value. If you only want to save the image file name you selected, save $row['img_file_name'] to the array, instead if $row.

Alternatively, echo $value['img_file_name'] instead of $value.

answered Jun 6, 2012 at 10:23

Madara's Ghost

176k52 gold badges274 silver badges314 bronze badges

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

Comments

flowfree · Accepted Answer · 2012-06-06 10:20:04Z

1

Replace this line

$resultarray[] = $row;

with this:

$resultarray[] = $row['img_file_name'];

answered Jun 6, 2012 at 10:20

flowfree

16.5k12 gold badges55 silver badges79 bronze badges

1 Comment

flowfree Over a year ago

The result of his print_r is ok, but the result of his echo is Array.

Amarnasan · Accepted Answer · 2012-06-06 10:24:29Z

0

foreach($resultarray as $row){
    foreach($row as $key=>$value) {
        echo 'The value is: '. $value . '<br />';
    }
}

answered Jun 6, 2012 at 10:24

Amarnasan

15.7k7 gold badges35 silver badges38 bronze badges

Collectives™ on Stack Overflow

PHP - Unable to echo out values in returned array

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related