合并PHP表中的列的值

I have a table and i want to merge the value of Total column for each month.

This is my code :

<table border="1" cellpadding="3" cellspacing="0" class="table_content">
   <tr>
      <td width="38" rowspan="2">NO.</td>
      <td rowspan="2">PILOT ON BOARD</td>
      <td colspan="2">PILOT ON BOARD</td>
      <td rowspan="2">PILOT WAITING TIME</td>
      <td rowspan="2">TOTAL</td>
      <td rowspan="2">BERTHING</td>
   </tr>
   <tr>
      <td width="100">DATE </td>
      <td width="100">TIME</td>
   </tr>

   <?php
        $no=0;
        $dataFromTable=json_decode('[{"PilotWaitingTime":"0.2","PilotOnBoardDate":"2013-01-01","PilotOnBoardTime":"17:40:00","PilotOnBoard":"2013-01-01 17:40:00","Berthing":"2013-01-01 20:25:00","rata2PilotWaitingTime":"9.067"},{"PilotWaitingTime":"19.2","PilotOnBoardDate":"2013-01-03","PilotOnBoardTime":"12:15:00","PilotOnBoard":"2013-01-03 12:15:00","Berthing":"2013-01-03 15:10:00","rata2PilotWaitingTime":"9.067"},{"PilotWaitingTime":"7.8","PilotOnBoardDate":"2013-01-03","PilotOnBoardTime":"14:45:00","PilotOnBoard":"2013-01-03 14:45:00","Berthing":"2013-01-03 17:05:00","rata2PilotWaitingTime":"9.067"},{"PilotWaitingTime":"6.4","PilotOnBoardDate":"2013-02-04","PilotOnBoardTime":"18:25:00","PilotOnBoard":"2013-02-04 18:25:00","Berthing":"2013-02-04 20:25:00","rata2PilotWaitingTime":"6.000"},{"PilotWaitingTime":"5.6","PilotOnBoardDate":"2013-02-06","PilotOnBoardTime":"05:40:00","PilotOnBoard":"2013-02-06 05:40:00","Berthing":"2013-02-06 08:30:00","rata2PilotWaitingTime":"6.000"},{"PilotWaitingTime":"26","PilotOnBoardDate":"2013-03-04","PilotOnBoardTime":"13:00:00","PilotOnBoard":"2013-03-04 13:00:00","Berthing":"2013-02-04 20:25:00","rata2PilotWaitingTime":"26.000"}]',true);

        foreach( $dataFromTable as $results ){
   ?>

   <tr>
      <td width="38" style="text-align:right"><?php echo $no+=1; ?></td>
      <td width="150"><?php echo $results['PilotOnBoard']; ?></td>
      <td width="100"><?php echo $results['PilotOnBoardDate']; ?> </td>
      <td width="100"><?php echo $results['PilotOnBoardTime']; ?></td>
      <td style="text-align:right"><?php echo $results['PilotWaitingTime']; ?></td>
      <td style="text-align:right"><?php echo $results['rata2PilotWaitingTime']; ?></td>
      <td style="text-align:right"><?php echo $results['Berthing']; ?></td>
   </tr>

   <?php }; ?>

</table>

This is the result:

PilotOnBoard            PilotOnBoardDate PilotOnBoardTime   PilotWaitingTime    Total   Berthing
2013-01-01 17:40:00     2013-01-01       17:40:00                        0.2     9.067  2013-01-01 20:25:00
2013-01-03 12:15:00     2013-01-03       12:15:00                       19.2     9.067  2013-01-03 15:10:00
2013-01-03 14:45:00     2013-01-03       14:45:00                        7.8     9.067  2013-01-03 17:05:00
2013-02-04 18:25:00     2013-02-04       18:25:00                        6.4     6.000  2013-02-04 20:25:00
2013-02-06 05:40:00     2013-02-06       05:40:00                        5.6     6.000  2013-02-06 08:30:00
2013-03-04 13:00:00     2013-03-04       13:00:00                       26      26.000  2013-02-04 20:25:00

I'm trying to merge the total column for each month. January = 9.067, February 6.000 and March 26.000.

This is the result i'm trying to make:

PilotOnBoard            PilotOnBoardDate PilotOnBoardTime   PilotWaitingTime   Total    Berthing
2013-01-01 17:40:00     2013-01-01       17:40:00                        0.2   |      | 2013-01-01 20:25:00
2013-01-03 12:15:00     2013-01-03       12:15:00                       19.2   | 9.067| 2013-01-03 15:10:00
2013-01-03 14:45:00     2013-01-03       14:45:00                        7.8   |______| 2013-01-03 17:05:00
2013-02-04 18:25:00     2013-02-04       18:25:00                        6.4   | 6.000| 2013-02-04 20:25:00
2013-02-06 05:40:00     2013-02-06       05:40:00                        5.6   |______| 2013-02-06 08:30:00
2013-03-04 13:00:00     2013-03-04       13:00:00                       26     |26.000|     2013-02-04 20:25:00

Thank you for your help

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

dongmi4720 2015-09-11 21:36

关注

Check if it's the same month and add rowspan attribute to the td!

   <table border="1" cellpadding="3" cellspacing="0" class="table_content">
   <tr>
      <td width="38" rowspan="2">NO.</td>
      <td rowspan="2">PILOT ON BOARD</td>
      <td colspan="2">PILOT ON BOARD</td>
      <td rowspan="2">PILOT WAITING TIME</td>
      <td rowspan="2">TOTAL</td>
      <td rowspan="2">BERTHING</td>
   </tr>
   <tr>
      <td width="100">DATE </td>
      <td width="100">TIME</td>
   </tr>

   <?php
        $no=0;
        $rows = 1;
        $lastDate = null;
        $dataFromTable=json_decode('[{"PilotWaitingTime":"0.2","PilotOnBoardDate":"2013-01-01","PilotOnBoardTime":"17:40:00","PilotOnBoard":"2013-01-01 17:40:00","Berthing":"2013-01-01 20:25:00","rata2PilotWaitingTime":"9.067"},{"PilotWaitingTime":"19.2","PilotOnBoardDate":"2013-01-03","PilotOnBoardTime":"12:15:00","PilotOnBoard":"2013-01-03 12:15:00","Berthing":"2013-01-03 15:10:00","rata2PilotWaitingTime":"9.067"},{"PilotWaitingTime":"7.8","PilotOnBoardDate":"2013-01-03","PilotOnBoardTime":"14:45:00","PilotOnBoard":"2013-01-03 14:45:00","Berthing":"2013-01-03 17:05:00","rata2PilotWaitingTime":"9.067"},{"PilotWaitingTime":"6.4","PilotOnBoardDate":"2013-02-04","PilotOnBoardTime":"18:25:00","PilotOnBoard":"2013-02-04 18:25:00","Berthing":"2013-02-04 20:25:00","rata2PilotWaitingTime":"6.000"},{"PilotWaitingTime":"5.6","PilotOnBoardDate":"2013-02-06","PilotOnBoardTime":"05:40:00","PilotOnBoard":"2013-02-06 05:40:00","Berthing":"2013-02-06 08:30:00","rata2PilotWaitingTime":"6.000"},{"PilotWaitingTime":"26","PilotOnBoardDate":"2013-03-04","PilotOnBoardTime":"13:00:00","PilotOnBoard":"2013-03-04 13:00:00","Berthing":"2013-02-04 20:25:00","rata2PilotWaitingTime":"26.000"}]',true);

        foreach( $dataFromTable as $results ){
   ?>

   <tr>
      <td width="38" style="text-align:right"><?php echo $no+=1; ?></td>
      <td width="150"><?php echo $results['PilotOnBoard']; ?></td>
      <td width="100"><?php echo $results['PilotOnBoardDate']; ?> </td>
      <td width="100"><?php echo $results['PilotOnBoardTime']; ?></td>
      <td style="text-align:right"><?php echo $results['PilotWaitingTime']; ?></td>

      <?php 
      if(explode("-",$results['PilotOnBoardDate'])[1] !== $lastDate){?>
        <td style="text-align:right" rowspan="<?php echo $rows;?>"><?php echo $results['rata2PilotWaitingTime']; ?></td>
      <?php 
      } else {
        $rows++;
      }
      $lastDate = explode("-",$results['PilotOnBoardDate'])[1];
      ?>
      <td style="text-align:right"><?php echo $results['Berthing']; ?></td>
   </tr>

   <?php }; ?>

</table>

I think this should work!

报告相同问题？

关注问题

在php中合并重复的数组值 php
2018-06-14 18:26

回答 2 已采纳 I think it's relatively simple to just iterate through the array and continuously merge the entrie
合并下拉php中的重复值 php
2019-07-07 09:56

回答 2 已采纳 This should do it: Get the unique locations by storing them in an array as the keys: $uniqu
php 不同数组中的值能合并吗 php
2018-07-03 15:53

回答 4 已采纳 ``` function array_merge_for_string(array $first, array $sencond){ foreach($second as $in
php 相同数据合并单元格,利用for循环实现excel中多列数据合并到一个单元格
2021-03-23 15:31

VC-Sawa的博客详细内容今天在工作中，老板给我一个任务，把excel表格中的多列数据合并到一列中。数据如下：注意：数据从16601到20000，也就是说有两千个网址。下面为大家介绍几种方法：第一种：使用wps自带函数1、在公示选项卡下...
多维数组和合并列中的重复值 php
2018-08-09 12:47

回答 1 已采纳 I got an expect result with double foreach. Try this : $result=[]; foreach ($my_arr as &$dde1) {
在php中根据键的值合并数组 php
2018-07-10 19:56

回答 3 已采纳 You should create a new array to hold the results and iterate over the input, adding every element
php数组如何进行合并 html php 前端
2023-04-08 23:41

回答 2 已采纳 <?php $originalArray = [ 'Afg' => [ 'A' => 1, 'B' => 2, ],
php二维数组相同字段值合并,php 二维数组根据某个字段相同就合并
2021-04-13 15:35

廖宝华的博客今天遇到一个需求就是,二维数组根据某个字段排序..现在代码有了.....php//原数组$a= [0=>['id' =>1,'name'=>'技术部','job'=>'后台开发'],1=>['id' =>1,'name'=>'技术部','j...
jquery合并table前3列中相同值的行 jquery
2017-03-06 10:17

回答 1 已采纳 http://www.cnblogs.com/starof/archive/2015/07/03/4618125.html
pandas实现表的多列合并拼接 python
2021-11-05 16:48

回答 1 已采纳读取excel可以选择不读取首列的好像是header 还是index_col参数需要设置下就行
如何使用PHPExcel从合并单元格中获取值？ php
2017-09-20 07:28

回答 1 已采纳 For any given cell object, there are a number of helper methods available $cell->isInMergeRang
table中同一列中合并相同项
2022-07-26 14:31

喵酱睡着了的博客 table合并相同项
线性表中有关链表的合并 c++ 有问必答
2022-10-04 08:54

回答 3 已采纳代码如下： #include <iostream> #include <fstream> using namespace std; typedef struct _node
layui table 表头合并_layui 动态表格之合并单元格
2020-12-20 10:10

weixin_39699670的博客需求：下面用excel表格大概模拟下需求，左边是原来的，要改成右边这样的：①第一步：再生成表格后调用此方法，以合并重复的单元格done : function(res, curr, count) {merge(res);}②第二步：编写这个方法：function...
多接口合并php,api接口合并 | 夜以继日的博客-互联网开发、前端、后端、网站开发、技术分享！...
2021-04-24 23:37

钢琴打假大师plus的博客而拆分后的接口在前端进行组合请求时，通常会出现一个区块要请求多个接口请求才能拿到想要的数据，过多的数据请求会导致区块渲染较慢等问题...解决方案1. 在服务端再开发一个新的合并接口来为客户端提供数据缺点: 该...
没有解决我的问题, 去提问

悬赏问题

¥15 装 pytorch 的时候出了好多问题，遇到这种情况怎么处理？
¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
¥15 手机接入宽带网线，如何释放宽带全部速度
¥30 关于#r语言#的问题：如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
¥15 ETLCloud 处理json多层级问题
¥15 matlab中使用gurobi时报错
¥15 这个主板怎么能扩出一两个sata口
¥15 不是，这到底错哪儿了😭
¥15 2020长安杯与连接网探
¥15 关于#matlab#的问题：在模糊控制器中选出线路信息，在simulink中根据线路信息生成速度时间目标曲线（初速度为20m/s，15秒后减为0的速度时间图像）我想问线路信息是什么

码龄粉丝数原力等级 --

合并PHP表中的列的值

1条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

合并PHP表中的列的值

1条回答 默认 最新

悬赏问题

1条回答默认最新