This plugin enables search of external MySQL database within Joomla. You are able to integrate content from other systems into your Joomla search.
How it works.
This plugin is integrated with internal search engine built in Joomla. Every time you use search option on your Joomla based site it will search all your standard joomla content and it will search within external database you set in configuration of our plugin. The search results are displayed within Joomla search exactly in the same way as any other search results.
Installation.
Download Custom SQL Search from our download section. Log in to your admin panel, go to Extension -> Install/Uninstall, use Upload package file option to upload and click install.
Configuration.
Log in to your admin panel, go to Extensions -> Plugin Manager and click on "Search - Custom SQL" plugin. A newpage will open with the configuration options. You need to fill in all the fields displayed and click Save button.
Settings.
List of fields to configure:
- Search Limit - number of maximum results that the search will return from your database.
- Plugin label - label that appears when you select where to search in the search engine of Joomla.
- SQL Hostname - hostname of your SQL server. Can be localhost or any remote host.
- SQL Username - user name you use to connect to your SQL server.
- SQL Password - password used to connect to your SQL server.
- SQL Database - name of database you want to search.
- SQL Table - table name you want to search.
- SQL Column - column name used by search query to look for results.
