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


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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?

Using $SESSION vars in Where clause
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Using $SESSION vars in Where clause
#57099
Using $SESSION vars in Where clause 1 Year, 7 Months ago Karma: 0
Hi,
A while ago there was this thread

www.ari-soft.com/ARI-Data-Tables/56238-Use-$SESSION-instead-of-$REQUEST-variables.html

I can't seem to get this working. I am using your base case code on this page

njsaltfish.com/index.php/8-reports/9120-2016-02-28_Adam_Bomb_Cape_May.html


And I am not getting any results.

Any ideas? How can I go about debugging this?
The administrator has disabled public write access.
 
#57104
Re:Using $SESSION vars in Where clause 1 Year, 7 Months ago Karma: 666
Hello,

What SQL query do you use? Where SESSION variable(s) are set? What version of "ARI Data Table" do you use?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#57118
Re:Using $SESSION vars in Where clause 1 Year, 7 Months ago Karma: 0
The sql is this;

SELECT
id,
title
FROM
jrep_content
WHERE
id = {$SESSION:article_id|empty:''}



I am using version 1.15.6 of Data Table'
The administrator has disabled public write access.
 
#57120
Re:Using $SESSION vars in Where clause 1 Year, 7 Months ago Karma: 666
Where "article_id" session variable is set? It seems this is an empty or has an incorrect value.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#57122
Re:Using $SESSION vars in Where clause 1 Year, 7 Months ago Karma: 0
Ok, I think I mis-understood. I thought that Joomla automatically set the SESSION var for the article. I think you are saying I need to do that first....

I will dump out the SESSION to see what is set.
What is easiest way to put the Article ID in the SESSION in Joomla?
The administrator has disabled public write access.
 
#57123
Re:Using $SESSION vars in Where clause 1 Year, 7 Months ago Karma: 666
If you want to use ID of currently opened article, try to use {$REQUEST:id} variable in the query otherwise it is possible to create a custom Joomla! plugin which will set session variable(s).

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