隐藏所有没有mysql数据库结果的html表

debugcn 发表于 Dev

最酷的

我正在尝试创建一个下拉菜单，用户在其中选择一个字母，然后在我创建的表中输出以该字母开头的所有名称。名称是从数据库中选择的。现在，我希望在用户尚未选择字母或数据库没有结果时隐藏该表。因此，我希望仅在数据库有结果时才显示表。这是我的代码：

<html>

<head>
  <title>Title</title>
  <style>
    table {
      width: 100%;
      border-collapse: collapse;
    }
    table,
    td,
    th {
      border: 1px solid black;
      padding: 5px;
    }
    th {
      text-align: left;
    }
  </style>

</head>

<body>
  <?php $con=mysqli_connect( 'localhost', 'root', 'evolvia2016', 'presta_prova'); if (!$con) { die( 'Could not connect: ' . mysqli_error($con)); } ?>
  <form method="post">
    <select name="users">
      <option value="">Scegliete una lettera:</option>
      <option value="A">A</option>
      <option value="B">B</option>
      <option value="C">C</option>
      <option value="D">D</option>
    </select>
    <input type="submit" name="submit" value="Go" />
  </form>
  <br>
  <div id="txtHint"><b>Vedi qui i tipi ti marche:</b>
  </div>
  <table id='results'>
    <tr>
      <th>Marca</th>
      <th>Descrizione</th>
    </tr>
    <?php $q=$ _POST[ "users"]; //$sql="SELECT * FROM presta_prova WHERE marca LIKE 'B%' " ; $sql="SELECT * FROM presta_prova WHERE marca LIKE '" . $q . "%' "; $result=mysqli_query($con,$sql); while($row=mysqli_fetch_array($result)) { echo "<tr>"; echo
    "<td>" . $row[ "marca"] . "</td>"; echo "<td>" . $row[ "descrizione"] . "</td>"; echo "</tr>"; } echo "</table>"; ?>
  </table>
</body>
<?php mysqli_close($con); ?>

</html>

我尝试插入隐藏的属性，但不能解决问题。有人可以告诉我如何在上述情况下将其隐藏吗？谢谢！

奥马里（Omari）维克多（Omosa）

这是逻辑

<?php
$con=mysqli_connect( 'localhost', 'root', 'evolvia2016', 'presta_prova'); if (!$con) { die( 'Could not connect: ' . mysqli_error($con)); } 
$sql= mysqli_query($con, "SELECT * FROM presta_prova WHERE marca LIKE 'B%'") ;
$row = mysqli_fetch_assoc($sql);
$totalRows_results = mysqli_num_rows($sql);     
?>


<?php if($totalRows_results > 0) { ?>

Anything inside here will be visible if the query returns any result
//e.g you may echo out your results here <?php echo $row['column']; ?>


    you can also do your while loop inside here
    <?php do { ?>
    //your repeating region
       <?php echo $row['column']; ?>  //i.e.  <?php echo $row['marca']; ?>
    <?php } while ($row = mysqli_fetch_assoc($sql)); ?>  

<?php } ?>



<?php if($totalRows_results == 0) { ?>

Anything inside here will be visible if the query does not return any result
//e.g you may display an error message here like. sorry no result found

<?php } ?>

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。