It turns out getting the latest version of Microsoft SQL Server and Xampp is not as easy as using a MySQL server.
1. You need to install the Microsoft PHP drivers in apache 2. The drivers Microsoft publishes do not work, they were compiled with very old versions of VC++ so you need to Google the driver that matches your php compile version 3. Almost all the sql statements have changed for the latest Microsoft PHP drivers, use the *.chm help menu in the the Microsoft version to see the latest syntax Now that I can talk to my Microsoft SQL Database via my Apache server via PHP scripts, now I need to figure how to turn the data I retrieve from my tables into "json". <-- I'm guessing, I still have to read what Json is exactly. On Tuesday, August 26, 2014 6:56:33 AM UTC-7, Spark Plasma wrote: > > Hello Community, > Please excuse my nooobieness. > > I have an apache server running on an Ubuntu box that I'm testing my html > + php files. I've been able to get the example shown on > https://developers.google.com/chart/interactive/docs/php_example?csw=1 to > work successfully. > > I have a Microsoft SQL Server which has an x column and a y column (on a > seperate machine on my network). I've noticed there are various examples on > how to connect and query the sql server using my php script, but I'm having > a hard time finding an example which also reports the SQL data in Google > Charts. It appears I need the following scripts: > > -script to connect to my database > -script to query the database > -script to 'parse' into JSON<--not entirly sure how to do this ( quoted > from the 'getData.php File' example) > -script to pass the array into Google charts > > Any guidance would be greatly appreciated. > > -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-chart-api+unsubscr...@googlegroups.com. To post to this group, send email to google-chart-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-chart-api. For more options, visit https://groups.google.com/d/optout.
