Managing courses and providing a registration System

The registration system should offer a specified number of courses and a limited number of possible registrations. The system has to ensure that no further registrations are possible if the places are limited. It should be possible to integrate the system into an existing website, including adaptions concerning layout and design. The registration process is limited to a specific time and registered users should be able to change their registrations. The users should be able to log on and view as well as change their current registrations. The backend should provide facilities to add and remove users and should offer registration lists which could be used to check attendance. In addition, collected e-mail addresses could be used to inform audience on time or location change. The technology used should be widespread and easy to use. It should be used for a Website for company fairs (www.discovery.jku.at) and is therefore used only occasionally. It is of major importance that the system is easy to use and to maintain because the organizing team of the fair and also the maintaining team of the website change a lot. The existing infrastructure is an Apache server and a mysql database which ideally should be used for this project as well. Nevertheless, other open source technologies could be integrated.
1 answer

A simple course registration system based on PHP/Mysql

I evaluated a lot of different open-source course registration systems available on the internet. Unfortunately, most of these systems offer a lot of functionality, but are not very easy to use and integrate. The aim was to keep the maintaince and integration effort low, so I decided to program a solution on my own.

The solution uses the layout used by the webpage (www.discovery.jku.at), and it consists of a few php scripts, which use the existing mysql database (separate tables are used to store the data). Users can register using their name and email address for one or more courses. Registration details can be changed later using a link provided per email. The Number of participants to some courses can be limited; registration works on a first come first served basis.

Although I usually prefer to use existing solutions, this would have taken a lot of effort to integrate and maintain an existing system. In addition, existing solutions provide lots of functionality I did not need in this specific case (e.g. ticketing, payment, ...). Therefore, a small own solution (loc < 500) was the best way.

Taggings: