Home News Contact Us Forum About Us Demos Products F.A.Q.
ARI Soft









Register   Lost Password?
Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin







e-mail: info@ari-soft.com
Shopping Cart
You currently have 0 items in your cart.
Show 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.
    more...

  • 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.
    more...


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?
ARI Soft Forum
Joomla components
ARI Data Tables

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 8 Years, 1 Month 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?
ecrespy
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#57104
Re:Using $SESSION vars in Where clause 8 Years, 1 Month ago Karma: 747
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
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#57118
Re:Using $SESSION vars in Where clause 8 Years, 1 Month 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'
ecrespy
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#57120
Re:Using $SESSION vars in Where clause 8 Years, 1 Month ago Karma: 747
Where "article_id" session variable is set? It seems this is an empty or has an incorrect value.

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#57122
Re:Using $SESSION vars in Where clause 8 Years, 1 Month 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?
ecrespy
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#57123
Re:Using $SESSION vars in Where clause 8 Years, 1 Month ago Karma: 747
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
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12
ARI Soft Forum
Joomla components
ARI Data Tables
Powered by Kunenaget the latest posts directly to your desktop
Useful Links
Products
F.A.Q.
Discount
RSS
Top Products
ARI Data Tables
ARI Sexy Lightbox
ARI Quiz
ARI Stream Quiz - Personal
ARI Smart Content
Help
Forum
F.A.Q.
Home | News | Contact Us | Forum | About Us | Demos | Products | F.A.Q.
ARI Soft
License | Terms and Conditions | Copyright Info | Privacy Policy
 
ARI Soft
Copyright © 2009