A Simple Web Based Registration System for an upcoming event in my college.. Uses PHP/MySQL/AJAX and can be easily coded up by an programmer who is well versed with these technologies..
## Deliverables
Web Based Registration Software
**Database Structure :**
Primary Student Tables :
*ID(auto increment), Name, Mobile, College ID*
College Table :
*CID, College Name, Contact Person, Contact No., Contact Email*
Event Tables :
*PID(auto increment), ID1, ID2, ID3, College ID*
where PID is participant ID and ID1, ID2 are the student ID from the Student Tables..
**Report Generation** :
Eventwise participant list
Collegewise Participant List
**Saliant Features**
* *Uses AJAX*
For eg. go to the event page and select college from drop down menu.. Automatically the Dropdowns for the participants are autofilled with the participating students from that particular college.
<!-- -->
* *Special Registration page for event for Host college*
Direct names and Mobile number are to be entered for each participant and the Student Table and Event table are updated accordingly.
<!-- -->
* *Data entry pages*
Pages to enter details of participating college into the College table, and also to add data in the Student table in bulk(max 10 at a time, can be less) after selecting College Name from a Dropdown menu..
<!-- -->
* *Lock Down*
Registrations for events should be able to be closed individually whenever required.
<!-- -->
* *Should be easy to customize*
Connections to the database should be in a simpe seperate php file and also the event pages should be easy to replicate to have any number of form fields.
<!-- -->
* *Admin Area*
An admin area (*needen't be password protected because we will use apache authentication using .htaccess*) that provides access to the data reports and Lock Down options...
Please feel free to ask any questions that you might have...