PHP+AJAX refresh div not correctly working

Question

I am trying to refresh SQL data that is displayed onto my page. I want it to refresh every second. At the moment, after the balance has been displayed, after the 1 second the data stays but it doesn't update.

JS Code:

<script>
$(document).ready(
        function() {
            setInterval(function() {
                var htmlstring= "<?php echo "Balance: $".$_SESSION['Money']." || "; ?>";
                $('#money').text(htmlstring);
            }, 1000);
        });
</script>

HTML+PHP code:

<span id="money"><?php echo "Balance: $".$_SESSION['Money']." || ";?></span>

This is where the session is being set:

session_start();
$con = mysqli_connect("localhost", "root", "", "website");
if (isset($_SESSION['UserID'])) {
$result = $con->query("select * from users where   UserID=".$_SESSION['UserID']);
$row = $result->fetch_assoc();
    $_SESSION['Money'] = $row['Money'];

Could it be because the session that is set isn't being refreshed? If so, how would I change that?

The session variable is not being refreshed. Where is the code for setting the session variable? — Jay Blanchard, Jun 03 '16 at 19:44
Every time you do the interval call you have to run the query which sets the session variable. — Jay Blanchard, Jun 03 '16 at 19:47
@jayBlanchard so where do I put the PHP code with the query? I'm new to using ajax... — Lewis Hoggerson, Jun 03 '16 at 19:49
Ask your SESSION data by AJAX, like here: http://stackoverflow.com/questions/5687600/jquery-call-ajax-every-10-seconds — victorf, Jun 03 '16 at 19:49
You're not using AJAX here. Under normal conditions it would be [page with AJAX makes a request to PHP code which returns values to AJAX](http://jayblanchard.net/basics_of_jquery_ajax.html). — Jay Blanchard, Jun 03 '16 at 19:50
That's what @JayBlanchard said. BTW, is it better for community pointing this question as duplicate, as question 5687600 helps to solve it? — victorf, Jun 03 '16 at 19:52
But I've tried implementing what is said there into my code and it doesnt work. — Lewis Hoggerson, Jun 03 '16 at 23:32

PHP+AJAX refresh div not correctly working

0 Answers0