Show a JSON array into a JQPLOT (Beginner)

Question

I'm just a beginner and I want to show data from my database (MySQL) and display it in a line chart using JQPLOT. I have a PHP file that takes the data from the database and converts it into a JSON array which, as I understand, is what JQPLOT needs to display it properly. The problem I'm having is that I've never used AJAX before.

The JQPLOT website gives me this code:

$(document).ready(function(){

  var ajaxDataRenderer = function(url, plot, options) {
  var ret = null;
  $.ajax({

    async: false,
    url: url,
    dataType:"json",
    success: function(data) {
      ret = data;
    }
  });
  return ret;
 };

// The url for our json data
var jsonurl = "./jsondata.txt";


var plot2 = $.jqplot('chart2', jsonurl,{
  title: "AJAX JSON Data Renderer",
  dataRenderer: ajaxDataRenderer,
  dataRendererOptions: {
    unusedOptionalUrl: jsonurl
  }
});
});

I don't understand the second half of this code, but I want to know how I can incorporate my PHP file (that contains the json array) into this code and display a line chart. Or maybe if anyone has a simpler code where I can implement the PHP file and still able to show the line chart? Im just very new at this, please help.

mprabhat · Accepted Answer · 2012-04-16 03:51:29Z

1

The first part loads the data and the second part displays the data.

Now to explain further if you have downloaded jQPlot you will see there is one file called as jSonData.txt which contains an array, in the second part you use that array to display the chart.

You can do it differently, say in your PHP code you load the data from your database(MYSQL) and send it back as JSON, just pass this JSON retrieved to the jQPlot

the above code in that case will look like this:

var plot2 = $.jqplot('chart2', myJsonDataRetrievedFromDB,{

answered Apr 16, 2012 at 3:51

mprabhat

20.3k7 gold badges49 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1335412 Over a year ago

Thanks for the response!! 'myJsonDataRetrievedFromDB' is a defined variable? or do i have to define it?

mprabhat Over a year ago

you will define this variable and when you load your data from server this variable will hold the response(JSON response)

Collectives™ on Stack Overflow

Show a JSON array into a JQPLOT (Beginner)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related