Building table by column rather than by row

stephdumais

Hello,
I'm currently looking for a way to populate some html tables of varying lenghts and widths, pulling the data from arrays.
I want to achieve this with a function in order to make this as dynamic as possible.

example:

function build_table($data){ ... }

$data would be an array containing a varying number of sub-arrays, the first array would populate the first row (column headings) and each subsequent array would be the data for each column rather than each row.

Thus the table would be build as such:

row 1 = array1[1],array2[1],array3[1]...
row 2 = array1[2],array2[2],array3[2]...
row 3 = array1[3],array2[3],array3[3]...

In other words, I would like each specific key value from each array to be merged into new arrays that form the rows.

Let me know if this is clear enough...if so, does anyone have any ideas?

Thank you!

bpat1434

It's been done before, and it's posted on this board.

Vertical Horizontal Looper

It's not exactly what you want, but you can see how I implemented it in that example.

stephdumais

I couldnt quite get it to work with the way my arrays are fed to it 🙁

Here's my particular setup:

$data = array(
            array('1','2','3','4'),
            array('5','6','7','8'),
            array('9','10','11','12'),
       );

Each sub-array in my $data should be a column, while each element in the sub-arrays should become a row, resulting in a table like this:

1 | 5 | 9
2 | 6 | 10
3 | 7 | 11
4 | 8 | 12

Now I'm not sure how to loop this... Any ideas?

stephdumais

Someone on phpfreaks.com gave me the perfect solution:

<?php 
$data = array(
            array('1','2','3','4'),
            array('5','6','7','8'),
            array('9','10','11','12'),
       );

echo "<table border='1'>";

for ($r = 0; $r < 4; $r++) {
    echo '<tr>';
    for ($c = 0; $c < 3; $c++) {
        echo '<td>', $data[$c][$r], '</td>';
    }
    echo '</tr>';
}
echo "</table>";       

?>

bpat1434

Which is exactly my code, just condensed...

Glad someone got it working.