PHP-MySQL Expert for Search Page Development

I'm seeking to create a modern, PHP-based search site that connects to a MySQL database. Key Features: - The site should have filtered search results. Auto-complete is a feature I'd like to consider. - The search results should be text-based, displaying relevant information from the connected database. - User interface should be modern and minimalist. The structure of the MySQL database is as follows: Title: Represents the title of the entry. Link: Contains the link associated with the entry. Year: Represents the year associated with the entry. Journal: A boolean field indicating whether the entry is a journal or not, distinguishing it from being just an electronic resource. Additionally, there are two sets of categories: The first set comprises 13 boolean fields. These can represent one or multiple categories within the record. The second set consists of 4 boolean fields representing chronological categories. When searching, you can input the title and select any relevant categories from the list to narrow down the search results. first do you want to search just journals or electronic resources, or both. then the Subject categories, all subjects or select one or a combination of subjects. You can also search without typing any text, and just search the whole database depending of what category you want. for example to search you can select journals, and subject Archaeology, without typing anything. the fields that it searches are Title and year in the freetext. The main results are the title, year, and bellow that we want to show the link (printed), and make a icon with hyperlink clickable. See the attachments to understand more including a csv with the fields, and image database. Ideal Candidate: - Proficient in PHP and MySQL. - Experience in creating advanced search systems. - An eye for modern and minimalist design