Rotary RLI Site

This is the first site I ever got to work on in a real-world situation. As part of our work term for first year, me and fellow classmate Mitchell we assigned to this site. At first, we thought we were just supposed import a csv file to update the database inside. Then, after we first talked with our client the scope increased… a lot. The site was supposed to be a replacement for an old site section and make signing up for the Rotary RLI courses easier for both the 7820 and 7810 districts.

The entire site was developed in WordPress and we initially created everything that is shown on the site. Some of the things we did on the site included:

  • Creating a Sign Up/Login system for new users
  • Creating a Registration form that uses the user’s wordpress information as part of the database
  • Creating a page where users can purchase the courses provideds
  • Migrating the course description pages and the home page from the old site into the new site
  • Making documentation so the client will not be confused when operating the site

The hardest part of the site for me was inputting data into the database. When you put data into the database, it comes in two parts. The first part is when you sign up; the database will grab your first and last name and your email from your WordPress login. The second part is when you register for a course. In this part, the database grabs your district number, club and phone number (and let me tell you, the regex part of the database took a while to set up on it’s own).

Now the first part actually doesn’t go in when you create the account, it goes in when you submit your course registration. This was the tricky part, as we needed to learn a part of the database called hidden fields which allowed for dynamic data to go in. After we were able to figure this out, the old registration field quickly grew very short.

While this site works very well, something that could be added on for this project is the function that when a user completes a set of courses, the database enters the date automatically. Currently an admin would have to enter the date manually, so that would provide some ease of access for the admins.

Want to check out the site? Here’s the link -> rliatlanticdiv.org/

Want to check out Mitchell’s Portfolio? Here it is -> mitchfaber.ca