Create a Chart on WordPress From MySQL

Abhishek Ghosh

By Abhishek Ghosh September 9, 2014 7:56 am Updated on October 5, 2014

Create a Chart on WordPress From MySQL

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 :

$title    = str_replace(' ', '', $title);
$data     = explode(',', str_replace(' ', '', $data));
$datasets = explode("next", str_replace(' ', '', $datasets));

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 :

    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']) : "";

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.

---

Create a Chart on WordPress From MySQL : Make it Plugin

An easy example :

https://github.com/AbhishekGhosh/WordPress-c3-d3-Chart-Plugin

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.

Tagged With wordpress template charts for mysql , wordpress generate chart from database , wordpress charts using mysql , plot mysql wordpress , mysql str_replace , mysql chart in wordpress , my sql chart wordpress example , linux web chart mysql data , generate graph mysql , create charts from wordpress database

Create a Chart on WordPress From MySQL

Create a Chart on WordPress From MySQL : Basics

Create a Chart on WordPress From MySQL : Make it Plugin

This Article Has Been Shared 9255 Times!

About Abhishek Ghosh

Here’s what we’ve got for you which might like :

Take The Conversation Further ...

Create a Chart on WordPress From MySQL : Basics

Create a Chart on WordPress From MySQL : Make it Plugin

This Article Has Been Shared 9255 Times!

About Abhishek Ghosh

Here’s what we’ve got for you which might like :

Articles Related to Create a Chart on WordPress From MySQL

Take The Conversation Further ...