Creating a search bar to search in an SQL database

Hi! For a school project (creating an Website, which is connected to an database) I want to add an search bar, which search in my database for Songs I added. The difficulty (at lease for me ^^) is to code it like an search bar on youtube or spotify. So I want it to show top search results and update them if the user is typing more letters. Unfortunately my teacher can't help me on this topic and I didn't find any forum which answer this question (most are for online search bars and I only want to search in my database) I already read you can use JavaScript for that but I am not a pro in this. One more difficulty: We are supposed to only use JavaScript, HTML, CSS and Python for this. (And of course SQL) . Additionally we should use an CGI server and pymysql. If something is unclear, just ask 🙂 Hopefully you can help me! CU