Name: Titilay Emmanuel
Project URL: https://emmanuel.csp-server-class.org
Who: Emerging music artists, producers, and creatives who want access to events that help them grow.
What: A simple event-registration website where creators can browse upcoming sessions and register for the ones they care about.
When: Anytime — the site is meant to be active year-round as new events get added.
Where: Online, hosted on my web server for this CSC235 project.
Why: To practice real server-side development skills while building something that genuinely lines up with my interests in music and tech project management.
Below is the base layout that all pages will follow.
This is the initial relational database structure for VibeConnect.
For Week 3, I built out the physical database on my Hostinger server using createDatabase.php. This script connects to mySQL, drops the old tables, recreates the 3 required tables, and inserts sample records that match my original ERD.
Tables created:
Data types used: INT, VARCHAR, BOOLEAN, DATE
You can rebuild the database here:
The home page also displays a live preview of the table data as generated during Week 3.
For Week 4, I created a fully interactive event-registration form that allows users to join upcoming VibeConnect sessions. The form uses drop-down lists, radio buttons, checkboxes, email input, date input, and follows all naming conventions (txt, lst, opt, chk, btn). The form submits data to the database and writes into attendee and registration tables.
This week I added secure PHP database operations and implemented my first stored procedure. All SQL statements now use prepared statements, and I added examples of htmlentities(), mysqli_real_escape_string(), and urlencode()/urldecode().
A screenshot showing the stored procedure inside phpMyAdmin is included on the stored procedure demo page.