Real time Google charts with MySql -

i'm doing little web-survey have form when submitted has data stored in mysql table. on same website have couple of google pie charts. easiest way data database , pass google javascript code? i've been told i'd need create php file stores data array , returns json string. there better way it?

google query allow query google spreadsheets. if have mysql database, need use whatever method (php likely) return json object, , feed in google.

there many ways this, please see documentation on datatable notation , how input data it.