celebrityphotoops.com extends Don Myers’ earlier tshirtbordelloblog.com project by supporting the purchase of photos with celebrities at conventions.
And for this project, Don provided pre-purchased, edited and printed photos on-site, in addition to password-protected downloads of high-resolution images.
The back end for this site included many of the features of the earlier T-shirt Bordello Blog site for cataloging and loading images into WordPress.
In addition, this on-site web application matches purchaser’s tickets with their finished image files in real time, using a sign-in form connected to a bar-code reader and a database connecting the purchased-ticket number with both draft and final, edited images.
This project is currently on hiatus – it really requires a large convention to be cost–effective.
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.
Don Myers, owner of tshirtbordello.com, is also a graphic designer and photographer. He regularly attends horror, Sci-fi and fantasy conventions to promote his t-shirts.
One of Don’s many marketing ideas was to offer free green-screen photos of fans in costume with captions on a blog site.
In addition to attracting on-site attention for his t-shirts, Don’s goal was SEO through a blog site with a regular supply of new, original content and a large number of links from fans.
And it worked, until a change in Google’s algorithms lowered its ranking.
I wrote the back-end PHP and MySQL for tshirtbordelloblog.com for Don to perform 4 major functions:
- support an interface at the convention for attendees to select their photo background, write a caption and add tags, and submit their email address;
- match up the photos with the background selection, caption and email in a database;
- for some conventions, use PHP graphic functions to add user-generated text to the image itself;
- after each convention, and after Don cleaned up any green-screen glitches, pull all of that content into the WordPress blog database, one post per photo, with tags, in a single PHP batch job.
Posts tagged for one convention.
Posts with custom text