With various types of data visualization plugins, we can easily create charts and graphs now. But how to fetch data from MySQL and create a graph? Chart and Graph has difference if considered too much lexically, but for this guide, they are equivalent. This is a clean guide to Create a Chart on WordPress From MySQL. That simply means lot of chances. You should open this guide as well – Create Graph From MySQL Data.
Create a Chart on WordPress From MySQL : Basics
First we need to prepare data :
1 2 3 | $title = str_replace(' ', '', $title); $data = explode(',', str_replace(' ', '', $data)); $datasets = explode("next", str_replace(' ', '', $datasets)); |
Where we want to display the data? Suppose a widget :
1 2 3 4 5 6 7 8 9 10 11 | function widget($args, $instance) { extract( $args ); // global $posttypes; $title = isset($instance['title']) ? apply_filters('widget_title', $instance['title']) : ""; $chartid = $instance['chartid']; $pretext = isset($instance['pretext'] ) ? apply_filters('widget_title', $instance['pretext']) : ""; $chart_type = $instance['chart_type']; $labels = $instance['labels']; $data = $instance['data']; $colors = $instance['colors']; $posttext = isset($instance['posttext'] ) ? apply_filters('widget_title', $instance['posttest']) : ""; |
The third part is using some Javascript graph library. Third is fetching the data from MySQL table, which basically we wrote in the older post.
Advertisement ---
Create a Chart on WordPress From MySQL : Make it Plugin
An easy example :
1 | https://github.com/AbhishekGhosh/WordPress-c3-d3-Chart-Plugin |
However, there are lot of Plugins which not only can fetch data from MySQL but can give Graph / Chart output from CSV files.
