On my server I have a SQL database with scientific articles. The fields are publication number, date, article title, author and keywords.
I need a way for the user to do a search based on any or all fields and get the title or titles of the articles that meet the search criteria. By clicking on the title the full text is displayed.
I wonder what is the best way to achieve this, and if there is a stack or widget appropriate for such purpose.
I hope that makes sense. Sorry for my English.
Many thanks in advance