This is a contest entry form. User will enter the following fields
Daytime phone (required)
ZIP code (required)
Code number: "If you received a postcard from KSFO, enter the code number from the postcard here for your chance to win an iPhone"
We will not allow duplicate email entries, or dulicate code numbers.
Email,phone, and zip fields should be validated for correct formatting, with simple error messages if invalid. Required fields should also generate error message if not present.
This needs to be a "sticky form" (values that were previously displayed will be set as the default value if an error is encountered).
Code number must be within a specificied range (can be set in config file)
If code number is within specified range, and age is 18 or older, and five digit zip code zip code begins with 94 or 95 we increment an "entries" count in database. When that entries count hits a specified count, we pick a winner. Winning entry must meet the previous conditions.
So, for example, the 156th person who enters the contest and submits a code number between 10000 and 99000, is a winner.
We need to record that identity of that winner, and generate a "You won an iPhone" message. Everyone else gets a generic "Thanks for entering" message. I will provide these messages.
This project is a rush job, and must be complete and fully tested by 10am Pacific time, Friday November 23. I expect bids will be higher than usual, becuase of the rush.
I will be available for questions until 1pm Pacific time Thursday November 22.
Deliverable includes php script(s) and a file to create mysql database, with installation instructions
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
mysql, php, apache
must run on all recent browsers.
Here is info about php and mysql versions
[url removed, login to view]