Celebrity Photo Ops

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.

celebrityphotops.com home page

My Career Catapult

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.

Home Page

T-shirt Bordello Blog

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:

  1. support an interface at the convention for attendees to select their photo background, write a caption and add tags, and submit their email address;
  2. match up the photos with the background selection, caption and email in a database;
  3. for some conventions, use PHP graphic functions to add user-generated text to the image itself;
  4. 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.
T-Shirt Bordello Blog Home

Home page

blog posts

Posts tagged for one convention.

blog post with custom text

Posts with custom text

individual post