We want to create a simple beta version of a registration and admin system in PHP/mySQL for a futbol league, including an admin backend. This will be the beta of a larger DB project (which may be awarded to the same coder). MySQL ais lready installed, but may need configuration.
The beta project requirements are as follows (*** please see example pages for more information: [login to view URL])
Two primary links:
[Public] [Admin]
[Public]
1/ Search database for existing player.?
If player found, click player to display:
A/ LASTNAME, FIRSTNAME
B/ TEAMNAME
C/ Registration Status?
Registration Status fields to be displayed (with X if completed, blank if not): BIRTHPROOF, FORM 1601, CONDUCT, PAID)
All fields with links to more information on each field (see screen shots example)
2/ Registration
Create a registration form with 4 fields. All fields are required
FIRSTNAME, LASTNAME, TEAM, AGEGROUP (radio button), EMAIL
When the user submits the registration form, an email is sent to their address to validate and complete the registration process.
ADMIN
Search database by LASTNAME
Search by TEAMNAME
View All Records
Modify recored, including Registrations Status
Sort function
Download into Excel
Install system and database in live site.
PROTOTYPE DUE 12/5/2009
FINAL DUE 12/7/2009