title: How can I filter through an SQL generated table using a search box?
body: <p>This is what I have currently (which doesn't do anything)</p>
  <pre><code>&lt;input type=&quot;text&quot; id=&quot;search&quot; &quot; placeholder=&quot;Search..&quot;&gt;
  
  &lt;table id='table'&gt;
      &lt;!-- INVENTORY TABLE --&gt;
      &lt;?php
      $query = &quot;SELECT * FROM StatesboroSwitchActive&quot;;
      $result = mysqli_query($db, $query);
      $count = 0;
  
      echo &quot;
      &lt;tr&gt;
      &lt;th&gt;&lt;/th&gt;
      &lt;th&gt;&lt;/th&gt;
      &lt;th&gt;Name&lt;/th&gt;
      &lt;th&gt;Model&lt;/th&gt;
      &lt;th&gt;Serial&lt;/th&gt;
      &lt;th&gt;MAC&lt;/th&gt;
      &lt;th&gt;Type&lt;/th&gt;
      &lt;th&gt;Notes&lt;/th&gt;
      &lt;th&gt;Cisco Notes&lt;/th&gt;
      &lt;th&gt;Location&lt;/th&gt;
      &lt;/tr&gt;&quot;;
      while ($row = mysqli_fetch_array($result)) {
          $count++;
              echo &quot;&lt;tr&gt;&lt;td&gt;&quot; . &quot;&lt;button id='delete'&gt;RMA&lt;/button&gt;&quot; .
              &quot;&lt;/td&gt;&lt;td&gt;&quot; . &quot;&lt;button id='modify'&gt;Modify&lt;/button&gt;&quot; .
              &quot;&lt;/td&gt;&lt;td&gt;&quot; . $row['Name'] .
              &quot;&lt;/td&gt;&lt;td&gt;&quot; . $row['Model'] .
              &quot;&lt;/td&gt;&lt;td&gt;&quot; . $row['Serial'] .
              &quot;&lt;/td&gt;&lt;td&gt;&quot; . $row['MAC']  .
                  &quot;&lt;/td&gt;&lt;td&gt;&quot; . $row['Type']  .
                  &quot;&lt;/td&gt;&lt;td&gt;&quot; . $row['Notes']  .
                  &quot;&lt;/td&gt;&lt;td&gt;&quot; . $row['Cisco Notes']  .
                  &quot;&lt;/td&gt;&lt;td&gt;&quot; . $row['Location']  . &quot;&lt;/td&gt;&lt;/tr&gt;&quot;;
      }
      echo &quot;&lt;h3&gt;Total: &quot; . $count . &quot;&lt;/h3&gt;&quot;;
      ?&gt;
  </code></pre>
  <p>I want to be able to use the search box to make this table filter down into what is typed by the user. I am pretty lost right now</p>