[RESOLVED] Iterating 'foreach'

damienmcd

I'm working on a project where I have to take data from a mysql DB and output it into a graph. I have the connections set up and it queries the DB and returns the data.

I have a while loop to get the rows of data and the foreach goes through the result set and prints it in a HTML table.

Problem is I need to save each of the values that the foreach is outputting but can't seem to access them after the foreach is finished.

Any ideas? Code I'm using is below;

// printing table rows
while($row = mysql_fetch_row($result))
{
echo "<tr>";

// $row is array... foreach( .. ) puts every element
// of $row to $cell variable
$cellindex = 1;
	$cellindex = $cellindex +1;

foreach($row as $cell)
    print "<td>$cell</td>";
	$arr = array("data".$cellindex."series1" => $cell);
echo "</tr>\n";

}

squiggerz

I'm probably not going to be of much help here, I'm very green to scripting in general, but where you have

$cellindex = 1;
$cellindex = $cellindex + 1;

shouldnt that go inside a separate while loop or something like (warning: this may be more 'pseudo-code' than anything else)

$cellindex = 1;
while ($cellindex <= 1)  {
$cellindex + 1;
}

or maybe just add to original while loop like

while ($row = mysql_fetch_row($result) && $cellindex <= 1) 
{
echo "<tr>";

I'm sure your question will be answered thoroughly very soon (if not already during my post) by a regular who knows what they are talking about, but if this somehow helps out (or not) let me know so I can post accordingly to my skill set in the future lol 😃

laserlight

Well, the first problem is that your foreach loop's body has more than one statement, but you did not use braces to enclose them. The other problem is that $arr is created (and destroyed) on each iteration of the outer loop. You might actually want it to be a two dimensional array, and then add an array of cells to it on each iteration of the outer loop.

$arr = array(); // 2 dimensional array to contain table rows and their contents.

while ($row = mysql_fetch_row($result))
{
    echo "<tr>";

// Print the fields retrieved for this row and save them into $arr.
$cellindex = 1;
$temp = array();
foreach ($row as $cell)
{
    echo "<td>$cell</td>";
    $temp[] = array("data" . $cellindex . "series1" => $cell);
    ++$cellindex;
}
$arr[] = $temp;

echo "</tr>\n";
}

damienmcd

Thanks laserlight,
worked a treat!

bradgrafelman

Don't forget to mark this thread resolved.