1

I am trying to use plotalot to graph user results. The program only uses mysql queries to pull data. How can I pull session specific user data with a mysql query? Normal Joomla session variables are not available to use. I've tried many versions of this, but session variables are not set?

SELECT Calcd_Results
FROM user_results
WHERE user_id = $_SESSION["user_id"] 
  • yes, @James actually just answered the question. The sub-answer would be: 'please read the documentation of the extension you use'. :) – Zollie Jan 12 at 9:09
  • 1
    since, exceptionally, Plotalot has a pretty impressive documentation (more than 70 pages). From page 63. (advance techniques) it gives great examples on advanced usage, incuding the example what @James just gave above. – Zollie Jan 12 at 10:27
  • Thank you @jamesgarrett and Zollie - I read through the first 50 pages but didn't get to 70 since this documentation gave lots of examples but very little about how the system actually works. I even searches some terms that didn't yield anything and reviewed the other 13 page developer guide. Seemed to reinforce the idea to me that it would not do the function I wanted. My bad. Thats why I asked. – BabyCode123 Jan 12 at 17:36
  • My apologies for there being two questions too. Thanks for the help. – BabyCode123 Jan 12 at 17:44
  • @BabyCode123 - no problem at all, it takes a good amount of time for anybody to get familiar with an extension like that. – Zollie Jan 12 at 19:52
2

Plotalot includes various variables that can be used in sql queries, eg.

%%J_USER_ID%%

is the currently logged in user_id. The Plotalot User Documentation Available as PDF here

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.