WP Plugin Stock Chart & mysql Database

Hi there,

You don’t need generate generateChartData function. You’re not generating the data but rather loading it.

You will definitely need loadJSON function, though. Put it anywhere in the JavaScript block. Then add it’s call within AmCharts.ready() enclosure.

The final code might look something like this:

AmCharts.loadJSON = function(url) {
  // create the request
  if (window.XMLHttpRequest) {
    // IE7+, Firefox, Chrome, Opera, Safari
    var request = new XMLHttpRequest();
  } else {
    // code for IE6, IE5
    var request = new ActiveXObject('Microsoft.XMLHTTP');
  }

  // load it
  // the last "false" parameter ensures that our code will wait before the
  // data is loaded
  request.open('GET', url, false);
  request.send();

  // parse adn return the output
  return eval(request.responseText);
};

var chartData = AmCharts.loadJSON('data.php');
var %CHART% = AmCharts.makeChart("%CHART%", {
	type: "stock",
    "theme": "none",
    pathToImages: "https://www.amcharts.com/lib/3/images/",

	dataSets: [{
			title: "Cloud Index",
			fieldMappings: [{
				fromField: "value",
				toField: "value"
			}, {
				fromField: "volume",
				toField: "volume"
			}],
			dataProvider: chartData,
			categoryField: "date"
		},

	],

	panels: [{

			showCategoryAxis: true,
			title: "Value",
			percentHeight: 70,

			stockGraphs: [{
				id: "g1",

				valueField: "value",
				comparable: true,
				compareField: "value",
				balloonText: "<a href="https://codex.www.ads-software.com/title">title</a>:<b><a href="https://codex.www.ads-software.com/value">value</a></b>",
				compareGraphBalloonText: "<a href="https://codex.www.ads-software.com/title">title</a>:<b><a href="https://codex.www.ads-software.com/value">value</a></b>"
			}],

			stockLegend: {
				periodValueTextComparing: "[[percents.value.close]]%",
				periodValueTextRegular: "[[value.close]]"
			}
		}

	],

	chartScrollbarSettings: {
		graph: "g1"
	},

	chartCursorSettings: {
		valueBalloonsEnabled: true
	},

	periodSelector: {
		position: "left",
		periods: [{
			period: "MM",
			selected: true,
			count: 1,
			label: "1 month"
		}, {
			period: "YYYY",
			count: 1,
			label: "1 year"
		}, {
			period: "YTD",
			label: "YTD"
		}, {
			period: "MAX",
			label: "MAX"
		}]
	},

	dataSetSelector: {
		position: "left"
	}
});

Hello and thank you for this great plugin and for the support!
I am also trying to fetch data located on a mysql database.
I wonder, where do I need to upload the ‘data.php’ file? Is it in the amCharts plugin folder or in my theme folder, or somewhere else maybe?
Thank you!

The location of the data.php file is not important. I suggest you put it into some other folder than amcharts code. It can reside in amcharts folder but it will be safer somewhere else in case you want to replace the whole amcharts folder while updating the version.

Ok, great, thanks a lot for your reply!
Then the path to the data.php file should be the path from the amcharts folder to the path chosen for the data.php file, is that right? In other words, if I leave the data.php file in the amcharts main folder, the path to the data.php file would simply be ‘data.php’ but if I put this file in an other folder, it would be for example ‘../example/data.php’?
Best regards,

No. It will be relevant to the web page you are showing the chart on. So to be perfectly on the safe side you probably want to use absolute URLs, be it withing amcharts or some other folder. I.e.:

‘/data/data.php’

or

‘/amcharts/data.php’

Makes sense?

Ok, I understand better now. Yes it makes sense, thanks again for your help!

Great.