Krish Patel Krish Patel - 1 year ago 91
MySQL Question

how to create a chart in angularjs with database data?

I am trying to creating a Bar chart.I'm using this bar chart as a reference Here.
this is my HTML part..

<body ng-app="app">
<div ng-controller="BarCtrl">
<canvas id="bar" class="chart chart-bar" width=100% height=25
chart-data="data" chart-labels="labels" chart-series="series"></canvas>

And this is my angularjs part...

angular.module("app",["chart.js"]).controller("BarCtrl", function ($http,$scope) {

$scope.labels = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul','Aug','Sep'];
$scope.series = ['Series A', 'Series B'];

$ = [65, 59, 80, 81, 56, 55, 40],
[28, 48, 40, 19, 86, 27, 90];

If I want my database data in $ and $scope.labels then what should I do?I'd try this
$ = [ [data[0],data[2],data[4],data[6]] , [data[1],data[3],data[5]] ];
but this is not a good way so what it could be?

php file is..

$er=new Connect();


$selct=mysql_query("SELECT * FROM stock");


echo json_encode($data);

Answer Source

What you need to do is:-

change while part like below:-

$data[0][]=$row['total_qnt']; $data[1][]=$row['old_quantity'];

then parse this json encoded data to array into your javascript code and pass to $

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download