php html table pivot列标题

I am close of reaching my desired output, but I have this problem..

The column header must be 1,2,3,4,5 etc. etc. and here is my code so far..

<table class="table table-bordered table-condensed" align="center" bordercolor="#CCCCCC">
                            <tr bgcolor="#009933">
                            <td align="center" style="color:#FFF;">Name</td>
                            <td align="center" style="color:#FFF;">Date</td>
                            <td align="center" style="color:#FFF;">Date</td>
                            <td align="center" style="color:#FFF;">Date</td>
                            <td align="center" style="color:#FFF;">Date</td>
                            <td align="center" style="color:#FFF;">Date</td>
                            <td align="center" style="color:#FFF;">Remark</td>
                            </tr>
                            <?php
                            $queryres = mysql_query("SELECT stud_name,
                            MAX(IF(date = '1', remark, '')) AS '1',
                            MAX(IF(date = '2', remark, '')) AS '2',
                            MAX(IF(date = '3', remark, '')) AS '3',
                            MAX(IF(date = '4', remark, '')) AS '4',
                            MAX(IF(date = '5', remark, '')) AS '5',
                            MAX(IF(date = '6', remark, '')) AS '6',
                            MAX(IF(date = '7', remark, '')) AS '7',
                            MAX(IF(date = '8', remark, '')) AS '8',
                            MAX(IF(date = '9', remark, '')) AS '9',
                            MAX(IF(date = '10', remark, '')) AS '10',
                            MAX(IF(date = '11', remark, '')) AS '11',
                            MAX(IF(date = '12', remark, '')) AS '12',
                            MAX(IF(date = '13', remark, '')) AS '13',
                            MAX(IF(date = '14', remark, '')) AS '14',
                            MAX(IF(date = '15', remark, '')) AS '15',
                            MAX(IF(date = '16', remark, '')) AS '16',
                            MAX(IF(date = '17', remark, '')) AS '17',
                            MAX(IF(date = '18', remark, '')) AS '18',
                            MAX(IF(date = '19', remark, '')) AS '19',
                            MAX(IF(date = '20', remark, '')) AS '20', 
                            MAX(IF(date = '21', remark, '')) AS '21',
                            MAX(IF(date = '22', remark, '')) AS '22',
                            MAX(IF(date = '23', remark, '')) AS '23',
                            MAX(IF(date = '24', remark, '')) AS '24',
                            MAX(IF(date = '25', remark, '')) AS '25',
                            MAX(IF(date = '26', remark, '')) AS '26',
                            MAX(IF(date = '27', remark, '')) AS '27',
                            MAX(IF(date = '28', remark, '')) AS '28',
                            MAX(IF(date = '29', remark, '')) AS '29',
                            MAX(IF(date = '30', remark, '')) AS '30',
                            MAX(IF(date = '31', remark, '')) AS '31'
                            FROM tb_attendance WHERE instructor_id = '$inst_id' AND description = '$desc'
                            GROUP BY stud_name");
                            while($result= mysql_fetch_array($queryres)){
                                echo "<tr>";
                                echo "<td class=\"text-center\">".$result['stud_name']."</td>";
                                echo "<td class=\"text-center\">".$result['1']."</td>";
                                echo "<td class=\"text-center\">".$result['2']."</td>";
                                echo "<td class=\"text-center\">".$result['3']."</td>";
                                echo "<td class=\"text-center\">".$result['4']."</td>";
                                echo "<td class=\"text-center\">".$result['5']."</td>";
                                echo "<td class=\"text-center\">"."</td>";
                            }
?>
</table>

Is there a way to change (DATE) into the numbers (1,2,3,4,5) and only show the numbers where there is a record(remark = Present or Absent). for example 1 2 3 have a records but 4 5 has nothing so 1 2 3 must only be shown in the table

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

1条回答默认最新

doushi9444 2016-01-22 03:58

关注

You'll need to do another query to find out which dates have values in the table:

<table class="table table-bordered table-condensed" align="center" bordercolor="#CCCCCC">
    <tr bgcolor="#009933">
    <td align="center" style="color:#FFF;">Name</td>
<?php
$queryres = mysql_query("SELECT DISTINCT date 
                         FROM tb_attendance 
                         WHERE instructor_id = '$inst_id' AND description = '$desc' 
                         ORDER BY date");
$dates = array();
while ($row = mysql_fetch_assoc($queryres)) {
    $dates[] = $row['date']; // Remember which date columns have values, so we only display those in the student rows.
    echo '<td align="center" style="color:#FFF;">' . $row['date'] . '</td>';
}
?>
<td align="center" style="color:#FFF;">Remark</td>
</tr>
<?php
$queryres = mysql_query("
    SELECT stud_name,
        MAX(IF(date = '1', remark, '')) AS '1',
        MAX(IF(date = '2', remark, '')) AS '2',
        MAX(IF(date = '3', remark, '')) AS '3',
        MAX(IF(date = '4', remark, '')) AS '4',
        MAX(IF(date = '5', remark, '')) AS '5',
        MAX(IF(date = '6', remark, '')) AS '6',
        MAX(IF(date = '7', remark, '')) AS '7',
        MAX(IF(date = '8', remark, '')) AS '8',
        MAX(IF(date = '9', remark, '')) AS '9',
        MAX(IF(date = '10', remark, '')) AS '10',
        MAX(IF(date = '11', remark, '')) AS '11',
        MAX(IF(date = '12', remark, '')) AS '12',
        MAX(IF(date = '13', remark, '')) AS '13',
        MAX(IF(date = '14', remark, '')) AS '14',
        MAX(IF(date = '15', remark, '')) AS '15',
        MAX(IF(date = '16', remark, '')) AS '16',
        MAX(IF(date = '17', remark, '')) AS '17',
        MAX(IF(date = '18', remark, '')) AS '18',
        MAX(IF(date = '19', remark, '')) AS '19',
        MAX(IF(date = '20', remark, '')) AS '20', 
        MAX(IF(date = '21', remark, '')) AS '21',
        MAX(IF(date = '22', remark, '')) AS '22',
        MAX(IF(date = '23', remark, '')) AS '23',
        MAX(IF(date = '24', remark, '')) AS '24',
        MAX(IF(date = '25', remark, '')) AS '25',
        MAX(IF(date = '26', remark, '')) AS '26',
        MAX(IF(date = '27', remark, '')) AS '27',
        MAX(IF(date = '28', remark, '')) AS '28',
        MAX(IF(date = '29', remark, '')) AS '29',
        MAX(IF(date = '30', remark, '')) AS '30',
        MAX(IF(date = '31', remark, '')) AS '31'
    FROM tb_attendance WHERE instructor_id = '$inst_id' AND description = '$desc'
    GROUP BY stud_name");
while($result= mysql_fetch_array($queryres)){
    echo "<tr>";
    echo "<td class=\"text-center\">".$result['stud_name']."</td>";
    foreach ($dates as $date) {
        echo "<td class=\"text-center\">".$result[$date]."</td>"; 
    }
    echo "</tr>";
}

本回答被题主选为最佳回答 , 对您是否有帮助呢?

报告相同问题？

关注问题

php html table pivot列标题 php
2016-01-22 03:11

回答 1 已采纳 You'll need to do another query to find out which dates have values in the table: <table class
加入Pivot Table Mysql mysql php
2018-01-31 17:38

回答 1 已采纳 // I'm largely leaving your code as-is, but you could replace the // list of ORs with an IN() // T
SQL中PIVOT的PHP脚本 oracle php sql
2015-07-24 06:53

回答 1 已采纳 There are numerous errors in your code that stop it working correctly. I've modified it as follow
php pivot table,数据重塑图解—Pivot, Pivot-Table, Stack and Unstack
2021-04-24 12:24

脑叔的博客你需要在原始表中指定这三个参数所对定的列名，接下来pivot函数会创建一个新的表格，其中行索引和列索引都是唯一标示值，表格中的数值由原始表中参数value对应的数据所表示。from collections import OrderedDict...
在PHP中将MySQL输出显示为行而不是列 mysql php
2019-06-04 14:56

回答 2 已采纳 Looks like I just needed to use ul and li! <ul> <li><b>Name:</b> <?php
MySQL pivot将行放入列中 mysql php sql
2017-11-23 22:18

回答 2 已采纳 Simply use conditional aggregation for pivoting columns. And be sure to use explicit joins instead
sql结果，数字作为列标题，如何使用PHP调用或更改用于数据透视的sql列标题 php sql
2014-01-09 19:25

回答 1 已采纳 If you want to alias your columns then you would have to use something like the following, where y
PivotTable:从 MySQL 查询生成和呈现数据透视表
2021-06-16 04:56

数据透视表数据透视表提供了一种简单的方法来汇总一组结构化 SQL 表数据。执照此数据透视表功能是在许可下的开源软件。
从HTML表中的存储过程MySql PHP获取结果 mysql php
2015-12-21 12:19

回答 1 已采纳 I think you can simplify the stored procedure and use something like this: DELIMITER $$ USE `bil
Mysql数据透视表在PhpMyadmin中完全正常工作但与Php mysqli_query（）无关 mysql php
2017-01-25 13:24

回答 1 已采纳 This is not a query but a set of queries. Split it into separate statements and run them one by o
通过pivot检索所有与其他模型无关的模型 laravel php
2017-04-29 19:21

回答 1 已采纳 You are never actually executing the query. You need to call get() at the end of the query build
php列转行,PIVOT行转列，UNPIVOT列转行
2021-04-15 15:46

weixin_39518678的博客 PIVOT: 通过将表达式某一列中的唯一值转换为输出中的多个列来旋转表值表达式，并在必要时对最终输出中所需的任何其余列值执行聚合。 UNPIVOT 与 PIVOT 执行相反的操作，将表值表达式的列转换为列值。无 USE ...
MySQL Pivot表在动态行中查询 mysql php
2016-02-17 16:23

回答 1 已采纳 You dont have to use pivot in case there are always maximum of 3 columns(own,father and mother in
mysql php 列转行_mysql行转列和列转行实例详解
2021-01-19 05:20

塔图阿姆的博客 mysql行转列、列转行语句不难，不做多余解释了，看语句时，从内往外一句一句剖析行转列有如图所示的表，现在希望查询的结果将行转成列建表语句如下：CREATE TABLE `TEST_TB_GRADE` (`ID` int(10) NOT NULL AUTO_...
PHP 之 Laravel 框架
2023-07-20 15:03

羽墨灵丘的博客 // 是否自动维护时间戳，true时创建或更新数据会自动维护created_at和updated_at字段 public $fillable = [ // 只有在该数组中列出的字段才能通过 create() 或 fill() 方法进行批量赋值 'name', 'age', ];...
没有解决我的问题, 去提问

悬赏问题

¥15 随身WiFi网络灯亮但是没有网络，如何解决？
¥15 gdf格式的脑电数据如何处理matlab
¥20 重新写的代码替换了之后运行hbuliderx就这样了
¥100 监控抖音用户作品更新可以微信公众号提醒
¥15 UE5 如何可以不渲染HDRIBackdrop背景
¥70 2048小游戏毕设项目
¥20 mysql架构，按照姓名分表
¥15 MATLAB实现区间[a,b]上的Gauss-Legendre积分
¥15 delphi webbrowser组件网页下拉菜单自动选择问题
¥15 linux驱动，linux应用，多线程

码龄粉丝数原力等级 --

php html table pivot列标题

1条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

php html table pivot列标题

1条回答 默认 最新

悬赏问题

1条回答默认最新