javascript - How to Refresh a dynamic table without refreshing the whole html page - Stack Overflow

admin管理员组

文章数量:1347684

I have a dynamic table that displays data from a mysql database. My database is updated every time in the server. I want to refresh only the table every 2 seconds without refreshing the whole page. How can do this? Please help how acplish this?. Parts of my table look like this:

<table id="getdata" border="0" align="left" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#CCFF00">Name</td>
    <td bgcolor="#CCFF00">Comment</td>
    <td bgcolor="#CCFF00">DatePosted</td>
  </tr>
</table>

I have a dynamic table that displays data from a mysql database. My database is updated every time in the server. I want to refresh only the table every 2 seconds without refreshing the whole page. How can do this? Please help how acplish this?. Parts of my table look like this:

<table id="getdata" border="0" align="left" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#CCFF00">Name</td>
    <td bgcolor="#CCFF00">Comment</td>
    <td bgcolor="#CCFF00">DatePosted</td>
  </tr>
</table>

• javascript
• php
• jquery
• html
• ajax

Share Improve this question Follow edited Aug 22, 2016 at 6:54 kkambi asked Aug 22, 2016 at 6:10 kkambikkambi 5111 gold badge11 silver badge55 bronze badges 5

• You can do this using ajax – Zain Farooq Commented Aug 22, 2016 at 6:11
• you'll need some sort of javascript timer to loop the ajax call every # seconds – Memor-X Commented Aug 22, 2016 at 6:13
• I want to refresh the table only and nothing else on the page so how can i do that? can someone give me a full script please. – kkambi Commented Aug 22, 2016 at 10:45
• Hi guys, please help me with this. I just want to reload/refresh the table only every 5 seconds without refreshing the whole page. Please help me how to achieve this. Thanks. – kkambi Commented Sep 1, 2016 at 3:57
• Also consider the webSocket to avoid fast useless updates – Ali Sheikhpour Commented Dec 31, 2018 at 7:54

Add a ment  | 

4 Answers 4

Sorted by: Reset to default 1

You will need to use a client-side scripting language such as javascript in order to be able to refresh certain contents on your HTML page. A very mon library that is used is jQuery.

PHP

# ajax.php
$contents = '<table class="table table-hover">
    <thead>
        <tr>
            <th>Sound</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>Bzzz Bzz</td>
        </tr>
    </tbody>
</table>';

echo json_encode($content);

HTML/Javascript

<button class="refresher">Refresh table</button>
<table id="table-to-refresh">
    <thead>
        <tr>
            <th></th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td></td>
        </tr>
    </tbody>
</table>

<script type="text/javascript">
$(document).ready(function () {
    $(document).on('click', '.refresher', function () {
        $.ajax({
            url: 'ajax.php',
            method: get,
            dataType: 'json',
            success: function(response) {
                $('#table-to-refresh').html(response);
            }
        });
    });
});
</script>

Additional reading

• jQuery Docs - Ajax

<script type="text/javascript" src="http://ajax.googleapis./ajax/
libs/jquery/1.3.0/jquery.min.js"></script>
<script type="text/javascript">
var auto_refresh = setInterval(
function ()
{
$('#load_tweets').load('file.php').fadeIn("slow");
}, 10000); // refresh every 10000 milliseconds



</script>

in file put your full html and php sql code like full code by which you are generating that table.

check this for refrence http://www.9lessons.info/2009/07/auto-load-refresh-every-10-seconds-with.html

Use ajax on an specified time interval like:

$.ajax({
    url: 'your_url',
    method: get,
    data:
    {
        var1 : val1
    },
    success: function(response)
    {
        $('#getdata').html(response);       // it will update the html of table body
    }
});

just do this:

     $.ajax({
                contentType: contentType,
                dataType: dataType,
                type: type,
                url: urlGetsearch,
                data: '{textvalue: "' + $("#tableId").val() + '" }',

        success: function (textvalue) {

            $("#tableId").html(htmlData);
        },

    });
}

The controller is look like this:-

         [HttpPost]
         public ActionResult Getsearch(string textvalue)
          {
                      your code.....
          }

本文标签： javascriptHow to Refresh a dynamic table without refreshing the whole html pageStack Overflow