drvvepadi289421028 2019-02-05 07:40
浏览 68
已采纳

当我使用else语句时,我无法回显Invalid

I cant view Invalid, any suggestion to make it run?

    <table border="1">
<tr>
    <th>First Name</th>
    <th>Last Name</th>
    <th>Strand</th>
    <th>Section</th>
</tr>   

<?php
 $conn=mysqli_connect("localhost","root","","search");
 $set=$_POST['search'];
 if ($set > 0) {
 $show="SELECT * FROM search_student WHERE fname='$set'";
 $result=mysqli_query($conn,$show);

 while ($rows=mysqli_fetch_array($result) ) { 
    echo  "<tr>";
    echo  "<td>";
    echo $rows['fname'];
    echo  "</td>";
    echo  "<td>";
    echo $rows['lname'];
    echo  "</td>";
    echo  "<td>";
    echo $rows['strand'];
    echo  "</td>";
    echo  "<td>";
    echo $rows['section'];
    echo  "</td>";
    echo  "<tr>";
    echo "</br>";
 }
 }

The else statement here doesn't work

  else{
 echo "invalid";
 }

 ?>
 </table>
  • 写回答

1条回答 默认 最新

  • dos8244 2019-02-05 07:52
    关注
        if(mysqli_num_rows($result)>0){
            while ($rows=mysqli_fetch_array($result) ) { 
            echo  "<tr>";
            //etc
    
           }
         }
         else
         {
          echo "invalid";
         }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?