auto load data from database using jquery

Question

I would like to display newly inserted data from database. I found the below code from another question and it does what I want but it only shows the data when clicked. So can someone tell me how can I make the data auto load every 5 secs?

 <script type="text/javascript">

 $(document).ready(function() {

  $("#display").click(function() {                

  $.ajax({    //create an ajax request to load_page.php
    type: "GET",
    url: "second.php",             
    dataType: "html",   //expect html to be returned                
    success: function(response){                    
        $("#responsecontainer").html(response); 
        //alert(response);
    }

});
 });
});

</script>

<input type="button" id="display" value="Display All Data" />
<div id="responsecontainer" align="center">

Arun P Johny · Accepted Answer · 2013-11-15 03:07:16Z

2

$(document).ready(function () {

    function load() {
        $.ajax({ //create an ajax request to load_page.php
            type: "GET",
            url: "second.php",
            dataType: "html", //expect html to be returned                
            success: function (response) {
                $("#responsecontainer").html(response);
                setTimeout(load, 5000)
            }
        });
    }

    load(); //if you don't want the click
    $("#display").click(load); //if you want to start the display on click
});

answered Nov 15, 2013 at 3:07

Arun P Johny

389k68 gold badges532 silver badges532 bronze badges

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

1 Comment

rupesh Over a year ago

Hi arun your code will hit for every 5 seconds. even if there is no action we are sending unnecessary request to server for every 5 sec.

Edper · Accepted Answer · 2013-11-15 03:06:20Z

0

Try to add setTimeout:

success: function(response){                    
    $("#responsecontainer").html(response);
    setTimeout(success, 5000);
}

answered Nov 15, 2013 at 3:06

Edper

9,3621 gold badge32 silver badges49 bronze badges

Comments

Ardy · Accepted Answer · 2013-11-15 03:13:08Z

0

You can use function setTimeout as a timer to trigger. For detail, please look at below code:

    $(document).ready(function() {
        loadData();
    });

    var loadData = function() {
        $.ajax({    //create an ajax request to load_page.php
            type: "GET",
            url: "second.php",             
            dataType: "html",   //expect html to be returned                
            success: function(response){                    
                $("#responsecontainer").html(response);
                setTimeout(loadData, 5000); 
            }

        });
    };

answered Nov 15, 2013 at 3:13

Ardy

1613 bronze badges

Comments

2 revs user1625871 · Accepted Answer · 2017-05-23 12:07:25Z

0

You may use jquery's setInterval() or setTimeout() inside onload(); refer to the following questions, its answer explains well what you need exactly.

Calling a function every 60 seconds

edited May 23, 2017 at 12:07

community wiki

2 revs
user1625871

Collectives™ on Stack Overflow

auto load data from database using jquery

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related