I am creating a webpage where the users should be able to search and find papers. Before reading this you should keep in mind that I do not have any background with coding.
So, my problems are mostly related to the coding of the search bar. I have created a database which looks like this (this picture shows just a test):
Furthermore, I have created a dynamic page with a repeater that looks like this:
The future users of this webpage would most likely like to search for papers by entering keywords to the search bar. Until now I have only managed to make a code that lets them type in one keyword, e.g. "gas". As soon as you type e.g. "gas" and "future", the repeater turns out empty. The search bar is also limited to searching for a word in the title, meaning that they can't search for both the author's name and the title.
The code looks like this:
My questions are:
1. What do I need to add to the code in order to enable searching for more than just one word in the title? I want my users to be able to type in e.g. "gas future" and then be shown the article named "The future of gas".
2. If it is not too tricky, what can I add to the code to let my users search for both the author and the title of the paper?
Hope these questions make sense! I am happy for all answers.