How can I create a search engine in a blog which glean informations from a database?

I code in the free-time as an hobby and I would really like to create a website with a specific content. Since I work in the museums and art-galleries, I have noticed that many people in my field have problems to understand some topics related to documentation-ontologies (classes, subclasses, properties related to the art-objects). I would like to open a blog with a search engine inside. The search engine should give results back (as texts and images of diagrams, which I would prepare), in order to make the concepts textually and graphically more clear: to make it simple, a kind of dictionary which gleans informations from a database where texts,jpgs and pdfs would be stored. I would know without many problem how to create the blog or a not too pretentious (to use an euphemism...) website with HTML, CSS and JS but I don´t really know how to connect the database to the search engine. Could you please give me some suggestion about it? I have read much about SQLite, PHP but the mass of informations is overwhelming, above all for a not-IT specialist like me. I can use T-SQL and MySQL but I have no idea which programming language would be better in this case and how to connect the tables to the website.

Thank you very much in advance