Custom search box query for homepage

by Shotts Tech   Last Updated August 01, 2020 12:10 PM

I'm really new to Joomla and I have some basic experience with HTML/PHP and mySQL

I have a seperate DB in mySQL which has only 1 table & 3 fields to be populated, this part I've already setup and filled with information. What I can't figure out is how to get a searchbox to appear on the homepage of my joomla site that is only for searching this DB and not the whole website (which I don't require)

If anyone is able to give me some guidance that would be really appreciated.

The idea is a user would search for a code which is populated in my "SearchCode" column of the table and then I need the response to come back with everything from the 3 columns for the row that contains that code (I appreciate that's probably pretty obvious but I want to be clear)

I don't need anything fancy, I can figure a lot of myself once I know the basics of how to get the search box into the main page.

Related Questions

Smart Search URL and Layout

Updated February 21, 2018 13:10 PM

My own search plugin security

Updated December 08, 2017 20:10 PM