当我使用Dreamweaver动态表格选项时,表格打印出来如下:
<table border="1">
<tr>
<td width="110">ID PRODUCT</td>
<td width="97">PRODUCT</td>
<td width="149">STOCK</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_inventory['idprod']; ?></td>
<td><?php echo $row_inventory['prod']; ?></td>
<td><?php echo $row_inventory['cont']; ?></td>
</tr>
<?php } while ($row_inventory = mysql_fetch_assoc($inventory)); ?>
</table>
ID PRODUCT STOCK
| 1 | chair | 23 |
| 2 | table | 12 |
| 3 | pencil | 314 |
| 4 | pen | 523 |
| 5 | carpet | 23 |
但是我想让表水平打印数据
的例子:
ID PRODUCT | 1 | 2 | 3 | 4 | 5 |
PRODUCT | chair | table | pencil | pen | carpet |
STOCK | 23 | 12 | 314 | 523 | 23 |
的意义:
ID PRODUCT = 1;产品是一把椅子;有23件现货ID PRODUCT为2;PRODUCT是一个表;有12件现货ID PRODUCT为3;产品是一支铅笔;有314件现货
因为我的数据库中没有数据,所以我使用数组代替。仅作为示例,我使用了以下
$arr = array(
array('ID' => '1',
'PRODUCT' => 'chair',
'STOCK' => '23'),
array('ID' => '2',
'PRODUCT' => 'table',
'STOCK' => '12'),
);
<table border="1">
<tr>
<td width="110">ID PRODUCT</td>
<?php foreach ($arr as $key => $value)
{ ?>
<td><?php echo $value['ID']; ?></td>
<?php } ?>
</tr>
<tr>
<td width="97">PRODUCT</td>
<?php foreach ($arr as $key => $value)
{ ?>
<td><?php echo $value['PRODUCT']; ?></td>
<?php } ?>
</tr>
<tr>
<td width="149">STOCK</td>
<?php foreach ($arr as $key => $value)
{ ?>
<td><?php echo $value['STOCK']; ?></td>
<?php } ?>
</tr>