Display php result in an HTML table with specific format

Question

Basically this is my array

Array
(
    [0] => Array
        (            
            [mainProdName] => CellPhone           
            [mainproductname] => Array
                (
                    [0] => Array
                        (   
                            [subProdName] => TG8                           
                        )

                    [1] => Array
                        (  
                            [subProdName] => TG5                          
                        )

                )

        )

    [1] => Array
        (
            [mainProdName] => LapTop
            [mainproductname] => Array
                (
                    [0] => Array
                        (   
                            [subProdName] => TD9                          
                        )

                    [1] => Array
                        (                           
                            [subProdName] => TD7                            
                        )

                )

        )

    [2] => Array
        ( 
            [mainProdName] => Corn            
            [mainproductname] => Array
                (
                    [0] => Array
                        (                           
                            [subProdName] => SWEET CORN                            
                        )

                )

        )
)

I am trying to display this result in an HTML table

<table><tr>
    ?>
        for($j=0;$j<count($res);$j++)
        {
            ?><td>$res[$i].mainProdName}</td><?php
            for($k=0;$k<count($res[$i].mainproductname);$k++)
            {
                ?><td>$res[$i].mainproductname[$k].subProdName}</td><?php
            }
        }
    <?php
</tr></table>

For which i'm getting this.

----------------------------------------------------------------
CellPhone | TG8 | TG5 | LapTop | TD9 | TD7 | Corn | SWEET CORN  
----------------------------------------------------------------

Basically i need to display the result in this format

-------------------------------------------------------------------
       CellPhone       |        LapTop          |       Corn
-----------------------|------------------------|------------------
   TG8     |    TG5    |    TD9    |     TD7    |    SWEET CORN  
-------------------------------------------------------------------

For every main product, respective subproduct list should be displayed below in a separate row.

MATAR please check the answer below and check which one is correct for you. — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Feb 17, 2016 at 7:49

Sougata Bose · Accepted Answer · 2016-02-17 07:45:23Z

1

You can try this -

$first_tr = $second_tr = "<tr>";

foreach($array as $result) {

    // Print the first columns of first row with colspan
    $first_tr .= "<td colspan='" . count($result['mainproductname']) . "'>" . $result['mainProdName'] . "</td>";

    // Loop through the sub-products and print them
    foreach($result['mainproductname'] as $name) {
        $second_tr .= "<td>" . $name['subProdName'] . "</td>";
    }

}

echo $first_tr . "</tr>" . $second_tr . "</tr>";

Demo

edited Feb 17, 2016 at 7:45

answered Feb 17, 2016 at 7:30

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

Comments

Sahil Manchal · Accepted Answer · 2016-02-17 07:44:34Z

1

 <table>
 <thead>
    <tr>
    <?php for($i=0;$i<count($res);$i++){ ?>
        <th><?php echo $res[$i].mainProdName;?></th>
    <?php } ?>    
    </tr>
 </thead>
 <tbody>
 <?php for($i=0;$i<count($res);$i++){ ?>
 <tr>
    <?php for($j=0;$j<count($res);$j++){ ?>
    <td><?php echo $res[$i]["mainproductname"]['subProdName'][$j]; ?></td>
    <?php } ?>
 </tr>
 <?php } ?>
 </tbody>
 </table>

answered Feb 17, 2016 at 7:44

Sahil Manchal

4686 silver badges20 bronze badges

Comments

dhi_m · Accepted Answer · 2016-02-17 08:45:51Z

Please try this

$html ="<table border='1'>";
$html.="<tr>";
$innerhtml="<tr>";
foreach($arr as $key=>$valArr){

    $html.="<td>".$valArr['mainProdName']."</td>";
    if(count($valArr['mainproductname'])){
        $subValArr =array();
        foreach($valArr['mainproductname'] as $subKey => $subVals){
            $subValArr[] = $subVals['subProdName'];

        }
        $subArrString = implode("|", $subValArr);
        $innerhtml.="<td>".$subArrString."</td>" ;
    }


}
$innerhtml.="</tr>";
$html.=$innerhtml;
$html.="</tr>";
$html.="</table>";
echo $html;

Output :

chandni patel · Accepted Answer · 2016-02-17 07:30:00Z

-1

i m using this format to show php result in html table format

$con=mysql_connect("localhost","root");
mysql_select_db("aggregate",$con);
$q=mysql_query("SELECT ASCII('A');");
echo "<h2>ASCII Function</h2>";
echo "<br>";
echo "<table border=1>";
    echo "<tr><th> ASCII Function</th></tr>";


while($qq=mysql_fetch_row($q)){

    echo "<tr><td> ".$qq[0]. "</td></tr>";
}
echo "</table>";

answered Feb 17, 2016 at 7:30

chandni patel

1

1 Comment

Sougata Bose Over a year ago

This doesn't answer the question in anyways.

Collectives™ on Stack Overflow

Display php result in an HTML table with specific format

4 Answers 4

Comments

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Related