<form action="process.php" method="POST">
  <label for="name">姓名：</label>
  <input type="text" id="name" name="name">
  
  <label for="gender">性別：</label>
  <select id="gender" name="gender">
    <option value="Male">男</option>
    <option value="Female">女</option>
  </select>
  
  <label for="age">年齡：</label>
  <input type="number" id="age" name="age">
  
  <input type="submit" value="查詢">
</form>

$name = $_POST['name'];
$gender = $_POST['gender'];
$age = $_POST['age'];

// 連接數(shù)據(jù)庫
$conn = mysqli_connect('localhost', 'username', 'password', 'database');

// 查詢語句
$sql = "SELECT * FROM students WHERE 1=1";

// 添加查詢條件
if (!empty($name)) {
  $sql .= " AND name LIKE '%$name%'";
}

if (!empty($gender)) {
  $sql .= " AND gender='$gender'";
}

if (!empty($age)) {
  $sql .= " AND age=$age";
}

// 執(zhí)行查詢
$result = mysqli_query($conn, $sql);

// 處理查詢結(jié)果
if (mysqli_num_rows($result) > 0) {
  while ($row = mysqli_fetch_assoc($result)) {
    // 處理每一行數(shù)據(jù)
  }
} else {
  echo "沒有找到相關(guān)記錄";
}

// 關(guān)閉數(shù)據(jù)庫連接
mysqli_close($conn);

if (mysqli_num_rows($result) > 0) {
  echo "<table>";
  echo "<tr><th>姓名</th><th>性別</th><th>年齡</th></tr>";
  
  while ($row = mysqli_fetch_assoc($result)) {
    echo "<tr>";
    echo "<td>".$row['name']."</td>";
    echo "<td>".$row['gender']."</td>";
    echo "<td>".$row['age']."</td>";
    echo "</tr>";
  }
  
  echo "</table>";
} else {
  echo "沒有找到相關(guān)記錄";
}