如何为HTML搜索表格添加/移除“无匹配记录”提示

问题现象 #

实现HTML表格搜索筛选功能时，期望仅在无匹配记录时显示"No records found"，但当前即使有匹配项，底部仍会错误显示该提示。

问题根源 #

原代码在遍历表格行时，每遇到一条不匹配的记录就会设置提示显示，后续若有匹配记录会暂时隐藏提示，但如果最后一条记录不匹配，提示会被再次设置为显示，导致逻辑错误。此外还存在两处小问题：

• NoRecords行的colspan属性位置错误（应放在<td>而非<tr>上）
• 搜索仅检查了第一列（Name），未覆盖Country列

修复方案 #

1. 修正HTML结构 #

调整"No records found"行的colspan位置，确保跨列显示正常：

<tr id="NoRecords" style="display:none">
  <td colspan="2">No records found</td>
</tr>

2. 重构JS逻辑 #

• 新增匹配计数器，遍历完成后统一判断是否显示提示
• 同时搜索Name和Country两列内容，提升筛选实用性
• 避免在循环中频繁切换提示的显示状态，消除逻辑冲突

修改后的JS代码：

function myFunction() {
  const input = document.getElementById("myInput");
  const filter = input.value.toUpperCase();
  const table = document.getElementById("listitems");
  const tableNorecords = document.getElementById("NoRecords");
  const tr = table.getElementsByTagName("tr");
  let matchCount = 0;

  for (let i = 0; i < tr.length; i++) {
    // 跳过提示行，不参与筛选判断
    if (tr[i].id === "NoRecords") continue;
    
    const nameTd = tr[i].getElementsByTagName("td")[0];
    const countryTd = tr[i].getElementsByTagName("td")[1];
    if (nameTd && countryTd) {
      const nameValue = nameTd.textContent.toUpperCase();
      const countryValue = countryTd.textContent.toUpperCase();
      // 检查两列是否存在匹配项
      if (nameValue.indexOf(filter) > -1 || countryValue.indexOf(filter) > -1) {
        tr[i].style.display = "";
        matchCount++;
      } else {
        tr[i].style.display = "none";
      }
    }
  }

  // 遍历结束后统一控制提示显示状态
  tableNorecords.style.display = matchCount === 0 ? "" : "none";
}

完整修复代码 #

<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
* {
  box-sizing: border-box;
}

#myInput {
  background-image: url('/css/searchicon.png');
  background-position: 10px 10px;
  background-repeat: no-repeat;
  width: 100%;
  font-size: 16px;
  padding: 12px 20px 12px 40px;
  border: 1px solid #ddd;
  margin-bottom: 12px;
}

#myTable {
  border-collapse: collapse;
  width: 100%;
  border: 1px solid #ddd;
  font-size: 18px;
}

#myTable th, #myTable td {
  text-align: left;
  padding: 12px;
}

#myTable tr {
  border-bottom: 1px solid #ddd;
}

#myTable tr.header, #myTable tr:hover {
  background-color: #f1f1f1;
}
</style>
</head>
<body>

<h2>My Customers</h2>

<input type="text" id="myInput" onkeyup="myFunction()" placeholder="Search for names.." title="Type in a name">

<table id="myTable">
    <thead>
  <tr class="header">
    <th style="width:60%;">Name</th>
    <th style="width:40%;">Country</th>
  </tr>
  </thead>
  <tbody id="listitems">
  <tr>
    <td>Alfreds Futterkiste</td>
    <td>Germany</td>
  </tr>
  <tr>
    <td>Berglunds snabbkop</td>
    <td>Sweden</td>
  </tr>
  <tr>
    <td>Island Trading</td>
    <td>UK</td>
  </tr>
  <tr>
    <td>Koniglich Essen</td>
    <td>Germany</td>
  </tr>
  <tr>
    <td>Laughing Bacchus Winecellars</td>
    <td>Canada</td>
  </tr>
  <tr>
    <td>Magazzini Alimentari Riuniti</td>
    <td>Italy</td>
  </tr>
  <tr>
    <td>North/South</td>
    <td>UK</td>
  </tr>
  <tr>
    <td>Paris specialites</td>
    <td>France</td>
  </tr>
  <tr id="NoRecords" style="display:none">
    <td colspan="2">No records found</td>
  </tr>
  </tbody>
</table>

<script>
function myFunction() {
  const input = document.getElementById("myInput");
  const filter = input.value.toUpperCase();
  const table = document.getElementById("listitems");
  const tableNorecords = document.getElementById("NoRecords");
  const tr = table.getElementsByTagName("tr");
  let matchCount = 0;

  for (let i = 0; i < tr.length; i++) {
    if (tr[i].id === "NoRecords") continue;
    
    const nameTd = tr[i].getElementsByTagName("td")[0];
    const countryTd = tr[i].getElementsByTagName("td")[1];
    if (nameTd && countryTd) {
      const nameValue = nameTd.textContent.toUpperCase();
      const countryValue = countryTd.textContent.toUpperCase();
      if (nameValue.indexOf(filter) > -1 || countryValue.indexOf(filter) > -1) {
        tr[i].style.display = "";
        matchCount++;
      } else {
        tr[i].style.display = "none";
      }
    }
  }

  tableNorecords.style.display = matchCount === 0 ? "" : "none";
}
</script>

</body>
</html>

效果说明 #

• 通过计数器统一判断匹配结果，彻底解决了提示误显示的问题
• 修复了表格布局的小错误，保证提示文本正常跨列显示
• 扩展搜索范围至两列，让筛选功能更实用

内容的提问来源于stack exchange，提问作者Ganesh Putta