Ashu0007
Posts: 2
Joined: Thu Mar 03, 2022 11:20 am

how to search month wise data pie chart in php mysqli

how to search month wise data pie chart in php mysqli . have any idea if yes so plz send me code.
mateusz.b
Posts: 2006
Joined: Tue Jul 13, 2021 11:34 am

Re: how to search month wise data pie chart in php mysqli

Hi Ashu0007,

Welcome to our forum and thanks for contacting us with your question!

On this forum we provide support strictly related to Highcharts, so if you want to learn how to get data from your DB or how to create sql queries, you should head over to related sources of knowledge or Stack Overflow. To build a pie chart, you need to make sure that your data fits formats specified here:
https://api.highcharts.com/highcharts/series.pie.data
If the initial format of your data is differnt, you will most likely have to parse your data.

Let me know if you have any further questions.
Regards!
Mateusz Bernacik
Highcharts Developer
Ashu0007
Posts: 2
Joined: Thu Mar 03, 2022 11:20 am

Re: how to search month wise data pie chart in php mysqli

ok thanks but i have done my query
mateusz.b
Posts: 2006
Joined: Tue Jul 13, 2021 11:34 am

Re: how to search month wise data pie chart in php mysqli

Hi Ashu0007,

Glad to hear that. If you get data successfully with you query, the next step is to make sure that your data fits either of the formats specified in API: https://api.highcharts.com/highcharts/series.pie.data

If it is correct, then you can pass your data directly to series.data or use methods like series.setData()

Feel free to ask any further questions.
Regards!
Mateusz Bernacik
Highcharts Developer

Return to “Highcharts Gantt”