how to search multiple columns in a table using jquery or javascript

Question

I have a searchbox as below:

<input type="text" class="form-control" onkeyup="myFunction()" id="myInput"/>

and I have a table with id="show_member" with different columns. I have written a code as below and I would like to search all columns whenever I type something in the searchbox(the input above) What is the problem with the code and how can I fix it? Not only doesn't it show the related columns but also it doesn't get removed when I delete all the letters in the search box.

    function myFunction(){
var input = document.getElementById("myInput");
//alert(input.value);
var iv = input.value;
var rows = $('table tr').hide().filter(":contains(".'iv'.")").show();
}

thanks for your help in advance

There are several examples out there for this: w3schools.com/howto/howto_js_filter_table.asp stackoverflow.com/questions/9127498/… And even a simple library if you're so inclined: listjs.com — Woodrow
– Woodrow, Commented Jun 20, 2017 at 13:39
you are making iv as string instead of a variable reference. Just remove the single quotes around it. — yqlim
– yqlim, Commented Jun 20, 2017 at 13:39
whenever I search, the <th> i mean the head part of my table is deleted. What should I do to disable it from deleting? — saeed doozandeh
– saeed doozandeh, Commented Jun 20, 2017 at 13:46

Satpal · Accepted Answer · 2017-06-20 13:39:10Z

4

Use + for string operators(concatenation) in JavaScript

$('table tr').hide().filter(":contains(" + iv +")").show();

instead of

$('table tr').hide().filter(":contains(".'iv'.")").show()

answered Jun 20, 2017 at 13:39

Satpal

134k13 gold badges168 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to search multiple columns in a table using jquery or javascript

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related