Javascript real time counter not updating

Question

I'm trying to update a value from the database in real-time using Javascript and PHP. Though the value keeps updating in the database, it doesn't refresh on screen unless I manually refresh the page. Any pointers?

div class="panel-body" id = "tweetCounter">
<script>
//Javascript function that calls the PHP function
function tweetCounter()
{
var getTweetCount = <?php updateTweetCount();?>;
document.getElementById('tweetCounter').innerHTML = getTweetCount;
}
tweetCounter();

//Call function every 30 seconds
setInterval(function(){
tweetCounter();
}, 30000);
</script>

<!--PHP function to fetch details from DB -->
<?php
function updateTweetCount()
{
include('dbconnect.php');
$sql = "SELECT COUNT(tweetId) as tweetcount from brexittweets";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo $row["tweetcount"];
}
} else {
echo "0 results";
}
}
?>

</div>

That will not work. You can't recall php code in that way – Pavlo Zhukov Apr 25 '17 at 22:08 — Pavlo Zhukov, Apr 25 '17 at 22:08
@Pavlo Zhukov Yes, I understood as much. What will work? – Varun B. Krishnan Apr 25 '17 at 22:10 — Varun B. Krishnan, Apr 25 '17 at 22:10
Make endpoint for it and call it by AJAX – Pavlo Zhukov Apr 25 '17 at 22:11 — Pavlo Zhukov, Apr 25 '17 at 22:11
Thanks Pavlo Zhukov, I rewrote it using AJAX and it works. – Varun B. Krishnan Apr 25 '17 at 22:25 — Varun B. Krishnan, Apr 25 '17 at 22:25

Javascript real time counter not updating

0 Answers0