You have chosen to sponsor your bid up to a maximum amount of .
I need an enhanced version of the event registration form which can be viewed at www.calcapsummit.com/register_form.htm. This form is used to register attendees to monthly meetings. The meetings are free, so e-commerce is not a consideration.
There are about 1,000 persons on our membership list. They now have to type in all of the fields each time they register for a meeting.
We want to give members the ability to "sign in" using an identifier, such as their e-mail address. If they are in the MySQL database linked to the form, the remaining fields would then be pre-populated with their information.
If an individual is not in the database, entering the requested data fields and submitting the form would automatically result in them being added to the database. Subsequent registrations by that individual would be pre-populated. Typing revised information in an existing entry (a changed address, for example, or "Bob" instead of "Robert") would automatically cause the database to be updated.
We need the ability to upload the existing membership list (an Excel or CSV file) via an admin page, and the ability to download the list of members (CSV or XLS) who have registered for the monthly meeting. (Currently, a hidden field now adds a text field that identifies the meeting -- for example, "January 2010 meeting. We would need the ability to change that hidden field each month via the Admin page.)
Failure to enter required fields, or to agree to required terms, should generate an appropriate error message or page.
Successful completion of the form should generate a confirmation page. It should also result in copies of the individual registration being e-mailed to that attendee, and to the e-mail address of the site Admin. The registration should also be recorded in the MySQL database, so it can be exported with all other registrations for that meeting.
We also need the ability to "turn off" the registration form, possibly by just switching out the HTML page with a "Registration Is Now Closed" HTML page.
The website runs on Linux, with Apache 2.2.11, PHP 5.2.9 and MySQL 5.1.30.
To facilitate future maintenance, the PHP code must be amply documented with comments. We want to protect the privacy of the members' information, so please describe the approach you would take to security of the database.
This contract is governed by U.S. law, and this project is a "work for hire," meaning the copyright and all intellectual property rights will be owned by the buyer upon payment in full to the contractor.
This is NOT a rush job, but I would appreciate an estimate of the time needed.