dongzi0602 2019-02-14 23:12
浏览 38

用php和html 130.000记录具有ajax功能的数据库

Good night, I'm trying to list in html 130.000 records, the fact is that I made the code so that it could be listed by ajax-js, and I added a feature to filter by a field of the table, however I must show 130.000 record with the functionality before said, try to use Clusterize.js, however I was not successful, since it works by dynamic creation with js, and my sun is created from the records that come from the database, the fact is that doing so, only shows 40,000 records and js does not work, know any way to solve this? I know that the page also exists but that would invalidate the search or filtered by the field, so it did not solve it by that method.

I will put a sample as a filter by the first field (so you can get an idea of why I do not solve it per page):

 function ocultarRegistros(nombre_buscar){
       // variable para todos los registros
       var registros = tableBody[0].getElementsByTagName('tr');

    // expresion regular que busca el nombre con case insensitive
    var expression = new RegExp(nombre_buscar, "i");

    for(var i = 0; i < registros.length;i++) {
        registros[i].classList.add('ocultar');
        registros[i].style.display = 'none';

        if(registros[i].childNodes[1].textContent.replace(/\s/g, "").search(expression) != -1 ) {
            registros[i].classList.add('mostrar');
            registros[i].classList.remove('ocultar');
            registros[i].style.display = 'table-row';
        }
    }
    actualizarNumero();
}

inputBuscador.addEventListener('input', function() {
  ocultarRegistros(this.value);
} );
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 微信会员卡等级和折扣规则
    • ¥15 微信公众平台自制会员卡可以通过收款码收款码收款进行自动积分吗
    • ¥15 随身WiFi网络灯亮但是没有网络,如何解决?
    • ¥15 gdf格式的脑电数据如何处理matlab
    • ¥20 重新写的代码替换了之后运行hbuliderx就这样了
    • ¥100 监控抖音用户作品更新可以微信公众号提醒
    • ¥15 UE5 如何可以不渲染HDRIBackdrop背景
    • ¥70 2048小游戏毕设项目
    • ¥20 mysql架构,按照姓名分表
    • ¥15 MATLAB实现区间[a,b]上的Gauss-Legendre积分