Hi! I am new to PHP and am trying to build a library management website that will return the results of querying a mySQL database for a search query entered by the user. For instance, the user may wish to search for items in the library by title, author, subject, publisher, etc., in a certain language, i.e. English. The user then clicks a button that says "Search", and the results appear below the search input box.
The results of the query must be printed out in a table that has columns in the following sequence: Subtitle and Title, Author, Subject, Publisher, Item ID#, and Status(checked in, checked out, or on hold).
The database has columns for title, subtitle, author_first_name, author_middle_name, author_last_name, subject, publisher, ID_number, and status.
Can someone please help me with the syntax for
1) querying the mySQL database based on the input parameters
2) dynamically creating the table that shows the query results based on the search parameters (I can fit all the results on the page.)