带有 Bootstrap 的 JavaScript 表格过滤器

Question

你好，我的表格过滤器有问题，它们可以工作，但是当我输入例如 John 时，有 3 个 Johns，我在表格之间有一些空白。我认为这是因为我没有使用 foreach 来正确显示我的信息。如果你写在 theta 的名字中，你是否可以得到关于它下面所有 tbody 信息的信息？

$(document).ready(function(){
  $("#myInput").on("keyup", function() {
    var value = $(this).val().toLowerCase();
    $("#myTable tr").filter(function() {
      $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
    });
  });
});

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<div class="row">
	
        <div class="container-bg"></div>


            <div class="col-lg-6 col-md-12">
				<div id="content" class="content-padding">
                    <div class="content">
					<input class="form-control" id="myInput" type="text" placeholder="Meklēt..">

							<table id="myTable" class="table table-sm table-bordered table-hover">
							<thead class="bg-primary">
    <tr>
      <th colspan="6">Title</th>
    </tr>
  </thead>
  <tbody id="myTable">

								<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">John Johnson</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test 3</td>
								</tr>
	</tbody>
  
  							<thead class="bg-primary">
    <tr>
      <th colspan="6">Title 2</th>
    </tr>
  </thead>
  <tbody id="myTable">

								<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">Greg Buchanek</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test 3</td>
								</tr>
	</tbody>
  
  							<thead class="bg-primary">
    <tr>
      <th colspan="6">Title 3</th>
    </tr>
  </thead>
  <tbody id="myTable">

								<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">Kavin JP Morgan</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test 3</td>
								</tr>
                	<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">Esmeralda Dupond</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test 3</td>
								</tr>
                	<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">Andrew JoShnson</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test 3</td>
								</tr>
	</tbody>
</table>	

                    </div>
                </div>
            </div>
	<?php get_sidebar('right'); ?>	
    </div>

我的 PHP foreach 循环代码:

<div class="row">

            <div class="container-bg"></div>

                <?php get_sidebar(); ?>
                <div class="col-lg-6 col-md-12">
                    <div id="content" class="content-padding">
                        <div class="content">
                        <input class="form-control" id="myInput" type="text" placeholder="Meklēt..">

                                <?php foreach ($division as $obj_1) { ?>
                                <table id="myTable" class="table table-sm table-bordered table-hover">
                                <thead class="bg-primary">
        <tr>
          <th colspan="6"><?php echo $obj_1->title ?></th>
        </tr>
      </thead>
      <tbody id="myTable">
      <?php foreach ($result as $obj) { ?>
                                <?php if( $obj_1->id ==  $obj->division) {?>
                                    <tr>
                                        <td class="p-sm-3"><?php echo $obj->position ?></td>
                                        <td class="p-sm-2"><?php echo $obj->first_name." ".$obj->surname ?></td>
                                        <td class="p-sm-1"><?php echo $obj->phone ?></td>
                                        <td class="p-sm-1"><?php echo $obj->mobile ?></td>
                                        <td class="p-sm-1"><?php echo $obj->email ?></td>
                                        <td class="p-sm-1"><?php echo $obj->location ?></td>
                                    </tr>
                                <?php }?>
        <?php }?>
        </tbody>
    </table>    
            <?php }?>
                        </div>
                    </div>
                </div>
        <?php get_sidebar('right'); ?>  
        </div>

This is how it looks on my website with foreach loops

Answer 1

请尝试此代码，它可以正常工作。

$(document).ready(function(){
  $("#myInput").on("keyup", function() {
    var value = $(this).val().toLowerCase();
    $("#myTable tbody tr").filter(function() {
      $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
    });
  });
});

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<div class="row">
	
        <div class="container-bg"></div>


            <div class="col-lg-6 col-md-12">
				<div id="content" class="content-padding">
                    <div class="content">
					<input class="form-control" id="myInput" type="text" placeholder="Meklēt..">

							<table id="myTable" class="table table-sm table-bordered table-hover">
							<thead class="bg-primary">
    <tr>
      <th colspan="6">Title 1</th>
    </tr>
  </thead>
  <tbody id="myTable">

								<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">John Johnson</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test a</td>
								</tr>
	</tbody>
  
  							<thead class="bg-primary">
    <tr>
      <th colspan="6">Title 2</th>
    </tr>
  </thead>
  <tbody id="myTable">

								<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">Greg Buchanek</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test a</td>
								</tr>
	</tbody>
  
  							<thead class="bg-primary">
    <tr>
      <th colspan="6">Title 3</th>
    </tr>
  </thead>
  <tbody id="myTable">

								<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">Kavin JP Morgan</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test 3</td>
								</tr>
                	<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">Esmeralda Dupond</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test 3</td>
								</tr>
                	<tr>
									<td class="p-sm-3">CEO</td>
									<td class="p-sm-2">Andrew JoShnson</td>
									<td class="p-sm-1">test</td>
									<td class="p-sm-1">test 1</td>
									<td class="p-sm-1">test 2</td>
									<td class="p-sm-1">test a</td>
								</tr>
	</tbody>
</table>	

                    </div>
                </div>
            </div>
	<?php get_sidebar('right'); ?>	
    </div>

注意:- 在上面的代码中给出了三个不同的标题 1-2-3。如果你搜索 test a 然后给输出不同的 thead 匹配值。

希望上面的代码对你有用。

谢谢。