How to Filter Dates from PHP MYSQL Database to Javascript to Chart JS

[@hackerprime9722]

Thank you so much for this. I made a few modifications so it will show the very last row from the database as the end date dynamically and then I found a tutorial online to subtract that date by one month so it will show a months worth of data by default. I did this since my table has at least 3 months of data and showing all of it all at once was not very user friendly or easy to digest visually. I really appreciate this tutorial and I hope you continue to do a great job.

[@TheFoubian]

thanks a lot for this clear turo

[@markusotte3442]

Thank you, perfekt!

[@charmquark0]

how would you go about the 50k values ( the Ajax) method. Would you say load the page first, then ask ajax for the data and update it once it has received it

[@ventussilaban]

Thank you so much sir

[@pramodsawant7310]

Thank you so much sir 😊 If there is no date in the database, will count zero appear in the chart?

[@gmusic8241]

Wooow, thanks 😊

[@raselmahmud1029]

28:14 where did you get myChart.update() function? is that build in fn?

[@ChartJS-tutorials]

Hi Rasel, thank you for your question. Yes the update() is a build in function from Chart.js which is designed to update the values of the chart.

[@dzjam75]

Can the entire code be downloaded somewhere? I checked the link in the description, but could not find it.

[@safiullah7184]

Please tell us about filtering with time as well.

[@ChartJS-tutorials]

Hi Safi, thank you for your question. Have you seen this video: kzbin.info/www/bejne/rJ7TZJawfMuqaLc

[@safiullah7184]

@@ChartJS-tutorials Yes I have checked it out I need specifically the time(input type="time") for filtering with date as well Thanks for your response

[@mindaugasl.9329]

@@safiullah7184 yes it would be helpful to have a date and time inputs combined. Is it possible?

[@TheShukladhvaj]

Sir, could you also please show an example using ajax with php where the data is filtered using dates. I am stuck as when I POST the dates using ajax, and use them to filter data on the server side, it doesn't work for some reason. If you could give an example, it would be really helpful. Thank you.

[@GalaMatrix]

What did u do at 17:39

[@ChartJS-tutorials]

You mean when the mouse leaves the screen? I clicked on the tab that opens Chartjs.org which was just outside of the recorded screen.

[@VinaySehgal-sb8nf]

provide source code?