Display multiple arrays in a html table

Question

I'm trying to display multiple arrays into a table so that each value is on a separate line within the table.

This is my current setup:

<?php

$id = $_GET['id'];

$result = mysqli_query($mysqli, "SELECT * FROM invoices WHERE id=$id");

while($res = mysqli_fetch_array($result))
{
?>

 <tr>
   <td><? echo $res['partnumber']; ?></td>
   <td><? echo $res['partdescription']; ?></td>
   <td><? echo $res['partprice']; ?></td>
   <td><? echo $res['partquantity']; ?></td>

<?php
    }

?>

Which displays the following:

Screenshot

instead i need it to display each value on a separate line

I tried the following but it duplicates its value over and over again.

<? foreach ($res as $row) : ?>
 <tr>
   <td><? echo $row['partnumber']; ?></td>
   <td><? echo $row['partdescription']; ?></td>
   <td><? echo $row['partprice']; ?></td>
   <td><? echo $row['partquantity']; ?></td>
 </tr>
 <? endforeach; 
 }
 ?>

looks like your values are concatenated strings. Is "asdf, aasdfas, asdf" single database value? — vp_arth
– vp_arth, Commented Nov 8, 2016 at 5:40
$partnumber = $_POST['partnumber']; $partnumberarray = implode( ", ", $partnumber); — JCD
– JCD, Commented Nov 8, 2016 at 15:19

Nima Ghotbi · Accepted Answer · 2016-11-08 05:24:39Z

1

First of all, your code is vulnerable to SQL injection, make sure to secure $id (ex. $id = (int)$_GET['id'];) before putting it into your query string.

then try:

while($res = mysqli_fetch_array($result))
{
?>
 <tr>
   <td><? echo $res['partnumber']; ?></td>
 </tr><tr>
   <td><? echo $res['partdescription']; ?></td>
 </tr><tr>
   <td><? echo $res['partprice']; ?></td>
 </tr><tr>
   <td><? echo $res['partquantity']; ?></td>
 </tr>
<?php
    }

?>

answered Nov 8, 2016 at 5:24

Nima Ghotbi

6713 silver badges9 bronze badges

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

Comments

Mohammad Nurul Huda Rimon · Accepted Answer · 2016-11-08 05:30:15Z

0

If you need new line for each column must simply add new tr for each td

Try this:

<? foreach ($res as $row) : ?>
    <tr>
      <td><? echo $row['partnumber']; ?></td>
    </tr>
    <tr>
      <td><? echo $row['partdescription']; ?></td>
    </tr>
    <tr>
      <td><? echo $row['partprice']; ?></td>
    </tr>
    <tr>
      <td><? echo $row['partquantity']; ?></td>
    </tr>
 <? endforeach; ?>

edited Nov 8, 2016 at 5:30

answered Nov 8, 2016 at 5:21

Mohammad Nurul Huda Rimon

2,5351 gold badge17 silver badges18 bronze badges

Comments

pamekar · Accepted Answer · 2016-11-08 05:34:02Z

0

Notice the change in the starting curly braces, and that i removed the endforeach you used, and the table tags...

Now you can make use of this in your for each loop.

 <table>
 <? foreach ($res as $row) { ?>
    <tr>
    <td><? echo $row['partnumber']; ?></td>
    <td><? echo $row['partdescription']; ?></td>
    <td><? echo $row['partprice']; ?></td>
    <td><? echo $row['partquantity']; ?></td>
    </tr>
 <? 
     }
 ?>
 </table>

I think this should do the trick

answered Nov 8, 2016 at 5:34

pamekar

7397 silver badges10 bronze badges

Comments

JCD · Accepted Answer · 2016-11-08 15:18:48Z

0

This is what i'm getting with your code: (i'll fix the security issue after i get this working, thank you)

    <?php

    $id = $_GET['id'];


    $result = mysqli_query($mysqli, "SELECT * FROM invoices WHERE id=$id");

    while($res = mysqli_fetch_array($result))
    {
    ?>
    <? foreach ($res as $row) { ?>
<tr>
<td><? echo $row['partnumber']; ?></td>
<td><? echo $row['partdescription']; ?></td>
<td><? echo $row['partprice']; ?></td>
<td><? echo $row['partquantity']; ?></td>
</tr>
    <? 
    }

    }

    ?>

answered Nov 8, 2016 at 15:18

JCD

2972 silver badges19 bronze badges

Comments

mickmackusa · Accepted Answer · 2023-04-02 01:18:02Z

0

<?php
$arr1 = ['name'=>'jon', 'age'=>30, 'address'=>'dilly'];
$arr2 = ['name'=>'gita', 'age'=>20, 'address'=>'goha'];
$arr3 = ['name'=>'sita', 'age'=>20, 'address'=>'pune'];

$agroup = array([$arr1, $arr2, $arr3]);
 
?>

<table>
  <?php foreach($agroup as list($a, $b, $c)){ ?>
  <tr>
    <td><?php echo $a['name']; ?></td>
    <td><?php echo $b['name']; ?></td>
    <td><?php echo $c['name']; ?></td>
  </tr>
  <tr>
    <td><?php echo $a['age']; ?></td>
    <td><?php echo $b['age']; ?></td>
    <td><?php echo $c['age']; ?></td>
  </tr>

  <tr>
    <td><?php echo $a['address']; ?></td>
    <td><?php echo $b['address']; ?></td>
    <td><?php echo $c['address']; ?></td>
  </tr>

<?php } ?>
</table>

edited Apr 2, 2023 at 1:18

mickmackusa♦

49.3k13 gold badges98 silver badges165 bronze badges

answered May 22, 2021 at 1:52

Prakash Thapa

195 bronze badges

Collectives™ on Stack Overflow

Display multiple arrays in a html table

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related