ChipiChipiChapa, the perfect solution for finding the best deals on Best Buy products. Users can browse from a large database of products and view their price history.
Upon account creation users can also comment and add products to a tracked list. With moderation in mind, a whole admin tool suite was developed as well. Administrators can moderate user accounts and comments as well as view site metrics. The website was developed using the Bootstrap framework for the frontend with PHP and JavaScript for the backend.
Pages served data from a realtime data base where the information was updated on the site asyncrounously using AJAX. This page uses SQL along with Chart.js and AJAX to display graphs and data about the given product.
This page showcases all the products that were queried using SQL via the Search bar on every page in the web-app. On this page, you can also filter the search with a modal that pops up when you click the Filter button next to the Search bar. The code looks for the selected dropdown menu items (Category, Subcategory, & Items per Page) and modifies the SQL query for searching the products appropriately.
Features List:
-Search for Products
-Product tracking
-Visual display of updates, etc (site usage charts, etc)
-Activity by date
-Collapsible items without page reloading
-Alerts on page changes
-Admin view reports on usage (with filtering)
-Styling flourishes
-Responsive layout for mobile
-Tracking comment history from a user’s perspective
-Known Limitations:
-Database is not continuously updated by use of API
-Screen readers struggle with some aspects such as the graphs
-Only accepts .PNG or .JPEG as profile pictures.
-Password encryption could be stronger, it is only protected with the bcrypt hashing system at the moment