如何搜索从Mysqli收集数据的HTML表 [英] How to search an HTML table that collects data from Mysqli

问题描述

尝试在html表上进行搜索希望能够输入用户的昵称，并且它为我提供了同一表上所有用户的详细信息.

trying to do a search on an html table want to be able to type the users nickname and it gives me all the users details on the same table.

                        <table width="100%" class="table table-striped table-bordered table-hover" id="dataTables-example">
                            <thead>
                                <tr>
                                    <th>Nickname</th>
                                    <th>State</th>
                                    <th>city</th>
                                    <th>address</th>
                                </tr>
                            </thead>
                            <tbody>
                               <?php
            $sql = "SELECT * FROM houses"; 
            $q=$conn->query($sql);
           while ($row = mysqli_fetch_array($q)) {
 ?>
              <tr>
            <td><?php echo $row['nickname']; ?></td>
            <td><?php echo $row['state']; ?></td>
            <td><?php echo $row['city']; ?></td>
            <td><?php echo $row['address']; ?></td>
        </tr>
<?php
           }

        ?>
                            </tbody>
                        </table>

推荐答案

您需要在SQL查询中使用WHERE:

You need to use WHERE in your SQL query:

$sql = "SELECT * FROM houses WHERE nickname = '{$nickname}'";

您还需要使用isset才能使HTML输入中包含单词.

you also need to use an isset in order to have the word from your HTML input.

这篇关于如何搜索从Mysqli收集数据的HTML表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！