Refresh PHP sql query without refreshing page

Question

I have a question, and I'm hoping one of you will know the answer.

I am running a sql query from php fro a certain bit of information. I am then pulling that info into script and plugging it into an api. I want the api to have access to up to date info every 30 seconds. However, obviously, although the script can run again every 30 seconds ... the php cannot, thus the info is the same.

Is it possible therefore to have the php that runs the sql query refresh once every 30 seconds without refreshing the entire page?

Or ... is there a better way to be doing this. I believe it is no a good idea to be accessing the database from javascript?

Thanks in advance.

The page can send ajax request for updated info, and then put the new data where you want to see it. — MightyPork
– MightyPork, Commented Aug 6, 2013 at 16:49

James · Accepted Answer · 2013-08-06 16:53:02Z

5

You're looking for AJAX. There are plenty of tutorials on the net explaining how to create simple pages powered by AJAX.

A quick example can be found here.

(function() {
 setInterval(function() {
     $.ajax({
        async: true,
        dataType: 'json',
        type: 'GET',
        url: '/echo/json',
        success: function(data) {
            // You'd use data variable here, but JSFiddle doesn't return anything
            $('#test').html(Math.floor(Math.random()*100)-1); // Changes randomly after every fetch
        }
     });
 }, 200); 
}());

answered Aug 6, 2013 at 16:53

James

5,1697 gold badges43 silver badges80 bronze badges

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

Comments

EricGS · Accepted Answer · 2013-08-06 17:03:23Z

1

ajax is wath you are looking for,

ajax allows u to make a call to ur server whitout reloading your page.

i will recomend creating a page that only contains your data, then, on your aplication page load it into a div like

<div id="yourData"></div>

u can use James answer to load it, change '#test' for '#yourData' on any id u have on the div.

if u are using jquery u can use .load() also, for me is more clear, http://api.jquery.com/load/

$('#yourData').load('YourAplication/YourDataGeneratorPage.html');

answered Aug 6, 2013 at 17:03

EricGS

1,3432 gold badges18 silver badges42 bronze badges

Collectives™ on Stack Overflow

Refresh PHP sql query without refreshing page

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related