The ROM project

This project contains all the rounds-of-the-month (ROMs) for the Northern California Round Dance Teachers Association, starting from its inception in 1953, until the present time. There are approximately 1200 dances in the database. Every month, NCRDTA members select three to five new dances to add to their repertoire.

This project lets you add dances to the database one at a time or in a batch, and it also lets you search the database for dances of a specific year, name, rhythm, phase, choreographer, or record label.

This project has potential to help automate a real working web site whose database is not yet in MySQL.

Contents

  1. What is NCRDTA and what are ROMs
  2. Importing the data from text files into MySQL
  3. The various files and what they do
  4. Differences between my home server and the Ohlone College server
  5. How to perform the easy search
  6. How to perform the advanced search
  7. How to perform a tokenized search
  8. Escaping user input from form fields
  9. Using a page template in PERL for consistency
  10. Batch insert friendliness
  11. Editing existing records
  12. SVG Icons
  13. JavaScript for better UI
  14. Porting to another server