Skip to main content

How to make a Table with search and filter functionality dynamically using jQuery?

<html lang="en">

<head>
<title>Table for Learning</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<style>
th,td,tr{border: 1px solid #0000ff; text-align: center; border-collapse: collapse;}
table{
border: 1px solid orange; border-collapse: collapse; text-align: left;
}
tr:hover{
color: green;
}
</style>

</head>

<body>
<h1>Data From Server</h1>
<input type="text" id="search" placeholder="search here..">
<select name="" id="onSelect"></select>

<table id='mn'>
<thead>
<tr>
<th>Id</th>
<th>Name</th>
<th>User Name</th>
<th>Email</th>
<th>City</th>
</tr>
</thead>
<tbody>

</tbody>
</table>

<script>
$(function () {
$('#onSelect').append('<option value="">select user</option>');

function getDataFromURL() {
$.ajax({
url: "https://jsonplaceholder.typicode.com/users",
type: "GET",
success: function (response) {
console.log(response);

response.forEach(function (d) {
optObj={}
// console.log(td);
var html = '<tr><td>' + d.id + '</td><td>' + d.name +
'</td><td>' + d.username + '</td><td>' + d.email +
'</td><td>'+d.address.city+'</td></tr>';
$('table tbody').append(html);
$('#onSelect').append('<option value=' +d.username+ '>' + d.username +
'</option>');
});
},
error: function (err) {
console.log(err);
}
});

}
getDataFromURL();
$('#search').on('keyup', function () {
var searchkey = $('#search').val().toLowerCase();
$('#mn tbody tr').filter(function () {
$(this).toggle($(this).text().toLowerCase().indexOf(searchkey) > -1);
});
});

$('#onSelect').on('click', function () {
var selVal = $('#onSelect').val().toLowerCase();
console.log(selVal);
$('#mn tbody tr').filter(function () {
$(this).toggle($(this).text().toLowerCase().indexOf(selVal) > -1);
});
})
})
</script>

</body>

</html>


output is:

Comments

Post a Comment

Popular posts from this blog

How to send email using SharePoint REST API in jQuery/JavaScript?

  Send email using SharePoint REST API in jQuery/JavaScript: We can able to send email to the SharePoint user using below REST API on SharePoint Online. We need to load SP.js file in code. we must need to give valid SharePoint user to send email. We can able to send email to valid SharePoint user of same organization.      var   restAPI  =  _spPageContextInfo . webAbsoluteUrl  +  "/_api/SP.Utilities.Utility.SendEmail" ;      $ . ajax ({          contentType:   'application/json' ,          url:   restAPI ,          type:   "POST" ,          data:   JSON . stringify ({              'properties' :  {             ...

How to get all site users of SharePoint using REST API?

Get all users of SharePoint site using REST API: These users and its data are required to update people field of a SharePoint list. By using below snippet code we can able to get details of a user of SharePoint site.     var webURL = _spPageContextInfo.webAbsoluteUrl+"/_api/Web/SiteUsers";         $.ajax({           url: customFieldURL,           method: "GET",           headers: {             "Accept": "application/json; odata=verbose"           },           success: function (data) {            console.log(data);             data.d.results.forEach(function(cm){                     console.log(cm.Title+" - "+cm.Email+" - "+cm.Id);             });      ...