Inspiration

Due to social distancing measures put in place, it is not uncommon to wait long periods of time to enter stores. This puts people at a greater risk of getting infected by COVID-19 and places a burden on older populations. This made us think about a method to improve convenience by allowing people to view the wait time to enter a store.

What it does

ShoppingQ relies on stores to keep track of the customers waiting in line using a user-friendly web application. Customers can use the web application to search for a store and the application provides the average wait time to enter the store.

How we built it

We created a web application using javascript, HTML, and CSS which is connected to a MYSQL database using PHP. The database stores the unique address, name of the company, and current line length. The company can update the line length and the user can query the database to learn about the current waiting time.

Challenges we ran into

  • Learning PHP and MYSQL to connect a database to the web application -Finding an application that allows our local server to be hosted online -Developing a user login system for administrator access for stores ## Accomplishments that I'm proud of
  • First Hackathon
  • Learned two new languages ## What I learned
  • PHP + MYSQL
  • Difficulties in building user-friendly web applications ## What's next for ShoppingQ
  • Improve the accuracy of the average wait times by using machine learning algorithms
  • Move from local server to an online server
  • Google Map API connectivity
  • Implement federated identity
Share this project:

Updates