从 HTML 表中检索过滤后的数据并将其格式化为数组

我一直在 PHP 系统中开发一个函数，我可以在其中过滤记录，然后将其导出到具有使用 PHPSpreadSheet 模板的 Excel。我的问题是我不知道如何检索上面标题中所述的过滤记录。我想我的代码中遗漏了一些东西。这是我将记录从数据库提取到表中的代码。

<?php
    $conn = mysqli_connect("localhost", "root", "", "db_ims");
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT * FROM tbl_par";
$result = mysqli_query($conn, $sql);

      echo "<table id='myTable'>";
      echo "<thead><tr><th>Article</th>
      <th>Description</th>
      <th>Property Number</th>
      </tr></thead>";
      echo "<tbody>";
      while ($row = mysqli_fetch_assoc($result)) {
      echo "<tr>";
      echo "<td>" . $row['article'] . "</td>";
      echo "<td>" . $row['description'] . "</td>";
      echo "<td>" . $row['propertyNumber'] . "</td>";
      echo "</tr>";
      }
      echo "</tbody>";
      echo "</table>";

// Close the database connection
mysqli_close($conn);
?>
    <form action="" method="POST">
    <input type="text" id="myInput" onkeyup="filterTable()" placeholder="Search...">
    <input type="submit" id="generate" name="generate" value="Submit">
    </form>

这是我过滤记录的代码：

<script>
function filterTable() {
  // Declare variables
  var input, filter, table, tr, td, i, txtValue;
  input = document.getElementById("myInput");
  filter = input.value.toUpperCase();
  table = document.getElementById("myTable");
  tr = table.getElementsByTagName("tr");

  // Loop through all table rows, and hide those who don't match the search query
  for (i = 0; i < tr.length; i++) {
    td = tr[i].getElementsByTagName("td");
    for (var j = 0; j < td.length; j++) {
      txtValue = td[j].textContent || td[j].innerText;
      if (txtValue.toUpperCase().indexOf(filter) > -1) {
        tr[i].style.display = "";
        break;
      } else {
        tr[i].style.display = "none";
      }
    }
  }
}
</script>

最后，这是使用 PHPSpreadSheet 将过滤后的表导出到 Excel 的代码：

<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

if (isset($_POST['generate'])) {


$spreadsheet = IOFactory::load('Template.xls');

//This is the part where I don't know what to put.
$data = array();


$worksheet = $spreadsheet->getActiveSheet();
$row = 10; // Start inserting data from row 10
foreach ($data as $item) {
    $worksheet->setCellValue('A'.$row, $item['article']);
    $worksheet->setCellValue('B'.$row, $item['description']);
    $worksheet->setCellValue('C'.$row, $item['propertyNumber']);
    // ...
    $row++;
}


$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('exported_file.xlsx');
}
?>

我尝试了所有我知道的方法，但仍然没有得到我预期的结果。

如果您想提交需要回显表单内表格的值并需要提交一些内容（例如隐藏字段），那么您可以将禁用添加到您不想提交的字段

const hide = txtValue.toUpperCase().indexOf(filter) === -1 : true : false;
tr[i].style.display = hide ? "none" : "";
tr[i].querySelector("[type=hidden]").disabled = hide;

我强烈建议你在这里使用 AJAX。