Using MVC model,

in php write:

Authenticated users have access to the product search page. The product search page has the following heading, your-logins Product Search Page. It should include a text field for a customer to type in a search term, and a button labelled search. The term is used to search the product field of the Stock table. The items found by the search should be returned in a table with the title, your-login suggests the following: The HTML table should include the following fields from the Stock SQL table: product, price and Id. Only the matches that are in stock, no > 0, should be included in the results