PHP如何基于from、to日期过滤器遍历日期范围拉取数据渲染表格
问题描述
我设置了两个代表当月日期的过滤器变量from和to,想要实现从start_date到end_date逐个日期循环,拉取选中日期范围内的对应数据。当前表格表头已经开发完成,可正常展示选中的日期,效果如下:
现有代码如下:
$start_date = date('d', strtotime($from)); $end_date = date('d', strtotime($to)); ?> <div> <div> <table> <thead> <tr> <th>Type</th> <?php $dates = range($end_date, $start_date); foreach ($dates as $fpi) { echo '<th>' . $fpi . '</th>'; } ?> </tr> </thead> <tbody class="text-center"> <tr> <td class="font-weight-bold text-no-wrapping">man</td> <?php foreach ($data['man'] as $value) { echo '<td>' . number_format($value) . '</td>'; } ?> </tr> <tr> <td class="font-weight-bold text-no-wrapping">women</td> <?php foreach ($data['women'] as $value) { echo '<td>' . number_format($value) . '</td>'; } ?> </tr> <tr> <td class="font-weight-bold text-no-wrapping">children</td> <?php foreach ($data['children'] as $value) { echo '<td>' . number_format($value) . '</td>'; } ?> </tr> <tr> <td class="font-weight-bold text-no-wrapping">as</td> <?php foreach ($data['as'] as $value) { echo '<td>' . number_format($value) . '</td>'; } ?> </tr> <tr> <td class="font-weight-bold text-no-wrapping">ot define</td> <?php foreach ($data['not_define'] as $value) { echo '<td>' . number_format($value) . '</td>'; } ?> </tr> <tr> <td class="font-weight-bold text-no-wrapping">old</td> <?php foreach ($data['old'] as $value) { echo '<td>' . number_format($value) . '</td>'; } ?> </tr> </tbody> </table> </div> </div>
内容的提问来源于stack exchange,提问作者hello
相关产品推荐
相关产品推荐

