How to check Every 30 minute if new data insert in db?

Question

I want to reload my web page automatically if new row insert or delete any row or update.

I want to check it every 30 munite.

if new if new row insert or delete any row or update then reload my website.

<ul>
    foreach($output['result'] as $key => $val) {

                print'<li data-artist="'.$val['artist'].'" data-title="'.$val['songName'].'" data-album="'.$val['songName'].'" data-info="" data-image="" data-duration="348">
                    <div class="amazingaudioplayer-source" data-src="http://somthing.info/'.$val['songUrl'].'" data-type="audio/mpeg" />
                </li>';         

    }
      </ul>

when any one first visit my website the i print data with this foreach. if new if new row insert or delete any row or update then reload my website and my foreach retrieve data from database.

please help me how can i do this.

Make an ajax request to php script every 30 minute. It is as simple as that — , Dec 16 '13 at 14:10
I can see that you've tagged this with ajax. That is correct. You'd use AJAX. — h2ooooooo, Dec 16 '13 at 14:10
if your data is loaded using an ajax call. this can be easily done with the help of ajax. simply you need to send a ajax call every 30 mins. — dev1234, Dec 16 '13 at 14:11
http://stackoverflow.com/questions/4930439/call-jquery-ajax-request-each-x-minutes — The Humble Rat, Dec 16 '13 at 14:11

score 2 · Answer 1 · answered Dec 16 '13 at 14:16

2

In the head you should define as following to refresh the page every 30 mins.

<head>
<meta http-equiv="refresh" content="1800" />
</head>

but this is not the best way to do, you must use ajax. so something like this can be done easily.

setInterval(function(){
  $.ajax({
    url: '/',
    type:"POST",
    data:"", 
    success: function(data){
      //render the dynamic data into html
    }
  });
}, 10000);

check this example to see how you can do the same with ajax. http://www.tutorialspoint.com/php/php_and_ajax.htm

answered Dec 16 '13 at 14:16

dev1234

5,376
15
56
115

It would not check for data modifications. Server side help is also required I believe. – sulmanpucit Dec 16 '13 at 14:18
1

yes i have updated the answer including an ajax example. – dev1234 Dec 16 '13 at 14:19

score 0 · Answer 2 · answered Dec 16 '13 at 14:18

you can try something like this using jquery

var seconds = 1800; //add your time interval here

setInterval(function(){
  $.ajax({
      url: 'url of file, which will check the update',
      data: 'pass any data or cache buster in case of proxy'
  });
}, seconds * 1000)

score -1 · Answer 3 · answered Dec 16 '13 at 14:20

-1

Put a cron on your server to check if new data inserted in the database based on a previously saved db stat.

answered Dec 16 '13 at 14:20

I do not think cron job will help here. He want to update page. Nothing sounds like cron job. – sulmanpucit Dec 16 '13 at 14:32

How to check Every 30 minute if new data insert in db?

3 Answers3