php - 在这个编码过程下进行搜索

Question

下面的代码来 self 的 friend 。我想在这个代码下进行搜索。从这段代码中，它将显示所有要删除的用户。我想要的是我想放置搜索框和搜索按钮。因此，当我插入用户 ID 并按搜索时，它才会显示我想要的用户。我应该把这个搜索文本、按钮和 php 放在哪里？我想把它放在 else if 代码下面。帮我。我是新来的:(

else if($_SESSION['jawatan'] == 'ADMIN') { ?>
      <li> <a href="view.php">VIEW PROFILE</a> </li>
      <li> <a href="request.php">VIEW REQUEST</a> </li>
      <li><a href="logout.php">LOG OUT</a></li>
      <li><img src="msc.jpg" width = "240" height ="80"></li>

      <form method="get">
           <input type="text" name="userid" placeholder="search" />
           <inpu type="submit" value="Search" />
      </form>

      <h3>View User</h3>
      <table border='1'>
        <tr> 
          <td><b>#</b></td>
          <td><b>Nama</b></td>
          <td><b>Email</b></td>
          <td><b>Division</b></td>
          <td><b>Department</b></td>
          <td><b>Delete</b></td>
        </tr>
        <?php
        $i = 1;

        $whr="";

        if(isset($_GET['userid'])){
           $whr.= " and mem_id='".$_GET['userid']."'"; // which field you want. If you want to do search name use LIKE instead =(equal to)
        }

        $result = mysql_query("SELECT * FROM members WHERE mem_role='USER' ".$whr);
        if(mysql_num_rows($result)>0) {
         while($row = mysql_fetch_array($result)) {
         ?>
        <tr> 
          <td> 
            <?php echo $i; ?>
          </td>
          <td> 
            <?php echo $row['mem_name']; ?>
          </td>
          <td> 
            <?php echo $row['mem_email']; ?>
          </td>
          <td> 
            <?php echo $row['mem_division']; ?>
          </td>
          <td> 
            <?php echo $row['mem_department']; ?>
          </td>
          <td><a href="delete.php?var1=admin&var2=<?php echo $row['mem_id'];?>">Delete</a></td>
        </tr>
        <?php
        $i++;
        }
      } else {
        echo '<tr><td>No results found</td></tr>';
      }
        ?>
      </table>
      <?php
    }

Answer 1

HTML

<form method="get">
     <input type="text" name="userid" placeholder="search" />
     <inpu type="submit" value="Search" />
</form>

PHP

$whr="";

if(isset($_GET['userid'])){
   $whr.= " and mem_id='".$_GET['userid']."'"; // which field you want. If you want to do search name use LIKE instead =(equal to)
}

MYSQL

$result = $result=mysql_query("SELECT * FROM members WHERE mem_role='USER' ".$whr);// add whr variable here