用Php隐藏列

Question

我有个关于隐藏空列的问题。

当我有空列时，如何隐藏< th>SURNAME< /th> head列？

在接下来的几天里，我将对mysqli进行所有的查询:-)

QUERY
$query = " SELECT * FROM users ";
$result = mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($result); 

TABLE
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">

 <thead>
     <tr>
         <th>NAME</th>
         <th>SURNAME</th>
     </tr>
</thead>

<tbody>
    <?php
        $i=0;
        while ($i < $num) {
            $id = mysql_result($result,$i,"id");
            $name = mysql_result($result,$i,"name");
            $surname = mysql_result($result,$i,"surname");
    ?>

    <tr>
        <td><?php echo $name; ?></td>
        <td><?php echo $surname; ?></td>
    </tr>

    <?php
        $i++;
        }
    ?>
</tbody>

</table>

Answer 1

若要隐藏列，您需要先检查。

   $array_surname = array();
    while($res_head_surname = mysql_fetch_array($result)) {
        $array_surname[] = $res_head_surname;
    }

在此之后，根据需要插入条件并添加到标头表中：

<?php if ($show_surname == 1) {?><th>SURNAME</th><?php } ?> 

Answer 2

试试这个！只要放一个if来检查姓氏是否存在就行了。还包括回显中的标记。

QUERY
$query = " SELECT * FROM users ";
$result = mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($result); 
TABLE
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">

 <thead>
     <tr>
         <th>NAME</th>
         <th>SURNAME</th>
     </tr>
</thead>

<tbody>
    <?php
        $i=0;
        while ($i < $num) {
            $id = mysql_result($result,$i,"id");
            $name = mysql_result($result,$i,"name");
            $surname = mysql_result($result,$i,"surname");
    ?>

    <tr>

<?php echo "<td>".$name."</td>"; ?> <td><?php if($surname){echo "<th>".$surname."</th>";} ?></td>

    </tr>

    <?php
        $i++;
        }
    ?>
</tbody>

</table>