Hi,

Is there a possibility to use a php generated SQL query as input for a ARI data-table? I want to filter the data-table based on user input. For instance filter a column in a table based on a minimum numeric value provided by a user. I read some other topics on this forum on the same topic, but I couldn't get a solution for this problem.

Many thanks in advance.

Hello,

"ARI Data Tables" supports ability to use request variables in SQL query. For example you can embed "ARI Data Tables" module into an article and add the next HTML code to add filter (for example by "price" column in "products" table):



and use the next SQL query:



Regards,
ARI Soft

Great, thanks a lot!

This post is very helpful but I have been experiencing some problem with SQL code.
The html code I have written is:
<form method="post">College: <input type="text" name="collegeFilter" size="20" /> <br /><br /> <input type="submit" value="Search" /></form>
In my SQL code, I got a constraint like:
a.value LIKE '%{$REQUEST:collegeFilter}%'

But when I submit the input, there is a warning "array_flip() expects parameter 1 to be array;array_keys() expects parameter 1 to be array, null given in..."

I think the SQL code could be wrong. Could you please give me some hints? Thank you!

Do you show a table or a graph? Could you send screenshots of module settings page by email?

PS: Use CONCAT('%', {$REQUEST:collegeFilter}, '%') instead of '%{$REQUEST:collegeFilter}%'

Regards,
ARI Soft