Ok, move the PHP code that generates your data to another page, and use AJAX to fetch the data from that script. This will allow you to refresh the chart data without reloading the page. I find jQuery's AJAX functions particularly helpful for this: http://api.jquery.com/category/ajax/
Your code might look something like this: https://groups.google.com/d/msg/google-visualization-api/XS4xaEgkRtw/ClBcYNMDkt4J To make that work, you need to put the data into a json format the charts can understand. PHP's json_encode() function can help you with this. Here's an example script: https://groups.google.com/d/msg/google-visualization-api/Gy18YdVSSfQ/tKdtzSfqKlcJ On Thursday, April 19, 2012 12:12:05 PM UTC-4, Xtremer wrote: > > No I am using php/mysql to retrieve data then I am just feeding that data > into charts and refreshing this whole page every minute, what I actually > want is to refresh just the graph every minute not the whole page. > > On Thursday, 19 April 2012 12:10:14 UTC-4, asgallant wrote: >> >> Do you use the visualization Query API for retrieving your charts' data? >> >> On Thursday, April 19, 2012 12:00:15 PM UTC-4, Xtremer wrote: >>> >>> >>> Hi >>> I need help in auto refreshing the annotated time line chart. I created >>> the chart by populating data from DB using php/mysql, I want to ad the >>> functionality of auto refresh data without having to refresh the whole >>> page. I tried searching a lot on google but could not get a solution. Would >>> appreciate your help as your post say that you already have this refresh >>> feature working. >>> >>> Help please. >>> >>> On Monday, 22 September 2008 17:31:22 UTC-4, Aerodyno wrote: >>>> >>>> The annotated timeline chart is great, but the whole chart redraws and >>>> blinks/flashes even when I add just a single point to the data.table >>>> and call refresh. This creates an annoying user experience. >>>> >>>> Is there any way to just update a single point in the chart -- without >>>> the massive redraw? Am I missing something (should I be using some >>>> data api) or do we need to wait for google to release the feature? >>>> >>>> Thanks in advance! I love writing code using Google's API's. >>>> >>>> - Savraj >>>> >>> >>> On Monday, 22 September 2008 17:31:22 UTC-4, Aerodyno wrote: >>>> >>>> The annotated timeline chart is great, but the whole chart redraws and >>>> blinks/flashes even when I add just a single point to the data.table >>>> and call refresh. This creates an annoying user experience. >>>> >>>> Is there any way to just update a single point in the chart -- without >>>> the massive redraw? Am I missing something (should I be using some >>>> data api) or do we need to wait for google to release the feature? >>>> >>>> Thanks in advance! I love writing code using Google's API's. >>>> >>>> - Savraj >>>> >>> >>> On Monday, 22 September 2008 17:31:22 UTC-4, Aerodyno wrote: >>>> >>>> The annotated timeline chart is great, but the whole chart redraws and >>>> blinks/flashes even when I add just a single point to the data.table >>>> and call refresh. This creates an annoying user experience. >>>> >>>> Is there any way to just update a single point in the chart -- without >>>> the massive redraw? Am I missing something (should I be using some >>>> data api) or do we need to wait for google to release the feature? >>>> >>>> Thanks in advance! I love writing code using Google's API's. >>>> >>>> - Savraj >>>> >>> >>> On Monday, 22 September 2008 17:31:22 UTC-4, Aerodyno wrote: >>>> >>>> The annotated timeline chart is great, but the whole chart redraws and >>>> blinks/flashes even when I add just a single point to the data.table >>>> and call refresh. This creates an annoying user experience. >>>> >>>> Is there any way to just update a single point in the chart -- without >>>> the massive redraw? Am I missing something (should I be using some >>>> data api) or do we need to wait for google to release the feature? >>>> >>>> Thanks in advance! I love writing code using Google's API's. >>>> >>>> - Savraj >>>> >>> >>> On Monday, 22 September 2008 17:31:22 UTC-4, Aerodyno wrote: >>>> >>>> The annotated timeline chart is great, but the whole chart redraws and >>>> blinks/flashes even when I add just a single point to the data.table >>>> and call refresh. This creates an annoying user experience. >>>> >>>> Is there any way to just update a single point in the chart -- without >>>> the massive redraw? Am I missing something (should I be using some >>>> data api) or do we need to wait for google to release the feature? >>>> >>>> Thanks in advance! I love writing code using Google's API's. >>>> >>>> - Savraj >>>> >>> >>> On Monday, 22 September 2008 17:31:22 UTC-4, Aerodyno wrote: >>>> >>>> The annotated timeline chart is great, but the whole chart redraws and >>>> blinks/flashes even when I add just a single point to the data.table >>>> and call refresh. This creates an annoying user experience. >>>> >>>> Is there any way to just update a single point in the chart -- without >>>> the massive redraw? Am I missing something (should I be using some >>>> data api) or do we need to wait for google to release the feature? >>>> >>>> Thanks in advance! I love writing code using Google's API's. >>>> >>>> - Savraj >>>> >>> >>> On Monday, 22 September 2008 17:31:22 UTC-4, Aerodyno wrote: >>>> >>>> The annotated timeline chart is great, but the whole chart redraws and >>>> blinks/flashes even when I add just a single point to the data.table >>>> and call refresh. This creates an annoying user experience. >>>> >>>> Is there any way to just update a single point in the chart -- without >>>> the massive redraw? Am I missing something (should I be using some >>>> data api) or do we need to wait for google to release the feature? >>>> >>>> Thanks in advance! I love writing code using Google's API's. >>>> >>>> - Savraj >>>> >>> >>> On Monday, 22 September 2008 17:31:22 UTC-4, Aerodyno wrote: >>>> >>>> The annotated timeline chart is great, but the whole chart redraws and >>>> blinks/flashes even when I add just a single point to the data.table >>>> and call refresh. This creates an annoying user experience. >>>> >>>> Is there any way to just update a single point in the chart -- without >>>> the massive redraw? Am I missing something (should I be using some >>>> data api) or do we need to wait for google to release the feature? >>>> >>>> Thanks in advance! I love writing code using Google's API's. >>>> >>>> - Savraj >>>> >>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/FbLzzWpq1BEJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
