Tutorial Google charts and mysql

[Pedro Guimarães]

Hi everyone,

Where can I find a good tutorial where I could see how to use data form database in my charts.

Eg. I want to grab some dates from DB and chart it. And somehow add a daterange filter.

Thanks

[asgallant]

The method you use depends largely on the server environment.  What scripting language are you working in?  In some cases, there are pre-built packages you can use that will handle most of the hard work for you, all you have to do is configure them.

[asgallant]

Well, I see in the other thread that you are using PHP.  There is a 3rd-party PHP library that implements a data source that you can use with the Query language (see it here: http://code.google.com/p/mc-goog-visualization/wiki/UserDocumentation, docs have examples).  If you don't want to use that, I'm not sure that there are any tutorials that will help you, but there are many threads on this forum that deal with the topic, and I can walk you through solutions.

[Pedro Guimarães]

Im using PHP, ive wasted 10h today trying to make a chart with dates (from DB) on X-axis controled by a filter like ChartRangeFilter but I couldnt make it :\

[Pedro Guimarães]

I've found a chart with dates in X-axis but when I implement the RangeChartFilter, despite I've dates (eg. "2012-1-20") it says that are strings and RangeChartFilter only works with date type.
Im getting crazy with this lol

[asgallant]

Oh, right...I answered that one in your other thread.  Did the solutions I posted there not work?

[Pedro Guimarães]

Im sorry, where did you answered?

[asgallant]

Answered in this thread.