Easy way to get notifications using php, mysql and js

Question

I am doing a restaurant aplication using php, mysql and js but I have a little problem.

When a client order somthing (using a tablet) I need a notification appears in another terminal but using the "easy way".

table orders:

id  |   id_place   |  id_meal   |   id_waiter  |   status
1   |   3          |  20        |   4          |   0
2   |   4          |  17        |   4          |   0
3   |   2          |  13        |   2          |   0 
4   |   1          |  13        |   5          |   1  <-- All these are ordes

I am thinking to do update.php:

$que = mysql_query("SELECT id, id_waiter, status FROM ordes WHERE status = 0");
$notifi = mysql_fetch_array($que);

And I have all the orders in a standby state (status = 0) and Now I can show the results counting the rows for each waiter:

Waiter2 [1]   //waiter2 has 1 notification
Waiter4 [2]   //waiter4 has 2 notifications

But these results have to be constantly updated every 5 or 10 sec. How can I do that? I dont want to use jnode, sockets or semething like that.

koopajah · Accepted Answer · 2012-12-05 15:17:27Z

3

Use the method setTimeout() to call a function every X seconds that will refresh the list of orders in standby More info here : https://developer.mozilla.org/en-US/docs/DOM/window.setTimeout

If you don't want to reload the whole page you will have to use AJAX More info here : https://developer.mozilla.org/en/docs/AJAX

answered Dec 5, 2012 at 15:17

koopajah

26k9 gold badges87 silver badges113 bronze badges

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

Comments

webnoob · Accepted Answer · 2012-12-05 15:18:31Z

1

In a PHP page you could use a while loop and sleep at the bottom:

<?php

while (someCondition) {
    //Get Data and show.
    sleep(5);
}

?>

You can write something in to set someCondition to false to stop the process when you need to as well.

answered Dec 5, 2012 at 15:18

webnoob

16k13 gold badges87 silver badges169 bronze badges

Comments

Less · Accepted Answer · 2012-12-05 15:19:52Z

1

use ajax. in this case i used mootools.

var that = this;
var req = new Request.HTML({
        method: that.ajax.method,
        url: that.ajax.url,
        data: {'action' : 'update', 'waiterID': x},
        onRequest: function(){ /* do something */},
        onComplete: function(){ /* do something */}
        }).send();

answered Dec 5, 2012 at 15:19

Less

1164 bronze badges

Collectives™ on Stack Overflow

Easy way to get notifications using php, mysql and js

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related