[Résolu] MySQL Query with Charts .js or Google Charts Template or View By User ID
This support ticket is created Il y a 2 années. There's a good chance that you are reading advice that it now obsolete.
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.
Tell us what you are trying to do? Perform MySQL query with Charts.js or Google Charts View/Template to return line or other chart for User ID data. OR... can this be done with Looping and styled with CSS using Charts.js or Google Charts?
Is there any documentation that you are following? If not Toolset solution will invest in wpDataTables.
Is there a similar example that we can see? NOT EXACTLY. Below example doesn't include charting, only tables., but plugin further can create charts from generated tables. Best example found -> "How to create editable tables in WordPress where users edit only own... " hidden link
For custom integration, you can include the example HTML from the desired charting tool on a page, and for the dynamic part, use the Toolset's classic/legacy view, to generate the raw data values, as needed.
For more personalized assistance around custom code, you can consider hiring a professional from our list of recommended contractors: https://toolset.com/contractors/
I realize that Toolset doesn't inherently integrate with Charts. I need an answer on the second inquiry. I can do custom integration of that in my theme. Can Toolset perform a MySQL query and create a table of results that I can use is more the question? Thanks.
You can use Toolset to perform a MySQL query and create a table of results indirectly, by using classic/legacy views. A view can query, posts, taxonomy terms, or WordPress users.
To use the classic/legacy views, please go to WP Admin -> Toolset -> Settings -> General and select the option "Show both the legacy and Blocks interface and let me choose which to use for each item I build" for editing experience.