Mysql With chart

[weibel]

 Hello,

I just download the javascript library, and I have a question regarding the connection of all components with Mysql, is there a simple way to json transport  for example in php.

Can we just use Ajax from jquery, if have you any example.

I tried the grid component that's run with jquery GetJson, but not graph

Thanks a lot for your help

Christophe

[Deepaa Pragaasam]

Hi Christophe,
 
It is possible to get data using  ajax from php. We have preparing a sample based on your requirement.
Will update the sample within one business day (10^th September 2015)
Regards,
Deepaa.

[weibel]

Hello,

Thanks for your answer, and find attached a zip file with the data.php and the text file is just the output in json format of the data.php

best regards

Christophe

Attachment: Archive_ab48341b.zip

[Deepaa Pragaasam]

Hi Cristophe,
We have analyzed the sample and found that you have missed to use query in the chart.To retrieve data from the datamanager query is important for rendering the chart .

 

 Code Snippet:

 

var data = new ej.DataManager({ url: "http://localhost/data.php/", crossDomain: true });
var query = new ej.Query();

[JS]

  

We have modified the data.php to obtain the Json data in array format as below.
[PHP]
 

I have attached the sample for your reference
Sample

Screenshot:
Chart rendered from data MySQL transported using PHP 
 

Please let us know if you have any concern
Regards,
Deepaa.

[Chad Church]

Hello Joshua,

 

Find bellow the link from the forum :

https://www.syncfusion.com/forums/120170/mysql-with-chart

 

I tried the example they send me, I just change the mysql configuration, and the grid i working not the chart.

 

Thanks for your help

Christophe

[Sanjith Kesavan]

Hi Christophe,
Thanks for your reply. Please let us know if you need further assistance on this.

Regards,
Sanjith K.

[Sanjith Kesavan]

Hi Christophe,
Please ignore the previous response.
 
Regards,
Sanjith K.