How to get array output in html table

Question

What I would like to do is the following:

I have an SQL query that give's me an output. On that output 1 make an selection in php.

$cities[$row['stad']][$row['status']]++

This gives me an output like this (within a <pre> tag ):

Array
(
    [Amsterdam] => Array
        (
            [41] => 2
            [21] => 91
            [43] => 16
            [42] => 2
            [20] => 30
            [4] => 4
            [70] => 3
            [84] => 8
            [46] => 4
            [45] => 5
            [999] => 26
            [47] => 2
            [3] => 8
            [44] => 1
            [40] => 1
            [93] => 5
            [56] => 3
            [61] => 3
            [79] => 3
            [48] => 2
            [50] => 5
            [10] => 10
            [52] => 2
            [120] => 1
            [95] => 1
            [1] => 65
            [90] => 6
        )

I would like to put in an html table like so :

City        41  21  43  42  20  7   …… etc 
amsterdam   2   91  16  2   30  4   …… etc

important to know is there are more than 1 city.

This is what I have at the moment :

echo '<table cellpadding="10" cellspacing="10" border="1">';

foreach($cities as $city) { 
    echo '<tr>';
    echo '<td>' . $row['stad'] . '</td>';
    echo '<td>' . $city[$row['status']] . '</td>';

    echo '</tr>';
}

echo '</table>';

The first row of your table represents the table head ? I mean you put "City" in the first column, but values in others, are these values always the same ? — Jérémy Halin
– Jérémy Halin, Commented Jan 8, 2016 at 10:51
the first row does represent the head of the table it could be that not every city has values on each row but then it is just empty . the value per city is always different — Rahul Sharma
– Rahul Sharma, Commented Jan 8, 2016 at 10:52

Barmar · Accepted Answer · 2016-01-08 11:20:45Z

1

You need another array that lists all the heading values; in my code below I call this array $headings. This is because the values for each city may have their keys in a different order, and there may be missing keys, so just looping through the city arrays won't get consistent values on each row.

$headings = array(41, 21,  43,  42,  20,  7, etc.); 

echo '<table cellpadding="10" cellspacing="10" border="1">';
echo '<tr><th>City</th>';
foreach ($headings as $h) {
    echo "<th>$h</th>";
}
echo '</tr>';

foreach($cities as $cityname => $city) { 
    echo '<tr>';
    echo "<td>$cityname</td>";
    foreach ($headings as $h) {
        echo '<td>' . (isset($city[$h]) ? $city[$h] : '') . '</td>';
    }    
    echo '</tr>';
}

echo '</table>';

edited Jan 8, 2016 at 11:20

answered Jan 8, 2016 at 11:11

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

13 Comments

Rahul Sharma Over a year ago

this gives me an output with just a table with the word city in it

Barmar Over a year ago

Add error_reporting(E_ALL); to the beginning, do you get any warnings?

Rahul Sharma Over a year ago

Yes i did get warnings like Warning: Invalid argument supplied for foreach() in /Applications/XAMPP/xamppfiles/htdocs/locationboard/index.php on line 55 but I turned of all te errors with error_reporting(0);

Barmar Over a year ago

Don't turn off errors when you're trying to debug a script.

Rahul Sharma Over a year ago

foreach ($headings as $h) {

|

jilesh · Accepted Answer · 2016-01-08 11:01:15Z

0

use foreach with $key element so you get key directly into it

change this code

foreach($cities as $city) { 
    echo '<tr>';
    echo '<td>' . $row['stad'] . '</td>';
    echo '<td>' . $city[$row['status']] . '</td>';

    echo '</tr>';
}

to

foreach($cities as $key=> $city) { 
    echo '<tr>';
    echo '<td>' . $key. '</td>';
    echo '<td>' . $city . '</td>';

    echo '</tr>';
}

edited Jan 8, 2016 at 11:01

answered Jan 8, 2016 at 10:53

jilesh

5361 gold badge3 silver badges13 bronze badges

Comments

Anmol Garg · Accepted Answer · 2016-01-08 11:04:14Z

0

try this -

<?php
echo '<table cellpadding="10" cellspacing="10" border="1">';
foreach($cities as $city):
foreach($city as $k => $v)
{
echo "<tr><td>$k</td><td>$v</td></tr>";
}
endforeach;
?>

answered Jan 8, 2016 at 11:04

Anmol Garg

816 bronze badges

2 Comments

Barmar Over a year ago

This will put each key and value on a separate row, instead of having all the values for a city on the same row.

Rahul Sharma Over a year ago

That is true I tried to run it but it gives me an output like @Barmar predicted

Peter · Accepted Answer · 2016-01-08 11:05:03Z

0

Simply use a foreach on the array to build your table.

<table>
    <tbody>
        <?php foreach ($cities as $key => $value): ?>
        <tr>
            <td><?= $key; ?>
            <?php foreach ($value as $subkey => $subvalue): ?>
                <td><?= $subvalue; ?> </td>
            <?php endforeach; ?>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>

In steps:

Loop through all cities
Since every city has its own sub array, we will then loop through that array

edited Jan 8, 2016 at 11:05

answered Jan 8, 2016 at 10:52

Peter

9,1858 gold badges69 silver badges100 bronze badges

Collectives™ on Stack Overflow

How to get array output in html table

4 Answers 4

13 Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

13 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related