create notification when user insert new order into database in php

Question

I recently developed a website for purchasing online. My problem is how I can create notification to alert at admin page when new order is inserted into MySQL. This notification will appear as an icon number at admin page on website, so that when admin open website they will know new order had made by customer.

I know we have to use javascript ajax but I have not idea how to begin.

I have some example code:

refreshInterval = 500
refreshTimeout = setTimeout(getNotificationCounts, refreshInterval);

function getNotifications() {
  $.ajax({
    url: 'path_to_your_php',
    type: 'POST',
    data: //put for example user_id but it cvan be handled by sesion as    
    dataType: 'json',
    success: function (data) {
      alert('You have' + data.total + ' new messages')
      refreshTimeout = setTimeout(getNotificationCounts, refreshInterval);
    }
  });
}

https://code.google.com/p/phpwebsocket/ You get an example from here — Shijin TR, May 13 '13 at 04:17

score 1 · Answer 1 · edited May 23 '17 at 11:43

There are two alternatives for your problem. What you are looking for is persistent http connection.

If you don't mind the browser support of your solution, you could use websockets. They are part of the html5 api but they are not supported by all the browsers and it's a new thing so there will be support on new versions only. Check here for more http://www.html5rocks.com/en/tutorials/websockets/basics/
The second alternative is long polling. The basic idea is that the client makes an ajax call to the server periodically but doesn't return immediately, it returns if the server has a response, or if a specific amount of time has been reached. You could do simple polling too, but it's not a good practice because you make a lot of calls to the server with no reason most of the time. The long polling technique is also known as comet technique. Look into that, and come back with some more focused questions.

How do I implement basic "Long Polling"?

Here you can find a basic example of what you want to do. It's detailed too.

If by example you mean code then take a look at the link I posted. — Alkis Kalogeris, May 13 '13 at 07:57

create notification when user insert new order into database in php

1 Answers1