Ok. I have redone all my work and simplified the code. I am using the following for the search form in an Article:
<form action="" method="post"> <input name="searchStr" type="text" />
<input type="submit" value="Search" /></form>
<p>{arimodule id="89"}{/arimodule}</p>
searchStr is my variable that is posted to the $_POST array.
In my MySQL query I have the following:
SELECT Addr1 FROM Address_Tbl WHERE ({$REQUEST:searchStr|empty:''} = '' OR Addr1 LIKE CONCAT('%', {$REQUEST:searchStr|empty:''}, '%'))
This was taken from the Ari Smart Content User's Manual. I have also turned on Server Side Pagination. I have also tried removing white space and used double quotes, but none of those changes result in the desired response.
When I initially navigate to my Article the entire table is displayed without prompting. When I enter a search criteria into the search box, it still pulls all records from the database table.
When I turn off Server Side Pagination, I receive an HTTP 500 Error.
I have built a PHP webpage outside of Joomla to determine if I am actually loading the searchStr variable in the $_POST array and I have validated that this is working correctly. I can also retrieve the searchStr variable using $_REQUEST['searchStr']. It would seem that my configuration on the webserver is correct and both POST and REQUEST are functioning, but for some reason I am not able to retrieve the variable through the Ari Smart Content module in Joomla. I have the following web environment for Joomla:
PHP Built On Linux s10 4.1.13-100.fc21.i686+PAE #1 SMP Tue Nov 10 13:30:58 UTC 2015 i686
Database Version 5.5.5-10.0.21-MariaDB
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.15
Web Server Apache/2.4.16 (Fedora) PHP/5.6.15
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.6.2 Stable [ Noether ] 4-August-2016 23:41 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.79 Safari/537.36 Edge/14.14393
The database I am retrieving the data from is external to the Joomla environment on another machine that is running CentOS7, Percona XtraDB Cluster/MySql MySQL.
Any other thoughts on this?
Thank you.
