代码之家  ›  专栏  ›  技术社区  ›  Bhumi Shah

如何格式化不同的数组以使用模在表中列出?

html php
  •  2
  • Bhumi Shah  · 技术社区  · 4 年前

    这是我的阵列 

    $headers = '
    '2020-02-10' => [
        'DateShort' => 'Mon 10/02/2020',
    ],
    '2020-02-11' => [
        'DateShort' => 'Tue 11/02/2020',
    ],
    '2020-02-12' => [
        'DateShort' => 'Wed 12/02/2020',
    ],
    '2020-02-13' => [
        'DateShort' => 'Thu 13/02/2020',
    ],
    '2020-02-14' => [
        'DateShort' => 'Fri 14/02/2020',
    ],
    '2020-02-15' => [
        'DateShort' => 'Sat 15/02/2020',
    ],
    '2020-02-16' => [
        'DateShort' => 'Sun 16/02/2020',
    ],
    '2020-02-17' => [
        'DateShort' => 'Mon 17/02/2020',
    ],
    '2020-02-18' => [
        'DateShort' => 'Tue 18/02/2020',
    ],
    '2020-02-19' => [
        'DateShort' => 'Wed 19/02/2020',
    ],
];

$data = [
    [
        'RoomName' => 'RoomName1'
        'Days' => [
            '2020-02-10' => [
                    'NumRooms' => 10,
                    'AverageRate' => 'INR10.00',
                    'AverageRateText' =>  @ INR10.00
                ],
            '2020-02-11' => [
                    'NumRooms' => 20,
                    'AverageRate' => 'INR20.00',
                    'AverageRateText' =>  @ INR20.00
                ],
            '2020-02-12' => [
                    'NumRooms' => 30,
                    'AverageRate' => 'INR30.00',
                    'AverageRateText' =>  @ INR30.00
                ],
            '2020-02-13' => [
                    'NumRooms' => 40,
                    'AverageRate' => 'INR40.00',
                    'AverageRateText' =>  @ INR40.00
                ],
            '2020-02-14' => [
                    'NumRooms' => 50
                    'AverageRate' => INR5.00
                    'AverageRateText' =>  @ INR50.00
                ],
            '2020-02-15' => [
                    'NumRooms' => 60
                    'AverageRate' => INR60.00
                    'AverageRateText' =>  @ INR60.00
                ],
            '2020-02-16' => [
                    'NumRooms' => 70
                    'AverageRate' => INR70.00
                    'AverageRateText' =>  @ INR70.00
                ],
            '2020-02-17' => [
                    'NumRooms' => 80
                    'AverageRate' => INR80.00
                    'AverageRateText' =>  @ INR80.00
                ],
            '2020-02-18' => [
                    'NumRooms' => 90
                    'AverageRate' => INR90.00
                    'AverageRateText' =>  @ INR90.00
                ],
            '2020-02-19' => [
                    'NumRooms' => 100
                    'AverageRate' => INR100.00
                    'AverageRateText' =>  @ INR100.00
                ],
        ],
    ],
    [
        'RoomName' => 'RoomName2'
        'Days' => [
            '2020-02-10' => [
                    'NumRooms' => 100,
                    'AverageRate' => 'INR100.00',
                    'AverageRateText' =>  @ INR100.00
                ],
            '2020-02-11' => [
                    'NumRooms' => 200,
                    'AverageRate' => 'INR200.00',
                    'AverageRateText' =>  @ INR200.00
                ],
            '2020-02-12' => [
                    'NumRooms' => 300,
                    'AverageRate' => 'INR300.00',
                    'AverageRateText' =>  @ INR300.00
                ],
            '2020-02-13' => [
                    'NumRooms' => 400,
                    'AverageRate' => 'INR400.00',
                    'AverageRateText' =>  @ INR400.00
                ],
            '2020-02-14' => [
                    'NumRooms' => 500
                    'AverageRate' => INR500.00
                    'AverageRateText' =>  @ INR500.00
                ],
            '2020-02-15' => [
                    'NumRooms' => 600
                    'AverageRate' => INR600.00
                    'AverageRateText' =>  @ INR600.00
                ],
            '2020-02-16' => [
                    'NumRooms' => 700
                    'AverageRate' => INR700.00
                    'AverageRateText' =>  @ INR700.00
                ],
            '2020-02-17' => [
                    'NumRooms' => 800
                    'AverageRate' => INR800.00
                    'AverageRateText' =>  @ INR800.00
                ],
            '2020-02-18' => [
                    'NumRooms' => 900
                    'AverageRate' => INR900.00
                    'AverageRateText' =>  @ INR900.00
                ],
            '2020-02-19' => [
                    'NumRooms' => 1000
                    'AverageRate' => INR1000.00
                    'AverageRateText' =>  @ INR1000.00
                ],
        ]
    ],
    [
        'RoomName' => 'RoomName3'
        'Days' => [
            '2020-02-10' => [
                    'NumRooms' => 100,
                    'AverageRate' => 'INR100.00',
                    'AverageRateText' =>  @ INR100.00
                ],
            '2020-02-11' => [
                    'NumRooms' => 200,
                    'AverageRate' => 'INR200.00',
                    'AverageRateText' =>  @ INR200.00
                ],
            '2020-02-12' => [
                    'NumRooms' => 300,
                    'AverageRate' => 'INR300.00',
                    'AverageRateText' =>  @ INR300.00
                ],
            '2020-02-13' => [
                    'NumRooms' => 400,
                    'AverageRate' => 'INR400.00',
                    'AverageRateText' =>  @ INR400.00
                ],
            '2020-02-14' => [
                    'NumRooms' => 500
                    'AverageRate' => INR500.00
                    'AverageRateText' =>  @ INR500.00
                ],
            '2020-02-15' => [
                    'NumRooms' => 600
                    'AverageRate' => INR600.00
                    'AverageRateText' =>  @ INR600.00
                ],
            '2020-02-16' => [
                    'NumRooms' => 700
                    'AverageRate' => INR700.00
                    'AverageRateText' =>  @ INR700.00
                ],
            '2020-02-17' => [
                    'NumRooms' => 800
                    'AverageRate' => INR800.00
                    'AverageRateText' =>  @ INR800.00
                ],
            '2020-02-18' => [
                    'NumRooms' => 900
                    'AverageRate' => INR900.00
                    'AverageRateText' =>  @ INR900.00
                ],
            '2020-02-19' => [
                    'NumRooms' => 1000
                    'AverageRate' => INR1000.00
                    'AverageRateText' =>  @ INR1000.00
                ],
        ]
    ]
];

    我想把它格式化成这个表格 

    <table cellspacing="0" cellpadding="0" border="1">
   <tr>
      <th></th>
      <th>Mon 10/02/2020</th>
      <th>Tue 11/02/2020</th>
      <th>Wed 12/02/2020</th>
      <th>Thu 13/02/2020</th>
      <th>Fri 14/02/2020</th>
   </tr>
   <tr>
      <td>RoomName1</td>
      <td>10 @ INR10.00</td>
      <td>20 @ INR20.00</td>
      <td>30 @ INR30.00</td>
      <td>40 @ INR40.00</td>
      <td>50 @ INR50.00</td>
   </tr>
   <tr>
      <td>RoomName2</td>
      <td>100 @ INR100.00</td>
      <td>200 @ INR200.00</td>
      <td>300 @ INR300.00</td>
      <td>400 @ INR400.00</td>
      <td>500 @ INR500.00</td>
   </tr>
   <tr>
      <td>RoomName3</td>
      <td>100 @ INR100.00</td>
      <td>200 @ INR200.00</td>
      <td>300 @ INR300.00</td>
      <td>400 @ INR400.00</td>
      <td>500 @ INR500.00</td>
   </tr>
   <tr>
      <th></th>
      <th>Sat 15/02/2020</th>
      <th>Sun 16/02/2020</th>
      <th>Mon 17/02/2020</th>
      <th>Tue 18/02/2020</th>
      <th>Wed 19/02/2020</th>
  </tr>
  <tr>
        <td>RoomName1</td>
      <td>60 @ INR60.00</td>
      <td>70 @ INR7.00</td>
      <td>80 @ INR80.00</td>
      <td>90 @ INR90.00</td>
      <td>100 @ INR100.00</td>
  </tr>
  <tr>
    <td>RoomName2</td>
      <td>600 @ INR600.00</td>
      <td>700 @ INR700.00</td>
      <td>800 @ INR800.00</td>
      <td>900 @ INR900.00</td>
      <td>1000 @ INR1000.00</td>
  </tr>
  <tr>
    <td>RoomName3</td>
      <td>600 @ INR600.00</td>
      <td>700 @ INR700.00</td>
      <td>800 @ INR800.00</td>
      <td>900 @ INR900.00</td>
      <td>1000 @ INR1000.00</td>
  </tr>
</table>

    我写的代码: 

    $html .= '<table cellspacing="0" cellpadding="0" border="1">';

$columnIterator = 1;
$headerData = [];
$headerCols = 0;
foreach ($headerdatas as $sqlDate => $data) {
    if ($columnIterator % 5 == 1) {
        $headerData[$headerCols] = '<tr><th></th>';
    }
    if (!is_array($data)) {
        continue;
    }
    $headerData[$headerCols] .= '<th>' . $data['DateShort'] . '</th>';
    $dates[] = $sqlDate;
    if ($columnIterator % 5 == 0) {
        $headerData[$headerCols] .= '</tr>';
        $headerCols++;
    }
    $columnIterator++;
}

$tableRows = 0;
foreach ($tablerows as $roomData) {
    $columnIterator = 1;
    $html .= $headerData[$tableRows];
    foreach ($dates as $sqlDate) {
        if ($columnIterator % 5 == 1) {
            $html .=  '<tr><td>' . $roomData['RoomName'] . '</td>';
        }
        $html .= '<td>';
        if (array_key_exists($sqlDate, $roomData['Days'])) {
            $html .= $roomData['Days'][$sqlDate]['NumRooms']
                . $roomData['Days'][$sqlDate]['AverageRateText'];
        }
        else {
            $html .= '0';
        }
        $html .= '</td>';
        if ($columnIterator % 5 == 0) {
            $html .= '</tr>';
        }
        $columnIterator++;
    }
    $tableRows++;
    $html .= '</tr>';
}
$html .= '</table>';
    0 回复  |  直到 4 年前
        1
  •  1
  •   Bhumi Shah    4 年前

    这是我想你想要的,自从你的 roomDataDates $tableRows 而您已经为其指定了值 0 : 

    <?php 
$headers = [
    '2020-02-10' => [
        'DateShort' => 'Mon 10/02/2020',
    ],
    '2020-02-11' => [
        'DateShort' => 'Tue 11/02/2020',
    ],
    '2020-02-12' => [
        'DateShort' => 'Wed 12/02/2020',
    ],
    '2020-02-13' => [
        'DateShort' => 'Thu 13/02/2020',
    ],
    '2020-02-14' => [
        'DateShort' => 'Fri 14/02/2020',
    ],
    '2020-02-15' => [
        'DateShort' => 'Sat 15/02/2020',
    ],
    '2020-02-16' => [
        'DateShort' => 'Sun 16/02/2020',
    ],
    '2020-02-17' => [
        'DateShort' => 'Mon 17/02/2020',
    ],
    '2020-02-18' => [
        'DateShort' => 'Tue 18/02/2020',
    ],
    '2020-02-19' => [
        'DateShort' => 'Wed 19/02/2020',
    ],
];

$roomsDataDates = [
    [
        'RoomName' => 'RoomName1',
        'Days' => [
            '2020-02-10' => [
                    'NumRooms' => 10,
                    'AverageRate' => 'INR10.00',
                    'AverageRateText' =>  '@ INR10.00'
                ],
            '2020-02-11' => [
                    'NumRooms' => 20,
                    'AverageRate' => 'INR20.00',
                    'AverageRateText' =>  '@ INR20.00'
                ],
            '2020-02-12' => [
                    'NumRooms' => 30,
                    'AverageRate' => 'INR30.00',
                    'AverageRateText' =>  '@ INR30.00'
                ],
            '2020-02-13' => [
                    'NumRooms' => 40,
                    'AverageRate' => 'INR40.00',
                    'AverageRateText' =>  '@ INR40.00'
                ],
            '2020-02-14' => [
                    'NumRooms' => 50,
                    'AverageRate' => 'INR5.00',
                    'AverageRateText' =>  '@ INR50.00'
                ],
            '2020-02-15' => [
                    'NumRooms' => 60,
                    'AverageRate' => 'INR60.00',
                    'AverageRateText' =>  '@ INR60.00'
                ],
            '2020-02-16' => [
                    'NumRooms' => 70,
                    'AverageRate' => 'INR70.00',
                    'AverageRateText' =>  '@ INR70.00'
                ],
            '2020-02-17' => [
                    'NumRooms' => 80,
                    'AverageRate' => 'INR80.00',
                    'AverageRateText' =>  '@ INR80.00'
                ],
            '2020-02-18' => [
                    'NumRooms' => 90,
                    'AverageRate' => 'INR90.00',
                    'AverageRateText' =>  '@ INR90.00'
                ],
            '2020-02-19' => [
                    'NumRooms' => 100,
                    'AverageRate' => 'INR100.00',
                    'AverageRateText' =>  '@ INR100.00'
                ],
        ],
    ],
    [
        'RoomName' => 'RoomName2',
        'Days' => [
            '2020-02-10' => [
                    'NumRooms' => 100,
                    'AverageRate' => 'INR100.00',
                    'AverageRateText' =>  '@ INR100.00'
                ],
            '2020-02-11' => [
                    'NumRooms' => 200,
                    'AverageRate' => 'INR200.00',
                    'AverageRateText' =>  '@ INR200.00'
                ],
            '2020-02-12' => [
                    'NumRooms' => 300,
                    'AverageRate' => 'INR300.00',
                    'AverageRateText' =>  '@ INR300.00'
                ],
            '2020-02-13' => [
                    'NumRooms' => 400,
                    'AverageRate' => 'INR400.00',
                    'AverageRateText' =>  '@ INR400.00'
                ],
            '2020-02-14' => [
                    'NumRooms' => 500,
                    'AverageRate' => 'INR500.00',
                    'AverageRateText' =>  '@ INR500.00'
                ],
            '2020-02-15' => [
                    'NumRooms' => 600,
                    'AverageRate' => 'INR600.00',
                    'AverageRateText' =>  '@ INR600.00'
                ],
            '2020-02-16' => [
                    'NumRooms' => 700,
                    'AverageRate' => 'INR700.00',
                    'AverageRateText' =>  '@ INR700.00'
                ],
            '2020-02-17' => [
                    'NumRooms' => 800,
                    'AverageRate' => 'INR800.00',
                    'AverageRateText' =>  '@ INR800.00'
                ],
            '2020-02-18' => [
                    'NumRooms' => 900,
                    'AverageRate' => 'INR900.00',
                    'AverageRateText' =>  '@ INR900.00'
                ],
            '2020-02-19' => [
                    'NumRooms' => 1000,
                    'AverageRate' => 'INR1000.00',
                    'AverageRateText' =>  '@ INR1000.00'
                ],
        ]
    ]
];

$html = '<table cellspacing="0" cellpadding="0" border="1">';

$columnIterator = 1;
$headerData = [];
$headerCols = 0;

function createRow($data, $dates, $start, $length, $roomData)
{
    $html = "<tr><td>$roomData</td>";
    // To display data under the next row of headings.
    for ($i = $start; $i < $start + $length; $i++) {
        $sqlDate = $dates[$i];
        $html .= '<td>';
        if (array_key_exists($sqlDate, $data['Days'])) {
            $html .= $data['Days'][$sqlDate]['NumRooms'] . ' '
                . $data['Days'][$sqlDate]['AverageRateText'];
        }
        else {
            $html .= '0';
        }
        $html .= '</td>';
    }
    $html .= '</tr>';
    return $html;
}

foreach ($headers as $sqlDate => $data) {
    if ($columnIterator % 5 == 1) {
        $headerData[$headerCols] = '<tr><th></th>';
    }
    if (!is_array($data)) {
        continue;
    }
    $headerData[$headerCols] .= '<th>' . $data['DateShort'] . '</th>';
    $dates[] = $sqlDate;
    if ($columnIterator % 5 == 0) {
        $headerData[$headerCols] .= '</tr>';
        $headerCols++;
    }
    $columnIterator++;
}
$rooms = array_values_deep($venueRooms[$roomVenueId], 'RoomName');
$tableRows = 0;
foreach ($headerData as $header) {
   $html .= $header;
   $columnIterator = 1;
   $k = 0;
   foreach ($rooms as $roomData) {
      $html .= createRow($roomsDataDates[$k], $dates, $tableRows * 5, 5, $roomData);
      $columnIterator++;
      $k++;
    }
    $tableRows++;
}
$html .= '</table>';

echo $html;
    推荐文章
    Softly  ·  单选按钮未按预期取值
    1 年前
    NovoMannen  ·  导航中的下拉菜单在内容后面重叠
    1 年前
    Thirumal isireddy  ·  在导航栏顺风css中,img被扭曲,而不是将元素推到旁边
    1 年前
    eXor420  ·  如何在脚本标记中使用导出的函数?
    1 年前
    Hadi  ·  如何在无效和有效输入中选择用于更改样式的psoudo元素(after)
    1 年前
    IonicMan  ·  剑道网格在宽度过大时不显示某些列
    1 年前
    Kernier  ·  如何将数学公式支持添加到StacksEditor?
    1 年前
    Md. Ibrahim  ·  CSS网格项溢出小屏幕滚动
    1 年前
    Arjun V Srivatsa  ·  如何将系统时区信息分配给javascript中的变量?
    1 年前
    Akshay mek  ·  Vscode扩展建议不适用于某些文件夹
    1 年前
    关于   移动版
    代码之家 - 一站式码农服务社区
    沪ICP备11025650号