0
I’m new around here and I could use some help.
I’m starting to develop an HTML Dashboard where it will contain charts and dynamic tables with PHP. I don’t have the content yet but I’m studying and testing with fictitious data locally.
I’m using Highchats to create the graphics, if you have another suggestion I’d like to thank you.
Okay, I’ll expose my goal and then the doubt
Objective: Make a dynamic graph that has a dropdown menu, where it will be a filter for the chart, all information will be brought in php from a database, both for the dropdown menu and for the graph generation.
Bank example:
Chart example:
This graphic is not dynamic, but this is what I want, in this example I did not do the Dropdown menu, but imagine that in this menu will have the names brought from the bank and when selecting a name the chart changes only with the information of that client.
'Cause then my doubt is exactly on how to do this.
Please give me a help how I can do this, if it is possible if you have any tutorial explaining, just show me the way or a solution.
Thank you very much and I hope I made myself understood.
Thanks in advance!
about suggestion of other graphics, like the APEXCHARTS. Regarding the user being able to update the chart, you can create a combo (with javascript) and every time there is a change of values in it, update the variable of your
SELECT: SELECT * FROM SALES WHERE USUARIO = '$Variable';– Edvaldo Lucena
vc could clarify, explain this combo better (with javascript). Thank you!
– Mateus Brandt
Basically you have to create a Combox with the data coming from the database, example : https://www.vivaolinux.com.br/topico/PHP/COMBOBOX-DINAMICO-PHP Then you have to create a javascript function so that every time there is a change in the combo a new SELECT will be triggered in the table
– Edvaldo Lucena
Thanks for the tips, I will research on the APEXCHARTS and the combobox, as soon as I have some results post, until now thank you. If anyone has other solutions or tips thank you tbm.
– Mateus Brandt