You can use request variables in WHERE clause of SQL query. For example you can create a HTML form outside the module where user will enter a search string, click "Search" button and then use data from the form in "WHERE" clause. For example use the following HTML form:
| Code: |
<form action="" method="post">
<input type="text" name="searchStr" />
<input type="submit" value="Search" />
</form>
|
and use the following SQL query:
| Code: |
SELECT
id,
title
FROM
#__content
WHERE
title LIKE CONCAT("%",{$REQUEST:searchStr|empty:''},"%")
|
Regards,
ARI Soft
