Strcmp不能正常工作

Question

    <?php
        $connect = mysqli_connect("localhost","root", "","nets") or die("Couldn't connect to database");        
        $query = mysqli_query($connect,"SHOW columns FROM users");
          while($row = $query->fetch_assoc()) {
                if( (strcmp($row['Field'],"Name") !== 0) ||
                    (strcmp($row['Field'],"ID") !== 0)||
                    (strcmp($row['Field'],"Password") !== 0)||
                    (strcmp($row['Field'],"Email") !== 0)||
                    (strcmp($row['Field'],"Company") !== 0)||
                    (strcmp($row['Field'],"Gender") !== 0)||
                    (strcmp($row['Field'],"Citizen") !== 0)){
            ?>
            <input type="radio" name="admin" value="'$row'"> 
                <?php
                    echo $row['Field'];
                    }
                ?>
                <br/>
            <?php
            }
            ?>   

请建议如何跳过“姓名”、"ID“、”密码“、”电子邮件“、”公司“、”性别“、”公民“行，并打印其他行。

Answer 1

与其获取所有列并应用PHP条件，不如只获取所需的列。

请尝试以下查询：

SHOW columns FROM users WHERE field NOT IN ('Name', 'ID', 'Password', 'Email', 'Company', 'Gender', 'Citizen')

Answer 2

如果您不想修改代码太多，那么我认为您只需要将||更改为&&，因为如果一个字段不匹配，您的代码目前将打印一个单选按钮。

如下所示：

 <?php
$connect = mysqli_connect("localhost","root", "","nets") or die("Couldn't connect to database");        
$query = mysqli_query($connect,"SHOW columns FROM users");
while($row = $query->fetch_assoc()) {
        if( (strcmp($row['Field'],"Name") !== 0) &&
            (strcmp($row['Field'],"ID") !== 0) &&
            (strcmp($row['Field'],"Password") !== 0) &&
            (strcmp($row['Field'],"Email") !== 0) &&
            (strcmp($row['Field'],"Company") !== 0) &&
            (strcmp($row['Field'],"Gender") !== 0) &&
            (strcmp($row['Field'],"Citizen") !== 0)){
        ?>
        <input type="radio" name="admin" value="'$row'"> 
          <?php
              echo $row['Field'];
        }
        ?>
        <br/>
<?php
}
?>