Reload PHP page with data from mysql after interval

Question

I have a php page which finds the active events from mysql and loops through the result and then print the details. It find the event name, event start time and total joined users, but the page's data only refreshes when the user reopen the page, what i want is only for the joined users column to update after some interval.

$result=fetchEventList();
if ($result->num_rows > 0) {

  while($row = $result->fetch_assoc()) {
  echo "<div class=\"row\">                                                                                                                                               
        <div class=\"td td1\">".$row["EventName"]."</div>                                                                                 
        <div class=\"td td2\">".$row["StartTime"]."</div>                                                                                                                                                                                                                                             
        <div class=\"td td3\">".$row["JoinedUsers"]."</div>";
}
}

I searched and found many answers using javascript and loading only a div, but its not working for me, i tried

<script type = \"text/javascript\">                                                                                                                                         
setInterval(\"my_function();\", 5000);                                                                                                                                      
function my_function(){                                                                                                                                                     
$('.td3').load(location.href + ' #time');                                                                                                                               
}

But its not working, can anyone nudge me in the direction to follow, also i dont' want to refresh the whole page again, just the joined users div for all the events

That's not how you call a named callback, write it like this setInterval( my_function, 5000); , setInterval will call the function after the timer is done. — darklightcode
– darklightcode, Commented Jan 31, 2020 at 7:48
@darklightcode i tried that also, but what it does it that when it refreshes the div, it gets blank — Prateek Pandey
– Prateek Pandey, Commented Jan 31, 2020 at 7:52

Jason · Accepted Answer · 2020-01-31 08:10:17Z

You can't "reload" only a div. This is an example that would refresh the page for the user after 5 seconds:

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <meta http-equiv="X-UA-Compatible" content="ie=edge">
  <title>Document</title>
</head>
<body>
  <script>
    setTimeout(function() {
      location.reload();
    }, 5000);
  </script>
</body>
</html>

To update the contents on only the div (without a page refresh), you would need an AJAX call.

In JQuery, you would use the $.get() method and set the content with $(divElem).html(result).

Something like:

// Set interval will repeat at a specified time interval
// in this case, every 5 seconds
setInterval(function () {
  // Our AJAX call to get the updated PHP results
  $.get('yourPage.php', function(result) {
    // Put the results in the div
    $(yourDiv).html(result);
  });
}, 5000);

semplon · Accepted Answer · 2020-01-31 08:09:48Z

0

this had to do with ajax and setInterval. first you load the data and display it at the div. execute javascript to call the ajax request to get the data based on iterval time.

and then display it into your div.

answered Jan 31, 2020 at 8:09

semplon

1561 silver badge7 bronze badges

Collectives™ on Stack Overflow

Reload PHP page with data from mysql after interval

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related