Okay , firstly I want to thank you for the fast response. Yes, Im using java and I have a bit more knowledge now from what I had yesterday regarding this. The thing that I need to do is to use Ajax somehow, but don't know how.. I don't wanna change anything in the database, just pull out the values to put it in a google chart which displays them depending on choice in the HTML-dropdown. Should I re-do the dropdown in Javascript instead or what?
Den tisdagen den 18:e juni 2013 kl. 18:17:00 UTC+2 skrev asgallant: > > You are using java, right? If so, the you can use the API I linked above > to hook into your database and handle the queries. You use a SQL-like > language in javascript to query the data source API. None of this requires > any changes to your database, nor does it require PHP. > > On the javascript end of things, the Visualization API takes the data > returned by the query and inputs it into a DataTable object (which is the > data structure required by the charts). There isn't any way to plug the > charts directly into your MySQL database if that is what you were hoping > for. > > On Tuesday, June 18, 2013 4:10:23 AM UTC-4, Benjamin Bandali wrote: >> >> But I have used SQL, and this doesent seem to work with it? I mean it >> implements a new data table, I wanna use the exisiting one that I created >> in mySQL and intregate it with Google Charts. Are there any ways? Without >> php. >> >> Den måndagen den 17:e juni 2013 kl. 18:29:24 UTC+2 skrev asgallant: >>> >>> There is a Java datasource library that might be helpful for you: >>> https://developers.google.com/chart/interactive/docs/dev/dsl_intro. It >>> implements the SQL-like Query API for fetching data for a visualization. >>> >>> On Monday, June 17, 2013 8:47:28 AM UTC-4, Benjamin Bandali wrote: >>>> >>>> I have this database with this table that I want to put in on my .jsp >>>> page that I coded in basic HTML. The project is in Spring mvc. >>>> >>>> CREATE TABLE `status` ( >>>>> `idStatus` int(11) NOT NULL AUTO_INCREMENT, >>>>> `timeStamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, >>>>> `value` varchar(45) NOT NULL, >>>>> `unit` varchar(45) NOT NULL, >>>>> `idCategory` int(11) NOT NULL, >>>>> PRIMARY KEY (`idStatus`), >>>>> UNIQUE KEY `idStatus_UNIQUE` (`idStatus`), >>>>> KEY `timeStampIndex` (`timeStamp`), >>>>> KEY `statusTocategory_idx` (`idCategory`), >>>>> CONSTRAINT `statusTocategory` FOREIGN KEY (`idCategory`) REFERENCES >>>>> `category` (`idCategory`) ON DELETE NO ACTION ON UPDATE NO ACTION >>>>>> >>>>>> ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8$$ >>>>> >>>>> >>>> So far I can get the basic google line chart on the webpage, but not >>>> with the values. I want it o show the Value based on time. >>>> This is the code I have so far: >>>> >>>> <head> >>>> <script type="text/javascript" >>>> src="https://www.google.com/jsapi";></script><script type="text/javascript"> >>>> google.load("visualization", "1", { >>>> packages : [ "corechart" ] >>>> }); >>>> google.setOnLoadCallback(drawChart); >>>> function drawChart(serverData) { >>>> >>>> var serverData = [ [ 'Year', 'Sales', 'Expenses' ], >>>> [ '2004', 1000, 400 ], [ '2005', 1170, 460 ], >>>> [ '2006', 660, 1120 ], [ '2007', 1030, 540 ] ]; >>>> var data = google.visualization.arrayToDataTable(serverData); >>>> >>>> var options = { >>>> title : 'Company Performance' >>>> }; >>>> >>>> var chart = new google.visualization.LineChart(document >>>> .getElementById('chart_div')); >>>> chart.draw(data, options); >>>> }</script> >>>> </head> >>>> >>>> >>>> >>>> How can I replace the Serverdata inputs with Value over time? (I don't >>>> have any knowledge in php) The google code is in javascript, but does it >>>> work to merge it with pure java or php code? Please help! >>>> >>>> -- 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.
