How to display two table columns per row in php loop

Question

Hi, I would like to display data, two columns per row during my foreach. I would like my result to look like the following:

<table>
<tr><td>VALUE1</td><td>VALUE2</td></tr>
<tr><td>VALUE3</td><td>VALUE4</td></tr>
<tr><td>VALUE5</td><td>VALUE6</td></tr>
</table>

Any help would be greatly appreciated. Thanks

Answer 1

$i=0;
foreach ($x as $key=>$value)
  {
  if (fmod($i,2)) echo '<tr>';
  echo '<td>',$value,'</td>';
  if (fmod($i,2)) echo '</tr>';
  $i++;
  }

this will output TR (row) each second time

ps: i haven't tested the code, so maybe you will need to add ! sign before fmod, if it doesn't output TR on first iteration, but on second iteration in the beginning...

Answer 2

You can use array_chunk() to split an array of data into smaller arrays, in this case of length 2, for each row.

<table>
<?php foreach (array_chunk($values, 2) as $row) { ?>
    <tr>
    <?php foreach ($row as $value) { ?>
        <td><?php echo htmlentities($value); ?></td>
    <?php } ?>
    </tr>
<?php } ?>
</table>

Note that if you have an odd number of values, this will leave a final row with only one cell. If you want to add an empty cell if necessary, you could check the length of $row within the outer foreach.

Answer 3

Hi, This is Amit Chauhan and using php and mysql in my site. I have a two table one is main details other one is second details. I want result from both of table. e.g. Name : abc , address : abc, City,pin first table, second table is : Other family details. NAME : XYZ,NAME PQR ETC. So I want display both of them.