PHP display associative array in HTML table

Question

Here is my associative array:

$req_data1[]=array(
    'depart1'=>$_REQUEST['to'],
    'd_time1'=>$d_time5,
    'stop'=>"",
    'leave_stop'=>"",
    'arrival1'=>$_REQUEST['from'],
    'a_time1'=>$end_time5,
    'price1'=>intval($final_price),
    'air_line'=>"xxxxx");

Here is my sorting algorithm:

foreach ($req_data as $key => $row) {
    $depart[$key]  = $row['depart'];
    $d_time[$key] = $row['d_time'];
    $stop[$key]  = $row['stop'];
    $leave_stop[$key] = $row['leave_stop'];
    $arrival[$key]  = $row['arrival'];
    $a_time[$key] = $row['a_time'];
    $price[$key] = $row['price'];
}

array_multisort($price,SORT_ASC, $req_data);

I am displaying the data after sorting:

foreach($req_data as $key=>$row) {
    echo "</br>";

    foreach($row as $key2=>$row2){
        echo $row2;
    }
}

My problem now is that I want to put that array into an HTML table but dont know how. This is my code which I tried so far but its not working:

$cols = 5; 

echo "<table border=\"5\" cellpadding=\"10\">"; 

for ($r=0; $r < count($row2); $r++) { 
    echo "<tr>"; 

    for ($c=0; $c<$cols; $c++) { 

        ?> <td> <?php $input[$r+$c] ?> </td> <?php 
        }

    echo "</tr>"; 
    $r += $c; 
}

echo "</table>";
?>

Could any one tell me what is wrong with my code, or how I can display this sorted data into a table? Thanks.

Can you please format your code so it's more readable? That will make it much easier for people to help you. — Cameron Skinner
– Cameron Skinner, Commented Jul 27, 2011 at 4:52

Dan Grossman · Accepted Answer · 2011-07-27 05:21:17Z

5

Why not just modify the loop you already use to display the data?

echo "<table>";
foreach($req_data as $key=>$row) {
    echo "<tr>";
    foreach($row as $key2=>$row2){
        echo "<td>" . $row2 . "</td>";
    }
    echo "</tr>";
}
echo "</table>";

answered Jul 27, 2011 at 5:21

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges

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

Comments

Austin DeVinney · Accepted Answer · 2012-07-23 19:36:09Z

1

$toOutput = '<table>';
$showHeader = true;
$memberData = $reportObj->getMemberData();
while($row = mysql_fetch_assoc($memberData))
{
    $toOutput .= '<tr>';

    //Outputs a header if nessicary
    if($showHeader)
    {
        $keys = array_keys($row);
        for($i=0;$i<count($keys);$i++)
        {
            $toOutput .= '<td>' . $keys[$i] . '</td>';
        }
        $toOutput .= '</tr><tr>';
        $showHeader = false;
    }

    //Outputs the row
    $values = array_values($row);
    for($i=0;$i<count($values);$i++)
    {
        $toOutput .= '<td>' . $values[$i] . '</td>';
    }

    $toOutput .= '</tr>';
}
$toOutput .= '</table>';

echo 'Test page';
echo $toOutput;

Sorry for the necro, but I was actually looking to see if there was a build-in function for this as I was writing this.

answered Jul 23, 2012 at 19:36

Austin DeVinney

2733 silver badges12 bronze badges

3 Comments

Sven Over a year ago

Are you actually asking a question in your answer field?

beppe9000 Over a year ago

Did you find a builtin function?

Austin DeVinney Over a year ago

No, I never found a nice built-in function. I imagine this is handled nicely in modern frameworks like Laravel. However, I have since moved on from PHP development.

Abby Chau Yu Hoi · Accepted Answer · 2019-03-03 18:26:16Z

1

     function DumpTable($array_assoc) {
        if (is_array($array_assoc)) {
            echo '<table class="table">';
            echo '<thead>';
            echo '<tr>';
            list($table_title) = $array_assoc;
            foreach ($table_title as $key => &$value):
                echo '<th>' . $key . '</th>';
            endforeach;
            echo '</tr>';
            echo '</thead>';
            foreach ($array_assoc as &$master):
                echo '<tr>';
                foreach ($master as &$slave):
                    echo '<td>' . $slave . '</td>';
                endforeach;
                echo '</tr>';
            endforeach;
            echo '</table>';
            return;
        }
    }

edited Mar 3, 2019 at 18:26

Abby Chau Yu Hoi

1,4083 gold badges16 silver badges38 bronze badges

answered Jul 22, 2017 at 18:55

Александър Асенов

211 bronze badge

1 Comment

MD XF Over a year ago

Hey, welcome to StackOverflow! Could you please explain your code and why it works?

drew010 · Accepted Answer · 2012-07-23 21:09:31Z

0

echo "<table border=\"5\" cellpadding=\"10\">";
for ($r=0; $r < count($row2); $r++) {
    echo "<tr>";
    for ($c=0; $c<$cols; $c++) { ?>
        <td> <?php $input[$r+$c] ?> </td>
    <?php }

    echo "</tr>";
    $r += $c;
}
echo "</table>";?>

Try something like this

echo "<table>";
for($r=0;$r<count($row2);$r++){
echo "<tr>";
for($c=0;$c<$cols;$c++){
echo "<td>".[VARIABLE YOU WANT TO PRINT]."</td>";
}
echo "</tr>";
}
echo "</table>";

edited Jul 23, 2012 at 21:09

drew010

70.3k11 gold badges144 silver badges174 bronze badges

answered Jul 27, 2011 at 5:22

yoyoyoyooyy

1

Comments

TheGodfather · Accepted Answer · 2018-06-15 00:20:55Z

0

you can try the following:

echo "The associative array<br>";
$computer=array("brand"=>"hp", "price"=>"800", "cpu"=>"core i7");
$keys=array_keys($computer);
echo "<table><tr>";
foreach($keys as $row){
    echo "<th style=\"border: solid 2px green\">".$row."</th>";
}echo "</tr><tr>";
foreach($computer as $col){
    echo "<td style=\"border: solid 2px blue\">".$col."</td>";
}echo "</tr></table>";

answered Jun 15, 2018 at 0:20

TheGodfather

214 bronze badges

Collectives™ on Stack Overflow

PHP display associative array in HTML table

5 Answers 5

Comments

3 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

3 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related