php - 将具有相同名称的行中的表格单元格合并到php中的一个单元格或rowspan中

Question

我的一个表中有数据，其中同时包含多行数据。我想创建一个表，其中同一时间的所有数据都显示在同一行，并且日期也显示在同一行

我的数据目前是这样的

表格字段如

date              time          product name       action2015-08-20      8:00 AM         product one2015-08-20      8:00 AM         product two2015-08-20      8:00 AM         product three2015-08-20      2:00 PM         product four2015-08-20      2:00 PM         product five2015-08-20      2:00 PM         product three

这就是我希望的数据:

date              time          product name         action                                product one2015-08-20      8:00 AM         product two              print                                product three                                product four2015-08-20      2:00 PM         product five             print                                product three

请有人帮我找到答案

    $output = "";        $getart2 = mysql_query("SELECT *  FROM csv WHERE `date` = CURDATE() ");        $result_array = array();        while($row = mysql_fetch_assoc($getart2)) {             $result_array[] = $row;        }   

Answer 1

通过使用数组键对数据进行分组来解决多种可能的解决方案:

$data = array(
    array('date' => '2015-08-20', 'time' => '8:00 AM', 'product_name' => 'product one'),
    array('date' => '2015-08-20', 'time' => '8:00 AM', 'product_name' => 'product two'),
    array('date' => '2015-08-20', 'time' => '8:00 AM', 'product_name' => 'product three'),
    array('date' => '2015-08-20', 'time' => '2:00 AM', 'product_name' => 'product four'),
    array('date' => '2015-08-20', 'time' => '2:00 AM', 'product_name' => 'product five'),
    array('date' => '2015-08-20', 'time' => '2:00 AM', 'product_name' => 'product six')
);
$data2 = array();
foreach($data as $value) {
    $key = $value['date'].$value['time'];
    if(!isset($data2[$key])) {
        $data2[$key] = array('date' => $value['date'], 'time' => $value['time'], 'product_name' => array());
    }
    $data2[$key]['product_name'][] = $value['product_name'];
}

$output = '<table>';
$output .= '<tr><th>date</th><th>time</th><th>product name</th></tr>';
foreach($data2 as $row) {
    $output .= '<tr>';
    $output .= '<td>'.$row['date'].'</td>';
    $output .= '<td>'.$row['time'].'</td>';
    $output .= '<td>'.implode('<br />', $row['product_name']).'</td>';
    $output .= '</tr>';
}
$output .= '</table>';
echo $output;