我希望从下拉列表中筛选员工表php,其中location =从html中选择的值,同样适用于其他字段,如name或nid [duplicate]

</span>
          <div id="report" class="table-responsive">

                <thead>
                    <tr>
                        <th>#</th>
                        <th>السجل</th>
                        <th>الوحدة</th>
                        <th>الرتبه</th>
                        <th>الرقم</th>
                        <th>الاسم</th>
                        <th>#</th>
                    </tr>
                </thead>
                <tbody>

<?php

    include 'DB/connect.php';
    //if(isset($_POST['submit'])){
//   $locco =$_POST['location'];
   $result = "SELECT * FROM `employee`";

    $query = mysqli_query($conn, $result);

    while ($row = mysqli_fetch_array($query)){

            echo '
            <tr>

                <td>           </td>
                <td>' . $row["nid"] .'</td>
                <td> location </td>
                <td>' . $row["rankk"] .'</td>
                <td>' . $row["pn"] .'</td>
                <td>' . $row["name"] .'</td>
                <td>  <a href= updateemployee.php?id=<?php . $row["nid"]; ?>تحرير</a> </td>
                ';

    }

    ?>
</div>