php - 如何使用 PHP、MYSQL 和 HTML 隐藏检索到的数据值的重复部分
问题描述
由于这个 MySQL 语句,我得到了下表
select entry.id as id,
entry.payorder,
entry.bank,
entry.PFMS_SCHEME,
entry.name,
entry.vendor,
tally_head.head,
ledgers.amount,
entry.po,
entry.Description,
bank_details.Name as name,
entry.sum as sum
from entry join bank_details on entry.name=bank_details.id
join ledgers on ledgers.id=entry.id
join tally_head on ledgers.ledger=tally_head.id
group by tally_head.head
我想要的最终输出
我使用的 HTML 和 PHP 代码
<table class="table">
<thead>
<tr>
<th>Voucher No </th>
<th>Payorder </th>
<th>Bank </th>
<th>PFMS_SCHEME </th>
<th>Party Name </th>
<th> For</th>
<th> Po/agmt/inv N.o </th>
<th>Ledger</th>
<th>Ledger Amount</th>
<th>Description/ Narration</th>
<th>sum</th>
</tr>
</thead>
<tbody>
<?php
$sql=mysqli_query($con,"select entry.id as cid,entry.payorder,entry.bank,entry.PFMS_SCHEME,entry.name,entry.vendor,tally_head.head,ledgers.amount,entry.po,entry.Description,bank_details.Name as name,entry.sum as sum from entry join bank_details on entry.name=bank_details.id join ledgers on ledgers.id=entry.id join tally_head on ledgers.ledger=tally_head.id group by tally_head.head ");
$cnt=1;
while($row=mysqli_fetch_array($sql))
?>
<tr>
<td><?php echo htmlentities($row['cid']);?></td>
<td><?php echo htmlentities($row['payorder']);?></td>
<td><?php echo htmlentities($row['bank']);?></td>
<td><?php echo htmlentities($row['PFMS_SCHEME']);?></td>
<td><?php echo htmlentities($row['name']);?></td>
<td><?php echo htmlentities($row['vendor']);?></td>
<td><?php echo htmlentities($row['po']);?></td>
<td><?php echo htmlentities($row['head']);?></td>
<td><?php echo htmlentities($row['amount']);?></td>
<td><?php echo htmlentities($row['Description']);?></td>
<td><?php echo htmlentities($row['sum']);?></td>
<td>
</td>
</tr>
<?php
$cnt++;
?>
</tbody>
</table>
解决方案
推荐阅读
- visual-studio - Visual Studio 安装问题
- php - 使用 jquery-Ajax 在 html 表中显示 laravel 重新运行结果
- python - 将 Python NumPy 数组插入 PostgreSQL 数据库的最佳方法
- angular - Angular 8无法匹配延迟加载模块的辅助(命名)出口上的任何路由
- openvpn - OpenVPN 用户证书
- c++ - 使用 h264 流创建 mkv 容器时数据无效,因为 extradata 为空
- corda - Corda 性能滞后于大容量交易
- express - App Engine Google Cloud 中的部署失败
- python - UnboundLocalError:分配前引用的局部变量“csv_file”
- react-router - React-router-dom:非常简单的嵌套路由不起作用