hello, I'm trying to create a chart from mysql database using google charts extension (paid), but not really, is it possible to use date parameters from datapicker and combobox in where condition (mysql filter)?
marcin
Filter data on google charts extension
Forum rules
IMPORTANT NOTE!!
DO YOU HAVE A QUESTION OR PROBLEM AND WANT QUICK HELP?
THEN PLEASE SHARE A "DEMO" PROJECT.
PLEASE READ THE FORUM RULES BEFORE YOU POST:
http://www.wysiwygwebbuilder.com/forum/viewtopic.php?f=12&t=1901
MUST READ:
http://www.wysiwygwebbuilder.com/getting_started.html
WYSIWYG Web Builder FAQ
IMPORTANT NOTE!!
DO YOU HAVE A QUESTION OR PROBLEM AND WANT QUICK HELP?
THEN PLEASE SHARE A "DEMO" PROJECT.
PLEASE READ THE FORUM RULES BEFORE YOU POST:
http://www.wysiwygwebbuilder.com/forum/viewtopic.php?f=12&t=1901
MUST READ:
http://www.wysiwygwebbuilder.com/getting_started.html
WYSIWYG Web Builder FAQ
Re: Filter data on google charts extension
There is no standard solution for this, this will require a custom script.
-
-
- Posts: 3
- Joined: Mon Feb 27, 2023 1:59 pm
Re: Filter data on google charts extension
So this mysql filter can only contain a statically typed condition, no variable can be used there (in a non-script solution)?
Re: Filter data on google charts extension
The filter will be added as 'WHERE' clause, so technically it can also be a PHP variable.
$sql = "SELECT * FROM `TABLE` WHERE $filter";
-
-
- Posts: 3
- Joined: Mon Feb 27, 2023 1:59 pm
Re: Filter data on google charts extension
Thanks for the info.
marcin
marcin