My problem wasnt getting data from mysql using Php. . . . . My problem is drawChart() is nt working with the json file . . . . . . I can get nd save a data in a json file. . .. . . But I doesnt know what is Exactly for for Bar chart or Column chart(Multiple Series)
On Tue, Oct 15, 2013 at 8:11 PM, asgallant <[email protected]>wrote: > Searching the forum for "php mysql" returns this > topic<https://groups.google.com/d/topic/google-visualization-api/-zapZe7dH7Y/discussion>as > the first result - it has a ton of different examples you can work with > as a starting point. > > > On Tuesday, October 15, 2013 10:35:50 AM UTC-4, Senthil kumar wrote: > >> PHP >> >> >> On Tue, Oct 15, 2013 at 8:03 PM, asgallant <[email protected]>wrote: >> >>> What programming or scripting language will you use on your server to >>> handle pulling data from MySQL? >>> >>> >>> On Tuesday, October 15, 2013 1:09:33 AM UTC-4, Senthil kumar wrote: >>> >>>> Nope,I dint find not even one example for this actually :( >>>> >>>> >>>> On Tue, Oct 15, 2013 at 8:57 AM, asgallant <[email protected]>wrote: >>>> >>>>> There are many threads on this forum with example code for doing that. >>>>> >>>>> >>>>> On Monday, October 14, 2013 10:33:01 PM UTC-4, Senthil kumar wrote: >>>>> >>>>>> If I put this in a drawChart () function it works fine but not from >>>>>> json file. . . . I mean I wanted to take data from mysql nd save in a >>>>>> json >>>>>> format nd draw using drawChart() function. . . . But It doesnt work. >>>>>> . . >>>>>> . Help me for that >>>>>> >>>>>> >>>>>> On Mon, Oct 14, 2013 at 6:53 PM, asgallant <[email protected]>wrote: >>>>>> >>>>>>> Here's an example: >>>>>>> >>>>>>> >>>>>>> { >>>>>>> "cols": [ >>>>>>> {"type": "string", "label": "Name"}, >>>>>>> {"type": "number", "label": "Value 1"}, >>>>>>> {"type": "number", "label": "Value 2"} >>>>>>> ], >>>>>>> "rows": [ >>>>>>> {"c": [{"v": "foo"}, {"v": 3}, {"v": 7}]}, >>>>>>> {"c": [{"v": "bar"}, {"v": 6}, {"v": 5}]}, >>>>>>> {"c": [{"v": "baz"}, {"v": 2}, {"v": 1}]}, >>>>>>> {"c": [{"v": "cad"}, {"v": 3}, {"v": 9}]} >>>>>>> ] >>>>>>> } >>>>>>> >>>>>>> Here's a jsfiddle you can play with to test this: >>>>>>> http://jsfiddle.net/asgallant/******U2xTn/<http://jsfiddle.net/asgallant/U2xTn/> >>>>>>> >>>>>>> >>>>>>> On Monday, October 14, 2013 9:12:38 AM UTC-4, Senthil kumar wrote: >>>>>>> >>>>>>>> Can I get that Json data format for Multiple series? >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Oct 14, 2013 at 6:17 PM, asgallant >>>>>>>> <[email protected]>wrote: >>>>>>>> >>>>>>>>> You want to use a ColumnChart then, not a BarChart. If you want >>>>>>>>> multiple series of data (the different colored bars), then you need >>>>>>>>> to add >>>>>>>>> additional columns of data in the DataTable; the DataTable should >>>>>>>>> contain >>>>>>>>> one domain column (x-axis), plus one value column for each data >>>>>>>>> series you >>>>>>>>> wish to have. >>>>>>>>> >>>>>>>>> >>>>>>>>> On Monday, October 14, 2013 1:28:29 AM UTC-4, Senthil kumar wrote: >>>>>>>>> >>>>>>>>>> Im getting Bar chart but Im nt wht I want with json. . . . Plz c >>>>>>>>>> the below Word document for the image file >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Mon, Oct 14, 2013 at 10:03 AM, asgallant < >>>>>>>>>> [email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> Creating a DataTable to use with a BarChart is no different from >>>>>>>>>>> creating a DataTable for a PieChart. Is there something specific >>>>>>>>>>> that is >>>>>>>>>>> giving you problems? >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Sunday, October 13, 2013 10:35:09 PM UTC-4, Senthil kumar >>>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>>> Asgallant: Can me help me? >>>>>>>>>>>> >>>>>>>>>>>> By using Google chart and My database(Mysql) I can draw a Pie >>>>>>>>>>>> chart but I could do the same with Bar chart. . . . . . I couldnt >>>>>>>>>>>> generate >>>>>>>>>>>> a json data according to generate a Bar chart nd other charts. . . >>>>>>>>>>>> . . . . >>>>>>>>>>>> I have attached my files with this mail. . . . . . . Plz help me >>>>>>>>>>>> to all >>>>>>>>>>>> charts using Mysql database and json >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Sun, Oct 13, 2013 at 8:16 PM, asgallant < >>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Most likely the answer is yes, you can use the Visualization >>>>>>>>>>>>> API on your client's website. There are exceptions to the >>>>>>>>>>>>> general rule, so >>>>>>>>>>>>> you should read carefully the Terms of >>>>>>>>>>>>> Service<https://developers.google.com/chart/terms>to make sure >>>>>>>>>>>>> you are not triggering any of the exceptions. >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Sunday, October 13, 2013 4:23:19 AM UTC-4, Senthil kumar >>>>>>>>>>>>> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> I wanted to use a Google Visualization api with Fusion data >>>>>>>>>>>>>> table in my Client Website. . . . Now My question is whether >>>>>>>>>>>>>> Terms and >>>>>>>>>>>>>> condition of Google allows me to do this? >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>> You received this message because you are subscribed to a >>>>>>>>>>>>> topic in the Google Groups "Google Visualization API" group. >>>>>>>>>>>>> To unsubscribe from this topic, visit >>>>>>>>>>>>> https://groups.google.com/d/**to********** >>>>>>>>>>>>> pic/google-visualization-**api/**t******** >>>>>>>>>>>>> ZE5XyVZwgc/unsubscribe<https://groups.google.com/d/topic/google-visualization-api/tZE5XyVZwgc/unsubscribe> >>>>>>>>>>>>> . >>>>>>>>>>>>> To unsubscribe from this group and all its topics, send an >>>>>>>>>>>>> email to google-visualization-api+**unsub********** >>>>>>>>>>>>> [email protected]. >>>>>>>>>>>>> To post to this group, send email to google-visua...@** >>>>>>>>>>>>> googlegroups.**c********om. >>>>>>>>>>>>> >>>>>>>>>>>>> Visit this group at http://groups.google.com/**group********** >>>>>>>>>>>>> /google-visualization-api<http://groups.google.com/group/google-visualization-api> >>>>>>>>>>>>> **. >>>>>>>>>>>>> For more options, visit https://groups.google.com/**grou****** >>>>>>>>>>>>> ****ps/opt_out <https://groups.google.com/groups/opt_out>. >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>> You received this message because you are subscribed to a topic >>>>>>>>>>> in the Google Groups "Google Visualization API" group. >>>>>>>>>>> To unsubscribe from this topic, visit >>>>>>>>>>> https://groups.google.com/d/**to******** >>>>>>>>>>> pic/google-visualization-**api/**t******ZE5XyVZwgc/unsubscribe<https://groups.google.com/d/topic/google-visualization-api/tZE5XyVZwgc/unsubscribe> >>>>>>>>>>> . >>>>>>>>>>> To unsubscribe from this group and all its topics, send an email >>>>>>>>>>> to google-visualization-api+**unsub******** >>>>>>>>>>> [email protected]. >>>>>>>>>>> To post to this group, send email to google-visua...@** >>>>>>>>>>> googlegroups.**c******om. >>>>>>>>>>> Visit this group at http://groups.google.com/**group******** >>>>>>>>>>> /google-visualization-api<http://groups.google.com/group/google-visualization-api> >>>>>>>>>>> **. >>>>>>>>>>> For more options, visit https://groups.google.com/**grou******** >>>>>>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>. >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> You received this message because you are subscribed to a topic in >>>>>>>>> the Google Groups "Google Visualization API" group. >>>>>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>>>>>>>> **to******pic/google-visualization-**api/**t**** >>>>>>>>> ZE5XyVZwgc/unsubscribe<https://groups.google.com/d/topic/google-visualization-api/tZE5XyVZwgc/unsubscribe> >>>>>>>>> . >>>>>>>>> To unsubscribe from this group and all its topics, send an email >>>>>>>>> to google-visualization-api+**unsub******[email protected]. >>>>>>>>> To post to this group, send email to google-visua...@** >>>>>>>>> googlegroups.**c****om. >>>>>>>>> Visit this group at http://groups.google.com/**group****** >>>>>>>>> /google-visualization-api<http://groups.google.com/group/google-visualization-api> >>>>>>>>> **. >>>>>>>>> For more options, visit https://groups.google.com/**grou****** >>>>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>. >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>> You received this message because you are subscribed to a topic in >>>>>>> the Google Groups "Google Visualization API" group. >>>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/** >>>>>>> to****pic/google-visualization-**api/**t**ZE5XyVZwgc/unsubscribe<https://groups.google.com/d/topic/google-visualization-api/tZE5XyVZwgc/unsubscribe> >>>>>>> . >>>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>>> google-visualization-api+**unsub****[email protected]. >>>>>>> To post to this group, send email to google-visua...@**googlegroups. >>>>>>> **c**om. >>>>>>> Visit this group at http://groups.google.com/**group**** >>>>>>> /google-visualization-api<http://groups.google.com/group/google-visualization-api> >>>>>>> **. >>>>>>> For more options, visit https://groups.google.com/**grou**** >>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>. >>>>>>> >>>>>> >>>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "Google Visualization API" group. >>>>> To unsubscribe from this topic, visit https://groups.google.com/d/**to >>>>> **pic/google-visualization-**api/**tZE5XyVZwgc/unsubscribe<https://groups.google.com/d/topic/google-visualization-api/tZE5XyVZwgc/unsubscribe> >>>>> . >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> google-visualization-api+**unsub**[email protected]. >>>>> To post to this group, send email to google-visua...@**googlegroups.** >>>>> com. >>>>> Visit this group at http://groups.google.com/**group** >>>>> /google-visualization-api<http://groups.google.com/group/google-visualization-api> >>>>> **. >>>>> For more options, visit >>>>> https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>> >>>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "Google Visualization API" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/** >>> topic/google-visualization-**api/tZE5XyVZwgc/unsubscribe<https://groups.google.com/d/topic/google-visualization-api/tZE5XyVZwgc/unsubscribe> >>> . >>> To unsubscribe from this group and all its topics, send an email to >>> google-visualization-api+**[email protected]. >>> To post to this group, send email to google-visua...@**googlegroups.com. >>> Visit this group at http://groups.google.com/** >>> group/google-visualization-api<http://groups.google.com/group/google-visualization-api> >>> **. >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "Google Visualization API" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/google-visualization-api/tZE5XyVZwgc/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
