Jquery load function getting stuck after first load

Question

Hi I have this sample code to load random quotes.

PHP Code:

<?php
  //Selecting Random quotes from database --randomquotes.php
  require('dbconnection.php');
  // $temp=10;
  $sql = "SELECT * FROM db.q order by rand() LIMIT 1";
  $res = mysql_query($sql,$con);
  while ($res1=mysql_fetch_assoc($res))
  { 
    print "<em>".$res1['quote']."</em>";
  }
?>

HTML CODE:

<div class="class_box_shadow_quote">
<?php
  require('randomquotes.php');
?>
</div>

Jquery Code:

<script>
  var $j = jQuery.noConflict();
  $j(document).ready(function(){
    setInterval(function() {
      $j(".class_box_shadow_quote").load('randomquotes.php');
    }, 7000);
  });
</script>

This code is working well for the first time , but is getting stuck on second quote and is not changing the quote. Also everytime i see the second quote to be the same always. What is the problem . Please help?

techfoobar · Accepted Answer · 2012-09-29 18:43:24Z

2

I believe the output is being cached by jQuery. You can try with caching disabled.

setInterval(function() {
    $j.ajax({
        url: 'randomquotes.php',
        cache: false,
        success: function(data) {
            $j(".class_box_shadow_quote").html(data);
        }
    });
}, 7000);

answered Sep 29, 2012 at 18:43

techfoobar

66.8k14 gold badges117 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Simon Germain · Accepted Answer · 2012-09-29 18:48:55Z

0

Try adding a random seed at the end of your URL to avoid browser caching, like so:

    $(".class_box_shadow_quote").load('randomquotes.php?s=' + (Math.Random() * 1000000))

answered Sep 29, 2012 at 18:48

Simon Germain

6,8641 gold badge29 silver badges42 bronze badges

3 Comments

Pratik Mehta Over a year ago

Wow this is new to me...but the previous solution was easy to avoid caching .

Simon Germain Over a year ago

Sometimes, manipulating the cache headers don't work. I've run into that problem several times. It's getting better though. :)

techfoobar Over a year ago

Actually cache: false does the same. It adds a randomizer to the url.

Collectives™ on Stack Overflow

Jquery load function getting stuck after first load

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related