An ultra-hipster music store
Allegro is an awesome, cool, futuristic, innovative, revolutionary, ultimate, music purchasing experience.
- Customers register and log in to browse, search, add items to a basket, and place orders
- Features for managers and in-store cashiers
- XHR for forms for immediate in-page validation and feedback
- Massive pictures of Justin Bieber
- Overall mark: 100% + bonus

Ultra-Hipster Interface (UHI)
Today's One Direction and Justin Bieber fans cannot settle for just another “user-friendly” interface. They need the ultimate in ultra-hipster design.
Our UHI features 33% more whitespace and 15% larger font sizes than the nearest competitor. Plus, pure CSS animation, throbbers, and translucent overlays.

LiveSearch
Take advantage of AJAX and powerful SQL aggregation and set intersection and union features. In other words, you can search the store by any combination of album name, artist name, song name, or category. All at once, as you type into the search bar. Or if you prefer, you can explicitly specify any combination of these attributes.

Manager
Managers get to add new items, update existing ones, and view sales reports for top sellers and for all the items sold in any given day.

Clerk
Allegro features a system for in-store cashiers to process purchases and returns. Purchases can be made with cash or by credit card.
Try it here
NOTE:
My web host doesn’t have mysqlnd nor PHP 5.4, so this doesn’t really work at the moment.
Database-powered system for music store
For CPSC 304 (Introduction to Relational Databases)
2013
Collaborators
-
Calvin Chan
- Item adding and reports for managers
-
Henry Chee
- Planning, foundation, register/login, customer basket and search
-
Billy Lin
- Interface design, LiveSearch, manager features
-
Carolyn Shen
- Item adding for managers, clerk features
Languages and Technologies
- PHP / MySQL database
- HTML / CSS, JavaScript, XMLHTTPRequest