jQuery 快速搜索插件修改 JSON

发布于 2024-08-11 06:23:31 字数 938 浏览 4 评论 0原文

我已经实现了 Rik Lomas 的 quicksearch 插件，我喜欢将其用于自定义 CMS 中的应用程序我正在建设。不过我想知道，因为我将在表中包含数十亿个项目，是否有一种方法可以使用 json 回调中的数据在用户搜索时填充表而不是表内容本身。

因此，当您加载页面时，事件链将如下所示：

-jQuery.getJSON 请求 -启动快速搜索并限制表中最初显示的行数 - 当用户在过滤器中进行击键时，将从 JSON 数据而不是表内容中提取新值（仍然限制表中显示的数量），并且表会更新。

我的 JSON 请求：

$.getJSON("jsonrequest.php", function(data){

    $.each(data, function(i){
        $("#result tbody").append('<tr><td>' + this.organization + '</td><td>' + this.city + '</td><td>' + this.state + '</td></tr>');
    });

});

我的快速搜索功能：

$('table#result tbody tr').quicksearch({
    position: 'before',
    attached: 'table#result',
    stripeRowClass: ['evenrows', ''],
    labelText: 'Filter Results: ',
    loaderText: '',
    delay:0,
    focusOnLoad:true
});

原文

I've implemented the quicksearch plugin by Rik Lomas and I love it for an application in a custom CMS I'm building. I was wondering though, since I'm going to have a bizillion items in the table if there's a way to use the data from my json callback to populate the table as a user searches rather than the table contents themselves.

So when you load the page the chain of events would go something like this:

-jQuery.getJSON request
-Initiate quicksearch and limit the number of rows initially presented in the table
-As the user makes keystrokes in the filter, the new values are pulled from the JSON data rather than the table contents (still limiting the number displayed in the table) and the table is updated.

My JSON request:

$.getJSON("jsonrequest.php", function(data){

    $.each(data, function(i){
        $("#result tbody").append('<tr><td>' + this.organization + '</td><td>' + this.city + '</td><td>' + this.state + '</td></tr>');
    });

});

My quicksearch function:

$('table#result tbody tr').quicksearch({
    position: 'before',
    attached: 'table#result',
    stripeRowClass: ['evenrows', ''],
    labelText: 'Filter Results: ',
    loaderText: '',
    delay:0,
    focusOnLoad:true
});

分享到QQ

分享到微博