How to refresh data value loaded from external database in wordpress pages

Asked Sep 06 '19 at 22:52

Active Sep 06 '19 at 23:13

Viewed 110 times

I want to display data values from an external mysql database in wordpress pages. I have used this php code which works fine inside a php widget :

<?php

$host = "xxx.xxx.xxx.xx";
$user = "user";
$pass = "Password2000!";
$db_name = "my_database";

//create connection
$dbcon = mysqli_connect($host, $user, $pass, $db_name);

//test if connection failed
if (mysqli_connect_errno()) {
    die("connection failed: "
        . mysqli_connect_error()
        . " (" . mysqli_connect_errno()
        . ")");
}
$sqlget = " SELECT Value FROM Points WHERE Name_ID = 'Hall' ";
$sqldata = mysqli_query($dbcon, $sqlget);
while ($row = mysqli_fetch_array($sqldata)) {
    echo sprintf('%.1f', $row['Value']);
    echo " °C";
}
}

?>

But my question is how to refresh the value periodically without reloading the page. Best regards.

edited Sep 06 '19 at 23:13

atymic

3,093
1
13
26

asked Sep 06 '19 at 22:52

hicham2000

You'll need to add javascript and use a timer function to reload the content via AJAX. – dazed-and-confused Sep 07 '19 at 02:09
For that you need to used ajax for reload data without page refresh. – Usdad Pravin Sep 07 '19 at 07:01
Hello,thank you for your reply. Please how can i modify the php code to do this? – hicham2000 Sep 09 '19 at 00:05

How to refresh data value loaded from external database in wordpress pages

0 Answers0