Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

PHP code as parameter for an SQL query
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: PHP code as parameter for an SQL query
#19417
PHP code as parameter for an SQL query 12 Years, 7 Months ago Karma: 0
Dear All,

thank you for the great extension, am using the Smart content set.
Currently have one problem and would appreciate your advice:
I need to filter my table (retrieved via the ari sql table from external ms sql server) by ids from the internal database, e.g.
Select * from #__users where id not in ($my-sqlfilter-here).
I have a working php code for the filter and have several options:
1. Adding the php code somewhere in the ari table, not sure if possible
2. Add the php code outside using jumi and have ari table filter by a variable, not sure how.
3. Add the whole php page with code and resultant table. This works but arijtable around the jumi code does not give ability to search/paging etc...

Thanks!

P.S. Is there any more documentation on the plugins, i.e. how to add column format to the article tags etc...
The administrator has disabled public write access.
 
#19446
Re:PHP code as parameter for an SQL query 12 Years, 7 Months ago Karma: 747
Hello,

You can use DirectPHP plugin to embed PHP code into an article.

Could you explain what you mean under "how to add column format to the article tags"?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#19450
Re:PHP code as parameter for an SQL query 12 Years, 7 Months ago Karma: 0
Thanks a lot!
I tried jumi to include my php file and it did not work, the ari datatable functions (search, sort, ect...).
Regarding the column format: There are a lot of discussion on how to add hyperlinks etc... in the module it can be done through the settings. The question is how to do it inside the article table, are there any tags for that and if so, where all these tags are documented.
fpu
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#19541
Re:PHP code as parameter for an SQL query 12 Years, 7 Months ago Karma: 747
If you want to format a value, use "Columns settings -> Format" parameter.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1