PHP Update using Javascript

Question

I have my php file which contains my method to update the database. However, in Javascript how do I make it so every 5 seconds say it "visits" this page so it's contents gets updated.

Here is my update.php file:

<?php include('config.php') ?>

<?php
mysql_query("UPDATE paint SET paint_points='test'") or die(mysql_error());
echo "Updated";
?>

Sorry, I'm not familiar with the terminology.

Thanks

use javascript setInterval and AJAX to send request to php for updating — Alireza
– Alireza, Commented Mar 6, 2013 at 18:45
Check for a javascript framework such as jQuery ($.ajax) there is all the code you need to do it. — Bertrand
– Bertrand, Commented Mar 6, 2013 at 18:45
Specially, you'll have a separate page that hosts the JavaScript call. You'll make an asynchronous call to update.php on a recursive loop. (or recursive promise/deferred) — Matt Lo
– Matt Lo, Commented Mar 6, 2013 at 18:46

Sebas · Accepted Answer · 2013-03-06 18:50:55Z

2

Use the setInterval function with an (a)jax request every 5 secs in javascript:

//syncronized jax:
function myjax() {
    var oXhr = new XMLHttpRequest();
    oXhr.open("POST", "yourphp.php", false);
    oXhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded; charset=utf-8");
    oXhr.send(null);
}

//set an interval each 5 seconds to call your myjax method
setInterval(function() { myjax(); }, 5000);

In this example the request is synchronous but it could be asynchronous if you wished so.

edited Mar 6, 2013 at 18:50

answered Mar 6, 2013 at 18:45

Sebas

21.6k9 gold badges60 silver badges109 bronze badges

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

Comments

Roland Mai · Accepted Answer · 2013-03-06 18:45:30Z

1

The simplest case is to reload the page with:

<script type="text/javascript">
 setInterval(function() { location.reload(true); }, 5000);
</script>

You can get fancier if you use an ajax call to fetch the page.

answered Mar 6, 2013 at 18:45

Roland Mai

31.2k8 gold badges58 silver badges61 bronze badges

2 Comments

Sudipta Chatterjee Over a year ago

I don't think the OP is looking to reload the entire page.

Roland Mai Over a year ago

@SudiptaChatterjee Maybe, however, it's not clear. One could wrap it into an iframe, if they don't feel comfortable with ajax.

Trevor Dixon · Accepted Answer · 2013-03-06 18:53:43Z

0

Using jQuery:

(function() {
    var updateAgain = arguments.callee;
    $.get('/url/to/script.php', function() {
        setTimeout(updateAgain, 5000);
    });
})();

The advantage of this over setInterval is that it won't start counting to five seconds until the request is finished; this is important if the request takes more than a second or two. It will also stop if a request fails (which may or may not be an advantage).

edited Mar 6, 2013 at 18:53

answered Mar 6, 2013 at 18:47

Trevor Dixon

24.6k13 gold badges77 silver badges114 bronze badges

Collectives™ on Stack Overflow

PHP Update using Javascript

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related