How do I show only 5 results by default?

Question

I have a search bar, by default it's loading all the data under the search bar. I want to limit the default before searching to be only 5 results in the table.

I'm trying this but it doesn't work! What I'm doing wrong?

<script>
$(document).ready(function(){
    load_data();
    function load_data(query)
    {
        $.ajax({
            url:"fetch.php",
            method:"post",
            data:{query:query},
            success:function(data)
            {
                $('#result').html(data);
            }
        });
    }

    $('#search_text').keyup(function(){
        var search = $(this).val();
        if(search != '')
        {
            load_data(search);
            $('#result').dataTable({'iDisplayLength': 5});
        }
        else
        {
            load_data();            
        }
    });
});
</script>

And the HTML part is just this code:

<div id="result"></div>

Yes, I want to limit the data to be only 5 result to make it pagination — jason5137715, Mar 28 '19 at 09:32
Are you using an external library to implement that autocomplete? — Rafa Romero, Mar 28 '19 at 09:32
@yunzen no, it's connected to mysql database, this script for searching inside that database — jason5137715, Mar 28 '19 at 09:33
Try moving the `$('#result').dataTable({'iDisplayLength': 5});` into your ajax `success` method instead of the `$('#result').html(data);` — yunzen, Mar 28 '19 at 09:34
@RafaRomero I have other file with database info and at the end is this "echo $output;" should I control it from there instead? — jason5137715, Mar 28 '19 at 09:35
@ZakariaAcharki I move it, but it show nothing at all, no result befure or after the search — jason5137715, Mar 28 '19 at 09:41
I'm trying to make it look like this example @rai https://www.phpflow.com/demo/jquery_pagination_with_php_demo/index.php?page=6 — jason5137715, Mar 28 '19 at 09:44
one question @jason5137715. Do you want to retrieve data `5` each or retrieve all and display `5` in each page? — Harshith Rai, Mar 28 '19 at 09:46
that'd be easy.. can you add your html part to the question? — Harshith Rai, Mar 28 '19 at 09:59
I'm trying to make exaclty like this example https://www.jqueryscript.net/demo/sorting-filtering-pagination-fancytable/ — jason5137715, Mar 28 '19 at 13:17
If you're using angular... [This article](https://stackoverflow.com/questions/10816073/how-to-do-paging-in-angularjs) should come in handy. — Harshith Rai, Mar 29 '19 at 05:31

score 0 · Answer 1 · answered Mar 29 '19 at 05:34

0

if you are using datatbles then you have to pass pageLength: 5.

$('#example').dataTable( {
  "pageLength": 5
} );

you can see in this link

answered Mar 29 '19 at 05:34

Shubham Gupta

35
11

How do I show only 5 results by default?

1 Answers1