// media cataloging · client project
PowerMedia Organizer
PowerMedia Organizer is a PHP/MySQL system built for a client to catalog a large CD/DVD library, turning entries into printable catalogs and disc labels.
PHP5.x
JavaScript
HTML5
CSS3
MySQL4.x2006
Screenshots
Overview
PowerMedia Organizer is a catalog and print-production system built in PHP and MySQL for a client managing a large physical CD/DVD library. It handles the full lifecycle of a media catalog: registering titles with front and back cover art, grouping them under configurable media types, and browsing/searching the collection through a paginated, sortable list or icon grid.
The core business problem it solved was production overhead: generating printed catalogs and disc labels by hand for a large, growing collection. PowerMedia replaced that with a configurable print pipeline — page layout, cover dimensions, font sizes, and items-per-page are all adjustable — so catalogs and labels could be regenerated on demand instead of rebuilt manually each time. A dedicated cover-printing workflow let staff batch-select which covers go to print, and a "gravação" (burn queue) screen tracked which titles were queued to be recorded to disc. A dynamic image-resizing endpoint served each cover at whatever size a screen needed from a single stored file, and a Flash-based viewer let staff inspect cover art closely before printing.
Highlights
Searchable media catalog
a full CRUD system for titles, media types, and cover art that replaced manual tracking of a large physical media library (980+ titles in the sample data) with a searchable, sortable, paginated database
Configurable print pipeline
a catalog-and-label print system with custom page sizes, cover dimensions, font sizes, and items-per-row, turning a recurring manual production task into a few-click, repeatable workflow
One-image cover rendering
a dynamic image-resizing endpoint plus a cover zoom viewer, so a single stored cover per title renders correctly across thumbnails, print layouts, and detail views, cutting storage overhead and manual image prep