how to display comma separated values from multiple columns in php inside html table

Question

i have an sql table with three columns which have comma separated values, i am trying to print it inside an html table, my code looks like below:

<table class="table custom-table m-0">
  <thead>
    <tr>
      <th>Description</th>
      <th>Make</th>
      <th>UOM</th>
    </tr>
  </thead>
  <tbody>

    <?php 
    $one=explode(',', $row['description']);
    $two=explode(',', $row['make']);
    $three=explode(',', $row['uom']);
    foreach($one as $ones) {
     ?>
    <tr>
      <td>
        <?php echo $ones?>
      </td>
      <td></td>
      <td></td>

    </tr>
    <?php }?>
  </tbody>
</table>

here am only able to get the values of first column, can anyone please tell me how to get values from all the three columns, thanks in advance

Do all the fields have an equal amount of comma separated values? A hint: $one[0] returns the first value, $two[0] and $three[0] as well... — Marty McVry
– Marty McVry, Commented Jan 13, 2022 at 8:23
@mplungjan it works for first column, i want to display all three columns — love lio
– love lio, Commented Jan 13, 2022 at 8:26
Try fetching the number of values there are, and then looping through 0 --> numvalues - 1 using a regular for-loop. (Or a foreach with $key and $value pairing, so you can use $key as an index for $two and $three.) — Marty McVry
– Marty McVry, Commented Jan 13, 2022 at 8:33

mplungjan · Accepted Answer · 2022-01-13 08:30:12Z

1

Use a counter - assuming exact same number of entries per row

http://sandbox.onlinephpfunctions.com/code/555be47daf3bc3e99d496585f702bfc9dfae4e4e

<? 
$one=explode(',', $row['description']);
$two=explode(',', $row['make']);
$three=explode(',', $row['uom']);    
$i=0;
?>

<table class="table custom-table m-0">
  <thead>
    <tr>
      <th>Description</th>
      <th>Make</th>
      <th>UOM</th>
    </tr>
  </thead>
  <tbody>

    <?php 
    foreach($one as $ones) {
     ?>
    <tr>
      <td><?php echo $ones; ?></td>
      <td><?php echo $two[$i]?></td>
      <td><?php echo $three[$i]?></td>

    </tr>
    <?php $i++;}?>
  </tbody>
</table>

answered Jan 13, 2022 at 8:30

mplungjan

180k29 gold badges183 silver badges246 bronze badges

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

Collectives™ on Stack Overflow

how to display comma separated values from multiple columns in php inside html table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related