Majic Dining was a mini-site of Majic 105.7, a radio station in Cleveland, Ohio.



They were running a contest which was getting up to 3500 visitors in the first ten minutes and the site was crashing. I was given the challenge, through Advoca Interactive of Toronto, to reprogram the contest using PHP and MySQL.

Every Friday morning between 9:00 a.m. and 9:30 a.m. the station featured a different restaurant and sold $50 gift certificates for $25 to the first 105 successful buyers.

When the number of certificates sold reached 105 the home page showed a "Sold Out" notice, replacing the "Buy Now" notice, and no more connections could be made to the database.

From the time the visitor opened the order-form page, they had five minutes to complete a successful order. That is, if they submited an incorrect credit card number or they left their computer, they could still submit or resubmit until the full five minutes allotted to them expired.

When the number of orders sold plus the number of orders on reserve, or being processed, totaled 105, a "We are temporarily processing orders. Please try again" notice replaced the "Buy Now" notice and no more connections could be made to the database and the order-form page was inaccessible. When the number of orders sold plus the number of orders on reserve, or being processed, again totaled less than 105, the "Buy Now" notice reappeared.

All orders were processed through Authorize Net.

The Majic Dining site is no longer online.

<< BACK    NEXT >>