Inspiration

Health care is important to everyone, especial those that needs them. However, many of us, including us have experienced very long waiting time (~5 hours) for small appointments. Sometimes they can be urgent. This creates frustration for the patients. We want to create a system that ease out the pain of waiting.

What it does

It is currently incomplete. Our idea consists of a API search box: patients can look up their information among many others including id, name, triage, number in-line, etc. Graphs: average waiting graph from collecting all of the past data. This will make an estimation on how long the patient will be expected to wait for. Request button: Patients can make a request to remind the doctor every 25min.

How we built it

We set up a php server and mySQL database. All of the patients that registered through the php form will be assigned to mySQL database. Then we can read and write data to the database and present it in a graphical way for the users.

Challenges we ran into

Setting up php server and connecting to mySQL is a bit complicated. Setting up a javascript API that can read from mySQL database have not been accomplished as the time of writing. Setting up javascript with html+php file has yet to be accomplished.

Accomplishments that we're proud of

Setting up a httpd server as well as a mySQL database for the first time from reading documentations and Youtube.

What we learned

It takes a lot of effort to set up both a front-end and back-end website, but it is doable. We just need to put a lot of effort into learning it and not give up when the problems are challenging. Sometimes it just takes a couple of google searches.

What's next for Patient Queuer

Finish setting up javascript and be able to read and write data to the database. Organize the data and present it graphically onto the website so the users can see: how many people are in front of them, how long on average is the waiting...etc.

Share this project:

Updates