My Career Catapult, mycareercatapult.com, supports a one-on-one job-search training program. The overall site design and home page were developed by Joey Marchy when he was with Wingard. I was brought in to work directly with the site owner to design the database and complete the back-end development.
The back end I wrote supports training-plan purchase and upgrades,extensive user input for training exercises and email communication between the trainer and students.
I used jQuery and Ajax to support sign-up and purchasing and for validating and submitting user content.
Since most of the user-generated content is text responses to questionnaires, retrieved only for user updates and for coaching, not searched or indexed for other purposes, it is stored in a single data table in JSON. Other data tables store user details, course details, and user-course data including payment records.
Wingard’s original project scope did not include any administrative functions. After a trial period in which I assisted with occasional admin. adjustments, the site owner and I determined that we could manage most admin functions from a single, interactive table of combined user data and user-course data. I added that table using the jqGrid jQuery plugin.
My Career Catapult was recently sold to a new owner.