I have a very basic application written in Coldfusion that keeps track of a club roster. The task is to set up this functionality with PHP and MySQL.
If you have an alternative to PHP/MySQL which you feel is better, you may also make this recommendation. The final product will be running on a LAMP server.
PLEASE READ ENTIRE DETAILS BEFORE ASKING QUESTIONS! THANK YOU!
## Deliverables
I have a very basic application written in Coldfusion that keeps track of a club roster. It allows each club member to log in using a unique ID (their club ID number) and update their contact information. They can also view other club member's contact info. In addition, there is a master login for club officers to add/delete/modify all members and also generate a printable roster. They can also send a mass e-mail to all members.
Additionally, each member record has a "membership current through" field that lists a certain year. When a member is current, they are able to log in and do the above functions. If the member's "current through" field indicates the year is less than the current year, they should be presented with a "you need to renew" page and will not be able to proceed.
The task is to set up this functionality with PHP and MySQL. A copy of the existing .MDB will be provided with sample data. A script or instructions need to be provided so that we can populate the MySQL with the actual data from the current production MDB file. This will be done on our end because we can not release our club member's information to a third party.
If you have an alternative to PHP/MySQL which you feel is better, you may also make this recommendation. The final product will be running on a LAMP server.