creating a table using associative array

Question

i want to create a table using an associative key value pair array. i want its keys as column heading of the table and the values should be in corresponding rows cells. array may look like it

and table should look like this i am having problem in creating thead dynamically and putting corresponding values in the columns below it

What you have tried so far. Post your attempts.

Narendrasingh Sisodia
– Narendrasingh Sisodia

2016-02-17 11:14:02 +00:00
Commented Feb 17, 2016 at 11:14 — Narendrasingh Sisodia
– Narendrasingh Sisodia, Commented Feb 17, 2016 at 11:14

Kamaldeep singh Bhatia · Accepted Answer · 2016-02-17 13:18:50Z

2

Try this:

<?php 
foreach ($table as $rowIndex=>$row) {
  if($rowIndex == 0) {
     echo "<thead><tr>";
     foreach ($row as $columnName=>$cell) {
        if(strpos($columnName, "field") === true) {
           echo "<td>$columnName</td>";
        }
     }
     echo "</tr></thead>";
    }
    echo "<tr>";
    foreach ($row as $columnName=>$cell) {
        if(strpos($columnName, "field") === true) {
           echo "<td>$cell</td>";
        }
    }
    echo "</tr>";
}
?>

more about strpos

edited Feb 17, 2016 at 13:18

answered Feb 17, 2016 at 11:24

Kamaldeep singh Bhatia

7326 silver badges19 bronze badges

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

10 Comments

Pritam Jinal Over a year ago

well it does help.. but i have other key value pairs in that array out of which i want to show just these 10. do u know how do i exclude them.

Kamaldeep singh Bhatia Over a year ago

in main array or with field1 field2 etc?? just give an example so that we can figure it out. There would be some combination present on which we can filter those keys

Pritam Jinal Over a year ago

not in main array.. with field1 field2... ex:

Array (     [0] => Array         (             [id]=>45             [name]=>'abc'             [field1] => 18270             [field2] => 24             [field3] => 7830             [field4] => 44             [field5] => 5             [field6] => 15660             [field7] => 77             [field8] => 0             [asddfasd] => 3454             [field9] => 0             [field10] => 0             ['end'] =>              [field11] => null         )

Arty2 Over a year ago

On the code above, you could try adding this inside the first foreach: if ($columnName == 'field11') { break; }. However you are not helping yourself by showing partial code and letting us guess.

Kamaldeep singh Bhatia Over a year ago

better to create a temp array of these fields (which you want to use) inside first fooreach loop and then use it in nested foreach

|

Arty2 · Accepted Answer · 2016-02-17 11:26:51Z

1

Though not pretty, the following should do it:

<?php
echo '<table>';
foreach (array_name as $row => $columns) {
    if ($row == 0) { //if it's the first row in our dataset
        //first print the table header
        echo '<thead><tr>';
        foreach ($columns as $header => $value) {
            echo '<th>' . $header . '</th>';
        }
        echo '</tr><thead>';
    }
        //then print the data as usual
        echo '<tr>';
        foreach ($columns as $header => $value) {
            echo '<td>' . $value . '</td>';
        }
        echo '</tr>';
}
echo '</table>';
?>

PS: beat to the punch by kamaldeep-singh-bhatia :)

answered Feb 17, 2016 at 11:26

Arty2

1313 bronze badges

Collectives™ on Stack Overflow

creating a table using associative array

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related