PHP echo array value after while loop

Question

How can I echo out value after the while loop. If I do the echo in below code its says Undefined index.

$sql_cast = "SELECT *
            FROM
              title_cast
              INNER JOIN title ON (title_cast.id_title = title.id)
              INNER JOIN `cast` ON (title_cast.id_cast = `cast`.id)
            WHERE
              title_cast.id_title = '1'";
$result_cast = mysql_query($sql_cast) or die('log error with' .mysql_error());
$cast = array();
while ($row = mysql_fetch_assoc($result_cast)) {
                $id = $row['id'];
                $name = $row['name'];
                $img = $row['photo_localurl'];
                $poster = str_replace("./", "lib/", $img);

                $cast[] = array('id' => $id, 'name' => $name, 'img' => $poster);
                //$cast[] = $row;
                }
                //var_dump($cast);
                echo $cast['id'] . " " . $cast['name'] . " " . $cast['poster']."<br />";

Try var_dump($row) first in the while loop. Also, I would expect while( ($row = mysql_fetch_assoc($result_cast)) !== FALSE ) { or similar — Aram Kocharyan
– Aram Kocharyan, Commented Feb 3, 2012 at 8:57

Oldskool · Accepted Answer · 2012-02-03 08:57:56Z

Within the while loop, you set the cast array content using $cast[] syntax. This will create a numerical index, starting at 0, then 1 and so on, so you're creating an array that looks like this:

$cast = array(
    0 => array('id' => $id, 'name' => $name, 'img' => $poster),
    1 => array('id' => $id, 'name' => $name, 'img' => $poster)
);

You need to include the numerical key of the array that you want to echo. For example, if you want to echo the first row:

echo $cast[0]['id']; // Echo the id of the first result

If you want to echo ALL of the rows, use foreach:

foreach($cast as $row) {
    echo $row['id'];
}

Franquis · Accepted Answer · 2012-02-03 08:58:30Z

0

Maybe you should do:

$cast = array('id' => $id, 'name' => $name, 'img' => $poster);
                //$cast[] = $row;
                }
                //var_dump($cast);
echo $cast['id'] . " " . $cast['name'] . " " . $cast['poster']."<br />";

because if you use $cast[], it will append the new array to your array..

answered Feb 3, 2012 at 8:58

Franquis

7431 gold badge5 silver badges17 bronze badges

Comments

ThomasM · Accepted Answer · 2012-02-03 08:58:45Z

That's because you are pushing a new array in $cast at each index..

So you should echo like this..

$i = 0;
while ($row = mysql_fetch_assoc($result_cast)) {
      $id = $row['id'];
      $name = $row['name'];
      $img = $row['photo_localurl'];
      $poster = str_replace("./", "lib/", $img);

      $cast[] = array('id' => $id, 'name' => $name, 'img' => $poster);
      //$cast[] = $row;

      //var_dump($cast);
      echo $cast[$i]['id'] . " " . $cast[$i]['name'] . " " . $cast[$i]['poster']."<br />";
      $i++;
}

Mas User · Accepted Answer · 2012-02-03 09:03:13Z

0

Try this:

<?php
while ($row = mysql_fetch_assoc($result_cast)) {
      $id = $row['id'];
      $name = $row['name'];
      $img = $row['photo_localurl'];
      $poster = str_replace("./", "lib/", $img);

      $cast[] = array('id' => $id, 'name' => $name, 'img' => $poster);
}

foreach($cast as $rows) {
    echo $rows['id']." ".$rows['name']." ".$rows['img']."<br />";
}
?>

answered Feb 3, 2012 at 9:03

Mas User

1662 gold badges5 silver badges17 bronze badges

Comments

musefan · Accepted Answer · 2012-02-03 09:12:43Z

0

print_r($cast[0]); or you can use $cast[0]['id'] ;

edited Feb 3, 2012 at 9:12

musefan

48.5k21 gold badges144 silver badges193 bronze badges

answered Feb 3, 2012 at 9:02

Sahin Yanlık

1,2012 gold badges12 silver badges21 bronze badges

Comments

Amna Ahmed · Accepted Answer · 2012-02-03 09:13:17Z

0

There are two problems with your code, First is that $cast[] is a two-dimensional array so it contains arrays at each of its index, so you must use

$cast[$i]['id']

Where i will be the counter variable that will iterate through all the indexes. Secondly change

$cast['poster']

to

$cast['img']

Hope this helps.

answered Feb 3, 2012 at 9:13

Amna Ahmed

1,9644 gold badges20 silver badges25 bronze badges

Collectives™ on Stack Overflow

PHP echo array value after while loop

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Related