PHP - Poll MYSQL DB for new orders and display

In Progress

We require a webpage to be written (preferably in PHP) which will poll an existing MYSQL database (about every 15 seconds) and display an ‘alert’ to the webpage when a specified record changes. This page is to form part of a back end interface for an existing online ordering system.

In brief ... the intent of the ‘alert’ is to notify the user that a ‘new product order’ has been placed and to prompt the user as to whether they wish to ‘Accept’ or ‘Reject’ the order.

If accepted, the order is to be displayed on screen and a value is written to the database indicating the order has been accepted.

If the order is not accepted within a period of time (60 seconds) the alert should disappear and a status of ‘not accepted’ written back to the database.

Note that the FULL process to be coded is outlined in the attached flowchart. The above is an overview only.

Additional notes:

1. We expect that all work will be of a high quality !

2. This is an extension to an existing website and the database containing the store details, ‘logins’ and ‘order’ already exist.

3. This development work is about coding of the full process outlined in the attached flowchart and does not require design of graphics or specific formatting.

4. The items outlined in green in the attached flowchart have already been created and do not need to be coded.

5. The website will predominantly be accessed via an iPad or iPhone therefore any functionality must work on such a device.

There are another two components potentially needing work. Work to a high standard here would likely attract additional additional work, though is not guarenteed.

Happy to answer any questions or clarify expectations.

Thank you in advance for your time.

Daniel & team.

Skills: AJAX, MySQL, PHP

See more: website development process flowchart, thank you notes, product development brief, product design and development process, php components, new website development process, new product development process, new product development brief, new product design and development, new product brief, Mysql questions, mysql db, flowchart or, design intent, coding php online, php poll mysql, php poll, online mysql database, new team, green screen online, php full form, need for product design and development, development design of a specific product, design new product, webpage php

Project ID: #902115

Awarded to:


I can easily do this for you. Sent you a PM.

$150 AUD in 1 day
(1 Review)

12 freelancers are bidding on average $244 for this job


pls chk pmb

$250 AUD in 3 days
(613 Reviews)

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$240 AUD in 10 days
(255 Reviews)

we can build this system using your existing database.

$250 AUD in 5 days
(124 Reviews)

Please check PMB

$300 AUD in 5 days
(33 Reviews)

Ready to start. Please view my PMB for more details.

$235 AUD in 20 days
(9 Reviews)

We are interested to work with you. We have necessary experience for this project. We have highly experienced team for this project. Please check INBOX for more details.

$250 AUD in 12 days
(17 Reviews)

I could help you.

$300 AUD in 8 days
(16 Reviews)

Hi, how are you? Please, see PM.

$250 AUD in 0 days
(37 Reviews)

we can do your requirements if given an opportunity. thanks Sara

$200 AUD in 10 days
(0 Reviews)

Please check your inbox.

$300 AUD in 10 days
(0 Reviews)

SIR, I read your project description. I am sure that i can do this project.Plz check your PMB.

$350 AUD in 14 days
(0 Reviews)

i can do it for you.

$150 AUD in 3 days
(0 Reviews)