Clearly describe your idea. What problem are you trying to solve/how will it add value? Who are your users?
I wanted a place that documents the languages that different shows and movies are subtitled in. I was tired of going into a show, intending to use Arabic subtitles and English audio to help me understand conversational Arabic more, only to find that the show/movie only has subtitles in Spanish or English. I couldn't find any websites listing what shows/movies has subtitles in what languages, so I decided to make one.
This website is for anyone who may want subtitles for language learning purposes or anyone who may need subtitles in languages other than English for any number of reasons.
Explain your technical stack and why you used it
I used MySQL, PHP, HTML, and CSS to build my website. I wanted to challenge myself to use PHP and MySQL in a project since I've been learning it in my courses. As a web and mobile computing major, I figured that it would be especially useful for me to get more experience in those languages since a good amount of web development-based jobs seem to use them.
Challenges
I essentially had to relearn PHP and MySQL for this project. I realized a few hours in that I didn't understand nearly as much about PHP and MySQL as I thought I did. Even after referencing my class notes, I struggled to adapt the stuff to my needs for the project. So, I ended up needing to open dozens of tabs of documentation and examples of stuff to learn the syntax and mechanics of PHP and MySQL well enough to use it flexibly. For a few hours, it was just this: check documentation->make slight change in file->refresh web page->is the error gone? (it was usually not) ->check documentation again or google the error-> repeat. I really wanted to avoid using Angular and Typescript for this since I hardly have any experience with them, so my method of doing this was probably inefficient.
A small challenge was deciding the design of the website. Initially, I had big plans to make it look really cool with lots of Javascript, but by the time the functionality was totally done, I was too tired and creatively drained to try and experiment with Javascript for a few hours. I mostly like the color scheme I ultimately went with, though.
Accomplishments that we're proud of
I'm proud that I actually made this and that it works as intended! I expected to get it only halfway working, but I actually finished it and even accounted for some edge cases!! I also really like how I was able to pull off the subtitle aesthetic on the About and Add to Database pages with the white text on black background thing.
If you had more time, what enhancements would you add?
I would add more Javascript to make the page more animated and fun. I would also add the ability to filter search results as well as the ability to filter contents by language. I would add way more shows.
Log in or sign up for Devpost to join the conversation.