$query = "SELECT department as department, COUNT(ID) as total FROM students GROUP BY department"; $result = $connect->query($query); if($result->num_rows > 0) { foreach($result as $data) { $department[] = $data['department']; $total[] = $data['total']; } }
How to update data in donut 🍩 chart via ajax call ? Basically I have date sorter on which I need to reflect data in chart,I am using ajax call but not get it how to show /update data in donut chart via ajax response
chart.js:19 Uncaught TypeError: n.slice is not a function I'm getting these errors. I just copied your code from GitHub and changed column names to mine
@@pitocms Im also curious of how to do multiple charts. I basically just added another PHP section calling to different stats and then put the same script section below but it only draws 1 table. How can i do multiple charts on one html page? Thank you in advance! Your way by far was the easiest I found online!
Very interesting! Good job
thank you dude i have been trying to solve this problem for 2 weeks
Thankkkkkkkkk youuuuuuuuuuuuu
Very good is working
Simple and powerful
🥳🥳❤️❤️❤️❤️❤️❤️❤️❤️
You are welcome 😊
Excellent tutorial
Thank you very much, You helped me more than a lot
You are most welcome.
mahadsanid engr
Thanks sr. i'was waiting for long time.
Most welcome
Thank you so much, it works for me
Glad to hear that
I love your video, you helped me, Graciass
Glad it helped!
Thank u thank u sooooo much its now worked.💐💐
You are welcome.
Thank you so much.
thank you so much sir..
You are most welcome.
Thank you so much sir, helped me a lot :)
Really helped me, thank you.
Glad it helped!
Helped me a lot. Thanks
You really help me...thanks
Nice Tutorial
Thank you.
Thank you very much sir , you saved me
Gracias por crear este video, me salvaste :)
Thanks. Btw, any tutorial for group bar chart?
Made my day...ty.
🙏 you saved me
very good
thank a lot
Sir, I am getting an error: "Warning: Invalid argument supplied for foreach() " What can I do about it
$query = "SELECT
department as department,
COUNT(ID) as total
FROM students
GROUP BY department";
$result = $connect->query($query);
if($result->num_rows > 0) {
foreach($result as $data) {
$department[] = $data['department'];
$total[] = $data['total'];
}
}
Can i use postgresql becoz i dont have sql installed??? please reply
Yes you can use postgresql almost same.
How to update data in donut 🍩 chart via ajax call ? Basically I have date sorter on which I need to reflect data in chart,I am using ajax call but not get it how to show /update data in donut chart via ajax response
thanks man
Please I help, SELECT... query is not working for me,when I execute it monthnames become null
Without see your query and database table not able to give you solution.
Do you have any thing so I can contact you ?email or facebook
I'm having the same problem. Did you find a solution?
@@pippin95310 no sorry
column names of database?
chart.js:19 Uncaught TypeError: n.slice is not a function
I'm getting these errors. I just copied your code from GitHub and changed column names to mine
Thank you sir, is it possible for multiple chart?
Yes, possible.
@@pitocms Im also curious of how to do multiple charts. I basically just added another PHP section calling to different stats and then put the same script section below but it only draws 1 table. How can i do multiple charts on one html page? Thank you in advance! Your way by far was the easiest I found online!
SQL query not working for me :( , #1054 - Unknown column 'Created' in 'field list'
Do you have created filed in your database table ?
nitido
do it with mvc
noted ✅
please cant you do the same with java
I lake of knowledge about Java. Sorry I will not.
@@pitocms ok sir
how to get real time data?
You have to use socket io.
Do it with laravel 8 please.
I will try.
sir sql code is not coming out for me
Without check what you did difficult to say what is the wrong 😕🤔
so many standards broken it ain even funny