Full-Stack Web Developer and UI/UX Designer.

PHP, MySQL, MariaDB, Bootstrap, CSS

To develop a a web application using PHP that interfaces with a database through MySQL to fetch dynamic content and display it to the user in a catalogue-like UI configuration. The web application will have filters that filters the queried content, search functionality, as well as embedded related content such as Youtube videos. The application will also have a backend content management panel that is accessible by the appropriate users.

Since the project heavily uses a database, the first step in development is to setup the necessary PHP code and MySQLi queries to fetch the content. Due to the filtering requirement, the query strings also need to be dynamic and receive the selected filters as options.

The Frontend was developed with Bootstrap and CSS. The videos was embedded by using Youtube’s provided embed links. The details of each item was shown through a modal for better UX.

The database contents was manually data entried through the backend admin panel that was also developed.

The project has significantly boosted my understanding of and working with databases. The amount and variations of the types of queries needed to accomplish the tasks has made me confident in my abilities in working with not just MySQL, but SQL languages in generals.

The filtering and searching requirement of the project has also deepened my understanding of PHP and how to integrate it with frameworks such as Bootstrap.