This full stack project on film database was built as part of my school assignment for the front end web development in SP. The project consists of a backend to perform queries on the film information that is stored in the MySQL database, and a front end for users to interact with. This is not only my first full stack web development project, but also my first ever web development project to be done with a JavaScript framework, and that is React.

In the image above, you can search for the film based on the name, maximum price, and or the film category. Once you click on the search button, it will send the query to the backend to perform an SQL query based on the filter set. The return result will look like the following image:

And if you click on one of the result, you can see the full detail in the following image:

Additionally, the website was made to allow admin user to login and perform additionally queries that regular users are not allowed to, such as adding of new actors for the film, and deleting existing actors. Here is the image for the webpage for admin to manage the actor database:

The github code for this project can be found here.