Public Art

Academic • Nov - Dec 2022

Team: Sooa Mo, Gabriela F.

0. Overview

Public Art is a web-based system that allows users to explore a public art database through filter-based search. This project focused on building full-stack functionality using PHP and phpMyAdmin while incorporating clean UI design and practical data interactions.

1. My Role

Back-End Developer · UI Contributor · Database Integration

I was responsible for building database interactions using PHP, including storing user registration data and enabling real-time profile edits. I also contributed to the overall interface design and page structure using Figma and Visual Studio.

2. Design Decision

To improve usability, we built a dual-filter system that allows users to search by Artwork Type and Artwork Neighbourhood. I implemented this using PHP to dynamically query the database based on selected criteria. I also designed the ER diagram to map out relationships between tables and ensure smooth data handling throughout the interface.

Fig.1: Initial wireframe sketch showing page layout

Fig. 2: ER diagram outlining the database structure

Fig. 3: Search page with filter options for type and neighbourhood

Fig. 4: Profile page allowing user info editing

3. Result

We successfully created a fully functional prototype that allows users to:

• Sign up and store profile information in the database
• Search artworks using two filters: Artwork Type and Artwork Neighbourhood
• Edit their profile with real-time updates reflected in the database These features demonstrated successful integration between the UI, database structure, and PHP-based backend logic.

4. Takeaway

This project helped me better understand the role of data in web development—how to organize, manage, and connect databases effectively. It also reinforced the importance of balancing front-end usability with back-end structure, allowing me to strengthen both my technical skills and my grasp of the overall development process.