ansaurus

Question

Output a php multi-dimensional array to a html table

Answer 1

+3 A:

How about this?

$keys = array_keys($_POST['order'][0]);
echo "<table><tr><th>".implode("</th><th>", $keys)."</th></tr>";
foreach ($_POST['order'] as $order) {
  if (!is_array($order))
    continue;
  echo "<tr><td>".implode("</td><td>", $order )."</td></tr>";
}
echo "</table>

St. John Johnson 2010-03-17 19:08:28

+1 for terseness - though this could provide incorrect output if any of the rows have different/additional columns (or if the keys are sorted differently).

mskfisher 2010-03-17 19:28:47

@mskfisher good point. You could replace line 6 with a for loop that iterates the $keys array and outputs accordingly. That would guarantee the output was in the correct order and only the keys we expect.

St. John Johnson 2010-03-17 19:46:47

If you're relatively confident in the number of columns, you could also call `ksort()` on the array to ensure it's in the right order.http://www.php.net/manual/en/function.ksort.php

mskfisher 2010-03-17 20:34:27

excelent! You made my day with this effective, great structured snippet!

milovanderlinden 2010-09-01 18:47:02

Answer 2

A:

A Table class I wrote some time ago

<?php
class Table {
    protected $opentable = "\n<table cellspacing=\"0\" cellpadding=\"0\">\n";
    protected $closetable = "</table>\n";
    protected $openrow = "\t<tr>\n";
    protected $closerow = "\t</tr>\n";

    function __construct($data) {
        $this->string = $this->opentable;
        foreach ($data as $row) {
            $this->string .= $this->buildrow($row);
        }
        $this->string .= $this->closetable;
    }

    function addfield($field, $style = "null") {
        if ($style == "null") {
            $html =  "\t\t<td>" . $field . "</td>\n";
        } else {
            $html = "\t\t<td class=\"" . $style . "\">"  . $field . "</td>\n";
        }
        return $html;
    }

    function buildrow($row) {
        $html .= $this->openrow;
        foreach ($row as $field) {
            $html .= $this->addfield($field);
        }
        $html .= $this->closerow;
        return $html;
    }

    function draw() {
        echo $this->string;
    }
}
?>

To be used like this :

<body>
<?php
$multiDimArray = []; # Turn the form array into a matrix
for ($i = 0; $i < count($_POST['order']); $i++) {
        $multiDimArray[] = [];
    foreach ($_POST['order'][$i] as $key=>$value) {
        if ($i == 0) {
            $multiDimArray[$i][] = $key;
        }
        $multiDimArray[$i][] = $value;
    }
}

$table = new Table($multiDimArray); # Create and draw the table
$table->draw();
?>
</body>

Powertieke 2010-03-17 19:14:56

Answer 3

+1 A:

In your HTML, try something like this:

<table>
<tr>
  <th>Bottom</th>
  <th>Slant</th>
  <th>Fitter</th>
</tr>
<?php foreach ($_POST['order'] as $order): ?>
  <tr>
    <td><?php echo $order['bottomdiameter'] ?></td>
    <td><?php echo $order['slantheight'] ?></td>
    <td><?php echo $order['fittertype'] ?></td>
  </tr>
<?php endforeach; ?>
</table>

Obviously, I'm not including all your attributes there, but hopefully you get the idea.

Jason Swett 2010-03-17 19:17:10

Wow, I've never seen someone use the alternate syntax for foreach loops. Neat!

St. John Johnson 2010-03-17 19:27:23

Thanks! St. John Johnson's solution also works, but your code is easier for me to read and tweak.

Fireflight 2010-03-18 16:00:13

ansaurus

tags:

views:

answers:

Output a php multi-dimensional array to a html table

related questions